Re: DTS equivalent for Oracle

DA Morgan wrote:
> George wrote:
> > I have code (scripts) that perform manipulation on data and output to
> > text or excel. I'm looking to replace this with a package similar to
> > DTS in MSSQL. Does something like this exist as part of the Oracle
> > package ?
>
> If you are in the US doing so will almost undoubtedly put you in
> violation of Sarbanes-Oxley as you are terminating the audit trail.
> Check with your legal team and be very careful.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Daniel, your reply seems kind of a stretch considering the main object seems to be extracting data and placing it in files or spread sheets for customer use. Both actions are normally perfectly legal under SOX.  From a practical point of view SOX means whatever your auditors say is allowable. I know some auditors dislike heavy spreadsheet use by financial departments since past audits have shown that formula and calculation setup errors are common. Nevertheless, there is nothing in SOX that forbids their use.

IMHO -- Mark D Powell -- Received on Sun Oct 29 2006 - 01:12:47 CEST