Unable To Use SOQL Date Function Within ODI Mapping with Source Datastore in Salesforce
(Doc ID 2417590.1)
Last updated on SEPTEMBER 04, 2020
Applies to:Oracle Data Integrator - Version 18.104.22.168.6 and later
Information in this document applies to any platform.
When attempting to use Salesforce Object Query Language (SOQL) in a Filter of an Oracle Data Integrator (ODI) Mapping where a source Datastore is coming from Salesforce, execution fails with the following error.
SOQL date literals work fine using Salesforce developer.
This is needed to extract data based on last N number of days from Salesforce.
- Create a Mapping that has Salesforce as source, and Oracle as target
- Use a Filter similar to the following:
The behavior would also arise if using other SOQL date literals, ie:
- TOMORROW, YESTERDAY, LAST_WEEK, etc... (note TODAY can be used, but not the other mentioned data literals)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document