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
On Mon, Oct 19, 2009 at 10:43 AM, Dave Hatz daveh...@hatzventures.orgwrote:
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
Cameron,
Thanks for the info on setting up the user account. My programmers and I
use TOAD for all our Oracle Data access. I am not sure if she will have the
budget to go out and buy TOAD. Do you know of any other tools on the market
that she might be able to use?
Dave
Oracle SQL Developer is a pretty nice program for free.
Thank You
Dan Vega
danv...@gmail.com
http://www.danvega.org/
On Mon, Oct 19, 2009 at 11:29 AM, Dave Hatz daveh...@hatzventures.orgwrote:
Cameron,
Thanks for the info on setting up the user account. My programmers and I
use TOAD for
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
As Dan suggested, you can suggest Oracle SQL Developer to her. Honestly
though if she really is a Data Analyst and her job is working with data
and databases for a living, she is likely to already have a favorite Oracle
toolset.
YMMV
-Cameron
On Mon, Oct 19, 2009 at 11:29 AM, Dave Hatz
Cameron,
I totally agree with you. I told her the same thing, I mentioned TOAD to her
and she said is that part of MS Access? So, I think she has a title with no
clue as to what she is doing, but I get paid to keep her butt happy. Thanks
for you input Cameron, much appreciated.
And Dan,
Remember to giver her only SELECT access though and find out what kind
of queries she is doing. If she is doing a lot of heavy load/poorly
written queries that slow down your server, you might be better off
with shipping her a weekly DB backup or something so she can run her
queries locally
There is a freeware version of Toad that should let her do basic data
extraction.
http://www.toadsoft.com/lic_agree.html
On Mon, Oct 19, 2009 at 8:29 AM, Dave Hatz daveh...@hatzventures.org wrote:
Cameron,
Thanks for the info on setting up the user account. My programmers and I
use TOAD
Honestly
though if she really is a Data Analyst and her job is working with data
and databases for a living, she is likely to already have a favorite Oracle
toolset.
Not necessarily. I work with a slew of Data Analyst's as we do a lot of
research, and the vast majority of the data
10 matches
Mail list logo