You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

in OCI - General

Summary:

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 values were extracted as 1/0 by ODI 12.2.1 where as same integration extracts values as True / False in ODI 14.1.2.

We haven't made any specific customization to KMs of ODI 12.2.1 to treat boolean values as 1/0.

s there a way to extract in all Boolean datatype columns values from Salesforce 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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!