Helpful Links:
Creating a Salesforce.com Data Server
Retrieve Deleted Records in Salesforce
Showing posts with label IsDeleted=true. Show all posts
Showing posts with label IsDeleted=true. Show all posts
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:
Posts (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...