MS SQL Server to Oracle Applications

5 pts.
Tags:
Oracle applications
Oracle migration
SQL Server
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.

ASKED: November 17, 2009  9:16 PM
UPDATED: November 18, 2009  4:27 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds like a perfect job for a SQL Server Integration Services package.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Darryn
    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
    765 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following