4 Replies Latest reply: Aug 30, 2012 1:18 AM by 958945 RSS

    How to configure CDC for BIApss 7.9.6.2

    gmaldea
      Hi,

      Can anyone provide me a link / doc to show how to configure CDC in BI Apps 7.9.6.2. We are still using the Informatica mappings.

      Thanks
        • 1. Re: How to configure CDC for BIApss 7.9.6.2
          808802
          ODI is the tool will also be used to develop the ETL (or ELT) for Oracle BI Applications. ODI supports Changed Data Capture by its journalizing module.

          My understanding of CDC flow in ODI is as follows:
          ODI creates the Journal tables in the source database. The Journal tables store/publish the references to the changed data. The Journal table includes the unique identifier of the source table and also indicates the type of changes, Insert, Update, or Delete.

          ODI also generates and deploys the code in the source database for populating the journal tables. This can be simply a database trigger or the PL/SQL program that can retrieve log data from the database.

          During runtime, when the changes happen, the changes will be inserted into the Journal tables.

          The data are stored in the journal tables via a publish/subscribe model. Each subscriber will get its own changes and will need to consume the captured change.

          When all subscribers have consumed the changes, the changes will be deleted from the journal tables.

          thanks M
          • 2. Re: How to configure CDC for BIApss 7.9.6.2
            gmaldea
            Thanks M

            I guess there is no real CDC using the Informatica mappings
            • 3. Re: How to configure CDC for BIApss 7.9.6.2
              gmaldea
              I've raised on SR with Oracle about this issue, their reply states that CDC is not certified to be compatible with OBIA.
              • 4. Re: How to configure CDC for BIApss 7.9.6.2
                958945
                " I've raised on SR with Oracle about this issue, their reply states that CDC is not certified to be compatible with OBIA. "

                Any changes by now?