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

Reflecting changes to Oracle database in DB2 database

I have an Oracle database and a DB2 database on Mainframes. When I do any manipulations in the Oracle database these changes should also get reflected in the DB2 database on Mainframes. How do I achieve this?

I have an Oracle database and a DB2 database on Mainframes. When I do any manipulations in the Oracle database these changes should also get reflected in the DB2 database on Mainframes. How do I achieve this? Is it possible for data to be updated in the DB2 database once any changes occur in the Oracle database? Can the same also be done between SQL Server and DB2 residing on Mainframes?

The technology you'll want to leverage in Oracle is called Transparent Gateways (previously called Heterogenous Services). With Transparent Gateways, you can set up a database link from an Oracle database to a non-Oracle database, like DB2. Then you can create a trigger in your Oracle database that gets fired when a table is changed. The data changes can be sent to your DB2 database through this Transparent Gateway.

The Oracle documentation lists information on Transparent Gateways.

Dig Deeper on Oracle database design and architecture

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