I had a situation like this where the client need to generate some numbers for ordering. I did this with MySQL and MS Access so you should (in theory) be able to do this with Oracle.
I created a read only account and had them install the MyODBC driver on their machine, Then I had them create a new table in Access then > New > Link Table > ODBC DataBase > Machine Data source > New And then created a data source pointing the MySQL server using the MySQL ODBC Driver and Access pulled in all the tables. >From there they could build and run queries, generate reports, export to Excel etc using a tool that they already knew. It was pretty slick actually. HTH G! On Mon, Oct 19, 2009 at 10:43 AM, Dave Hatz <daveh...@hatzventures.org>wrote: > > We have a client that has a data analyst on staff and would like access to > some of our tables to build her own data sets. Can I get recommendations > from the CF community on what my choices would be for this? We are running > Oracle Database for their application. > > Thanks, > Dave > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
