Q
Problem solve Get help with specific problems with your technologies, process and projects.

Transferring Oracle data to DB2 tables

I have an Oracle9i database and DB2 database. I am in search of some simple and free ways to transfer my Oracle data to DB2 tables.
Have you looked at Heterogenous Services (HS)? This used to be called Transparent Gateways. With HS, you can query non-Oracle, like DB2, database through an Oracle database link. This also means that you can use the INSERT statement to push data to the non-Oracle database. The Oracle docs have all the information on how to set up and use HS.

Dig Deeper on Oracle data and application integration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close