Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Mapping from Oracle table to Salesforce table

3396166Oct 11 2017 — edited Jan 31 2018

Hi everyone

I have to perform a series of mapping on Oracle Data Integrator 12c between two technologies: Oracle and Salesforce.

In the current case, I would create a mapping between two Oracle sources (table A and table B) and the target Salesforce table (table C)

Each Oracle source tables have a key, useful to perform the join; the Salesforce target table has a rowid (I need to insert each new record on Saleforce) and the upsert key is a field different from rowid.

I have to execute this mapping in Incremental update mode toward Salesforce

Although in the Odi Project there are LKM and IKM, lot of them about Incremental Update are customized for other flows.

In the documentation, I read that there are not a specifici Km for integration on Salesforce, so I have to use the classic Lkm and Ikm.

When I try to import, I see something like these:

v.JPGvv.JPG

What kind of them I have to import in my Project in order to execute the loading from Oracle to Salesforce?

May some one suggest me what is the solution?

Did someone try that?

Besides, how can l populate the rowid?

thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2018
Added on Oct 11 2017
20 comments
1,825 views