function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
NishnaNishna 

Salesforce integration with ODI

Hello, 

 

I have to transfer data from a CSV file to SFDC through Oracle Data Integrator.

I have used the doc from

 www.artofbi.com/?dl_id=1 to set up the connection between file and SFDC.

The problem I'm actually facing is that, I do have the new objects  thats are being created in SFDC for each record in the csv filebut the data from the file are not transferred  to the newly created object in SFDC.

 

IKM File to Salesforce(Upsert) has been used in the ODI interface to load data from file to Salesforce.

The doc artofbi recommends ApexDataLoader as well as sforceDataloader.

 

Is sforceDataLoader no longer compatible with salesforce??

 

Any advice would be of great help.

 

Regards,

Nishna

a_ja_j

Hello,

 

Check page 9 (Setting-Up salesforce.com 3rd Party Software ---> Direction) of your document.

 

It is specified that SForceDataLoader is now an obsolete version, ApexDataLoader should be used,

though make use that SForceDataLoader is also installed in your system for the reasons that have been suggested.

 

 

regards,

asish
Carol LoudCarol Loud
I'm not sure, but you can try an alternative solution - the Skyvia cloud no code platform. Hope this helps (https://skyvia.com/connectors/salesforce)