Dilip - I think you are on the right track. I saw your post to Justin, and that is what what we often run into -- we give the users a report tool and hope they'll go away, but they come back and ask IS to create the reports. Here are the issues as I see them: 1. Users are developing more computer skills, but that only means they can dream of more than they can accomplish, which puts more pressure on IS. 2. You need to understand your user community, what their interests and skills are. If you can, support the power users and hope they will support and train the others. 3. It is good if all users can use the same tool. As a DBA you get to know when it produces bad SQL so you can fix problems quickly.
We have used what you are proposing quite a bit. Beyond views we have often created special tables either on Oracle or down on Access (even better) that pre-digest the data for the users. I always try to keep the Microsoft tools away from Oracle if possible. Someone on this planet probably understands how Microsoft really interacts with Oracle, but they haven't written a book, or if they have I haven't found it but I would buy that book in a minute. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, February 13, 2003 1:24 AM To: Multiple recipients of list ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_200321341253542145174067 Content-Type: text/plain; charset=us-ascii Hi Dennis, Actually lots of users are connecting to this database from remote locations and connections are very slow because of network. So these clever people wants some sqls/reports to be run from ODBC connection and get data into excel and then work on that data. So that they don't need to access database full day. Now I am suggesting them that we should create views in the database. Views definition will take care of report logic. And then through ODBC, they will just do 'select * from view_name' and get data in excel and carry on. Any better ideas ???? Thanks, ~Dilip [EMAIL PROTECTED] wrote: Dilip Sounds as if your management is deciding to get things under control. You can move your SQL into PL/SQL stored procedures and use ODBC to execute the stored procedure. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, February 11, 2003 5:59 AM To: Multiple recipients of list ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434 Content-Type: text/plain; charset=us-ascii Hi Guys, One simple ODBC question. Our management wants a set-up where user from remote location will access oracle database through ODBC connection, execute some sql scripts, download data into excel files and then do whatever reporting on that excel data. Now management wants all these sql scripts to be on database server only. Management says user should not have access to sql scripts. They should just click icons of their PCs and data should be there. Can somebody help. I haven't worked much on ODBC. Is it possible to execute server side sql scripts through ODBC connection and get data ? Thanks in advance for help. Regards, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy the best in Movies at http://www.videos.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now ! --=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434 Content-Type: text/html; charset=us-ascii Hi Guys, One simple ODBC question. Our management wants a set-up where user from remote location will access oracle database through ODBC connection, execute some sql scripts, download data into excel files and then do whatever reporting on that excel data. Now management wants all these sql scripts to be on database server only. Management says user should not have access to sql scripts. They should just click icons of their PCs and data should be there. Can somebody help. I haven't worked much on ODBC. Is it possible to execute server side sql scripts through ODBC connection and get data ? Thanks in advance for help. Regards, ~Dilip Get Your Private, Free E-mail from Indiatimes at face="Arial" size="2">http://email.indiatimes.com Buy the best in Movies at href="http://www.videos.indiatimes.com">http://www.videos.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to href="http://airsahara.indiatimes.com">http://airsahara.indiatimes.com and Bid Now ! --=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dilip7772002 INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy the best in Movies at http://www.videos.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now ! --=_MAILER_ATTACH_BOUNDARY1_200321341253542145174067 Content-Type: text/html; charset=us-ascii <P>Hi Dennis,</P> <P>Actually lots of users are connecting to this database from remote locations and connections are very slow because of network. So these clever people wants some sqls/reports to be run from ODBC connection and get data into excel and then work on that data. So that they don't need to access database full day. </P> <P>Now I am suggesting them that we should create views in the database. Views definition will take care of report logic. And then through ODBC, they will just do 'select * from view_name' and get data in excel and carry on.</P> <P>Any better ideas ????</P> <P>Thanks,</P> <P>~Dilip</P> <P> <BR><B><I>[EMAIL PROTECTED]</B></I> wrote:<BR><BR></P> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>Dilip<BR>Sounds as if your management is deciding to get things under control. You<BR>can move your SQL into PL/SQL stored procedures and use ODBC to execute the<BR>stored procedure.<BR><BR>Dennis Williams<BR>DBA, 40%OCP<BR>Lifetouch, Inc.<BR>[EMAIL PROTECTED] <BR><BR><BR>-----Original Message-----<BR>Sent: Tuesday, February 11, 2003 5:59 AM<BR>To: Multiple recipients of list ORACLE-L<BR><BR><BR>--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434<BR>C ontent-Type: text/plain; charset=us-ascii<BR><BR>Hi Guys,<BR><BR><BR>One simple ODBC question. Our management wants a set-up where user from<BR>remote location will access oracle database through ODBC connection, execute<BR>some sql scripts, download data into excel files and then do whatever<BR>reporting on that excel data. Now management wants all these sql scripts to<BR>be on database server only. Management says user should not ha! ! ve access to<BR>sql scripts. They should just click icons of their PCs and data should be<BR>there.<BR><BR><BR>Can somebody help. I haven't worked much on ODBC. Is it possible to execute<BR>server side sql scripts through ODBC connection and get data ? <BR><BR><BR>Thanks in advance for help.<BR><BR><BR>Regards,<BR><BR><BR>~Dilip <BR><BR>Get Your Private, Free E-mail from Indiatimes at<BR>http://email.indiatimes.com<BR>Buy the best in Movies at http://www.videos.indiatimes.com<BR>Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to<BR>http://airsahara.indiatimes.com and Bid Now !<BR><BR>--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434<BR>Content-Type : text/html; charset=us-ascii<BR><BR> <P>Hi Guys,</P><BR> <P>One simple ODBC question. Our management wants a set-up where user from<BR>remote location will access oracle database through ODBC connection, execute<BR>some sql scripts, download data into excel files and then do whatever<BR>reporting on that excel data. Now management wants all these sql<BR>scripts to be on database server only. Management says user should not<BR>have access to sql scripts. They should just click icons of their PCs and<BR>data should be there.</P><BR> <P>Can somebody help. I haven't worked much on ODBC. Is it<BR>possible to execute server side sql scripts through ODBC connection and get<BR>data ? </P><BR> <P>Thanks in advance for help.</P><BR> <P>Regards,</P><BR> <P>~Dilip <BR></P><BR> <HR> <FONT face=Arial size=2><B>Get Your Private, Free E-mail from<BR>Indiatimes at </FONT><A href="http://email.indiatimes.com/";><FONT<BR>face="Arial" size="2">http://email.indiatimes.com</A></B><BR>Buy the best in<BR>Movies at <A<BR>href="http://www.videos.indiatimes.com">http://www.videos.indiatime s.com</A><BR><BR>Bid for <B>Air Tickets @ Re.1</B> on Air Sahara Flights. Just log on to<BR><A<BR>href="http://airsahara.indiatimes.com">http://airsahara.india times.com</A><BR>and Bid Now !</FONT><BR><BR>--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434--<BR><BR >-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>-- <BR>Author: dilip7772002<BR>INET: [EMAIL PROTECTED]<BR><BR>Fat City Network Services -- 858-538-5051 http://www.fatcity.com<BR>San Diego, California -- Mailing list and web hosting services<BR>---------------------------------------------------------------- -----<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to! ! : [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>-- <BR>Author: DENNIS WILLIAMS<BR>INET: [EMAIL PROTECTED]<BR><BR>Fat City Network Services -- 858-538-5051 http://www.fatcity.com<BR>San Diego, California -- Mailing list and web hosting services<BR>---------------------------------------------------------------- -----<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR></BLOCKQUOTE><BR> <hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at </font><a href="http://email.indiatimes.com";><font face="Arial" size="2">http://email.indiatimes.com</a></b><br>Buy the best in Movies at <A href="http://www.videos.indiatimes.com";>http://www.videos.indiatimes.com</A> <br>Bid for <b>Air Tickets @ Re.1</b> on Air Sahara Flights. Just log on to <a href="http://airsahara.indiatimes.com";>http://airsahara.indiatimes.com</a> and Bid Now !</font> --=_MAILER_ATTACH_BOUNDARY1_200321341253542145174067-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dilip INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
