MS SQL Server to Oracle Applications
We have MS SQL Server Data and need to get into Oracle Applications.
Data Source – MS SQL database –
Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p]
Data to be loaded initially to STG table and then to GL journal interface table and concurrent request to load in GL.
Software/Hardware used:
Data Source – MS SQL database –
Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p]
Data to be loaded initially to STG table and then to GL journal interface table and concurrent request to load in GL.
Software/Hardware used:
ASKED:
November 17, 2009 9:16 PM
UPDATED:
November 18, 2009 4:27 PM
Answer Wiki:
Sounds like a perfect job for a SQL Server Integration Services package.
To see all answers submitted to the Answer Wiki: View Answer History.
There are many ways to skin this cat…….
Additional to SSIS:
1) Use an ETL tool (open-source ones available)
2) Create a view on your Oracle database of the SQL Server source data – requires installing odbc connectivity – then manipulate the data in Oracle and load into tables.
3) Flat files (not recommended, but easy to do).
etc etc