 | |
Best way to Extract Data from Oracle into Excel
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||||
| |||||
|
Re: Best way to Extract Data from Oracle into Excel -
02-17-2005
, 04:40 PM
|
Hank wrote: I'm looking at ways to generate reports based on data in an Oracle database. This data will be viewed in Excel. "Generate"... Do you mean "run" instead? |
In other words do you plan to provide a possibility to construct the
SQL to those who will choose your way? Or they should just give the
parameters for your template statements?
"Excel"... What about other spreadsheet (i.e. KSpread)?
Quote:
|
I've looked at Oracle Reports and Oracle Discoverer as possible tools, but reports created in either of the 2 applications lose their formatting upon exporting to Excel. off-topic |
What you can do by excel and can't by discoverer?
</>
What sort of "formatting" you care of?
Quote:
|
Another method is to use VBA and ADO to connect to Oracle and extract the data directly into Excel where the reports can then be formatted. (oj)dbc |
Quote:
|
Does anyone have any ideas/comments regarding the above mentioned techniques? What other approaches are there? Portlets may be customized for Excel-like output. |
Quote:
|
Just a quick caution ... if your organization is subject to Sarbanes-Oxley doing so could be illegal. Be very very careful. |
cast your conception of "Sarbanes-Oxley" impact to us.
--
wbr,
not a thought-reeder [yet],
WS1-UANIC
P.S. To ignore you may want to replace the YOUSOKIND above with 'two
questions from a guy without the "majority" are not so much for you'
or anything u like better.
#12
| |||
| |||
|
|
Hello, I'm looking at ways to generate reports based on data in an Oracle database. This data will be viewed in Excel. I've looked at Oracle Reports and Oracle Discoverer as possible tools, but reports created in either of the 2 applications lose their formatting upon exporting to Excel. Another method is to use VBA and ADO to connect to Oracle and extract the data directly into Excel where the reports can then be formatted. Does anyone have any ideas/comments regarding the above mentioned techniques? What other approaches are there? Thanks in advance, H |
#13
| |||
| |||
|
|
Just a quick caution ... if your organization is subject to Sarbanes-Oxley doing so could be illegal. Be very very careful. Doing what, dear DA? Explain please... And... mmm... If YOUSOKIND, cast your conception of "Sarbanes-Oxley" impact to us. |
Numbers in a spreadsheet are used to make a financial decision. Can
you audit the source of those numbers? How they got there? And trace
them back to aggregates from specific financial transactions?
A copy of a spreadsheet is given to a financial analyst from a news
organization and reported to stockholders. Can you audit the source
of those numbers? How they got there? And trace them back to specific
financial transactions or inventory levels or valuations?
Can you guarantee the laptop containing them won't be stolen?
Can you guarantee the hard disk containing them is backed up?
Can you guarantee the versioning of every "SAVE" and audit the changes?
Would you be willing to go to jail if you were the CIO and some geek
in IT said "don't worry".
An increasing number of CFO's are saying "Hell no" and they are right.
I was at a meeting just earlier this week with a CFO whose organization
is not covered by Sarbanes-Oxley (they are a non-profit) and he was well
aware of the legal liabilities were that to apply: And so was his
attorney.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.