3 Replies Latest reply: Nov 29, 2013 2:46 AM by MikeN RSS

    GoldenGate for DB

    902923


      Hi experts,

      we have a replication requirement between oracle to DB2 database,  please help on this, can we use data transformation like mapping and filtering in goldengate between oracle to DB2 databases?  and the actual requirment is, there is 5 tables in source oracle database and some of the fields values from that 5 tables needs to replicat to single DB2 table  , is it possible in goldengate? kindly help on this.

      thanks in Advance.

        • 1. Re: GoldenGate for DB2
          MikeN

          902923 wrote:

           


          Hi experts,

          we have a replication requirement between oracle to DB2 database,  please help on this, can we use data transformation like mapping and filtering in goldengate between oracle to DB2 databases?  and the actual requirment is, there is 5 tables in source oracle database and some of the fields values from that 5 tables needs to replicat to single DB2 table  , is it possible in goldengate? kindly help on this.

          thanks in Advance.

           

          Yes, GoldenGate allows "heterogeneous" data replication; the source & targets can be any combination of (supported) databases on any (supported) platform. For instance, data capture from Oracle w/ replication to DB2 and/or MySQL and/or SQL Server... Or, data capture on DB2 and replication to Oracle (or MySQL or SQL Server, etc).  As far as GG is concerned, the "flavor" of the source & target system is largely irrelevant; there are only a few special considerations, e.g., you'll need a "source" definitions file & separate "target" definitions (instead of using "assumeTargetDefs"), and there are a few more features for Oracle-to-Oracle replication (e.g., DDL replication). But table/column mapping & filtering are certainly allowed for heterogeneous database replication.

          • 2. Re: GoldenGate for DB2
            902923

            Thanks a lot Mike,  Can you please confirm the below points that would be great help to start,

            1. Is it possible to do the bi directional replication between oracle to mainframe DB2 databases with filtering and mapping? is there any additional steps required for this?

            2. For Bi directional replication between oracle to mainframe DB2 ,  need to create definition file for both oracle and DB2 databases and transfer to each side is it right?

            3. Also , we can find profile check script for db2 database for linux, unix. and aix in MOS but can't execute the same script on mainframe environment , is there any separate script available for mainframe DB2 environment?

             

            Thanks in advance.

            • 3. Re: GoldenGate for DB2
              MikeN

              902923 wrote:

               

              Thanks a lot Mike,  Can you please confirm the below points that would be great help to start,

              1. Is it possible to do the bi directional replication between oracle to mainframe DB2 databases with filtering and mapping? is there any additional steps required for this?

              2. For Bi directional replication between oracle to mainframe DB2 ,  need to create definition file for both oracle and DB2 databases and transfer to each side is it right?

              3. Also , we can find profile check script for db2 database for linux, unix. and aix in MOS but can't execute the same script on mainframe environment , is there any separate script available for mainframe DB2 environment?

               

              Thanks in advance.

               

               

              Yes, bi-directional is possible in a heterogeneous replication scenario, with filtering, mapping, etc; see the topic in the docs on "bidirectional replication".

               

              The main point to consider is avoiding "loops", so that replicated data isn't re-replicated. The means by which each DB handles this is different; in some cases, data replicated by GG is automatically detected (e.g., via a trace table) or by ignoring changes applied by a designated user that just does replication (i.e., "excludeUser").  See the GoldenGate guide section on "preventing data looping".

               

              Data definition files would have to be created on each side, yes, and copied to the "other" side.

               

              For scripts used for checking the database before using GG, you probably should check with Support for the latest; I can't say for sure. For DB2 on z/OS (which is usually what "DB2 on mainframe means), you'd use Unix System Services to run GoldenGate, which provides the same ksh/bash shell environment as other linux/unix (aix, et al) environments for executing shell scripts.  (But do check with support for your options here.)