Wednesday, April 26, 2017

Hello World

I have been an ETL Developer for over 5 years now and I am recently learning ODI12c. (I have used ODI11g for previous projects). My recent project involves the integration of Salesforce data with ODI. There are very few resources online involving the two so I'm compiling the challenges, issues and solutions I have gathered throughout my development. Hopefully, this would help guide others who have the same issues on their project.

Below is the link from Oracle announcing support for ODI12c + Salesforce as Source or Target:
https://blogs.oracle.com/proactivesupportDI/entry/odi_ps2_12_2_1

2 comments:

  1. Hello Kent,

    Do we have to buy the progress JDBC driver separately or does ODI come with this driver default?

    ReplyDelete
    Replies
    1. Hi,

      This release of ODI12c, 12.2.1.2.6, comes with its own driver for connection to Salesforce. You can find more info on this version from the following post in the oracle page: https://blogs.oracle.com/proactivesupportdi/odi-ps2-122126-now-officially-supports-salesforcecom-as-a-source-or-target

      Delete

Using a Variable to capture Error Messages in ODI12c Load Plans

Create a Variable to hold the Error Message. In this example, I am creating a Global Variable. In the Refreshing tab, enter the follow...