ODI 14.1.2 Salesforce connectivity and options to handle Boolean data type columns

Question

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

RVohra · Answer

@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