Helpful Links:
Creating a Salesforce.com Data Server
Retrieve Deleted Records in Salesforce
Monday, May 29, 2017
How to query deleted records from Salesforce with ODI12c
In default, the ODI12c Salesforce connector will not allow you to query the deleted records in Salesforce. So that your connection will have visibility on the deleted records, you have to set deletedRowsBehavior=include in the properties of your JDBC connection. Example below:
In your mapping, add a filter ISDELETED = true. Example below:
Helpful Links:
Creating a Salesforce.com Data Server
Retrieve Deleted Records in Salesforce
Helpful Links:
Creating a Salesforce.com Data Server
Retrieve Deleted Records in Salesforce
Subscribe to:
Post Comments (Atom)
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...
-
If experiencing below error: oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java....
-
Error: oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLSyntaxErrorException: [FMWGEN][SForce JDBC Driver][S... -
Create a Variable to hold the Error Message. In this example, I am creating a Global Variable. In the Refreshing tab, enter the follow...
How to implement CDC feauture in Salesforce in ODI 12c. Source is MSSQL Server and target is Salesforce, we were trying to achieve incremental data in the salesforce. Did anyone try to implement it or any suggesgions. Please post
ReplyDeleteçorum
ReplyDeletekaraman
niğde
osmaniye
kuşadası
MGDG