Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 55 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
ODI 14.1.2 Salesforce connectivity and options to handle Boolean data type columns
Hi,
We have upgraded our ODI marketplace image on OCI from 12.2.1 to 14.1.2 recently.
Post upgrade, we noticed ODI 12.2.1 is handling Salesforce integrations differently compared to ODI 14.1.2.
Columns which has Boolean data in Salesforce e.g. True / False were extracted as 1/0 by ODI 12.2.1 where as same integration extracts values as
True / False in ODI 14.1.2.
Is there a way to tread all Boolean datatype columns as 1/0 in ODI 14.1.2? So that we don't need to change many odi integrations. We have also applied latest Salesforce JDBC driver using Patch 38703692 and still noticing the same issue.
Regards,
Surya
Answers
-
@Suryakss , Welcome to the Oracle Analytics Community!
This forum is about Oracle Analytics and related products.
You will be better served if you can put your question in OCI - General — Cloud Customer Connect/
Thanks
0
