+ Start a Discussion
Julie CurryJulie Curry 

integration options commandline v Connect v direct integration


I'm not a developer so I was wondering if anyone could help me better understand what might be the best integration option for us.  We have a relatively simple set of data on a csv that we would like to have updated regularly in Salesforce.  There are only about 7 columns/fields in the dataset and all of them are to be updated in one object in Salesforce.  

A few options I'm seeing are 
1. using the csv with commandline and dataloader to set automated updates on a schedule.
2. connecting to our BDM and using Salesforce connect - we do want to report on the data so the report considerations here (https://help.salesforce.com/articleView?id=platform_connect_considerations_reports.htm&type=5) might be a deterrent.  
3. connecting to our BDM directly without using Salesforce connect.  

I was wondering if I could hear from others about which might make the most sense and why.  Also if there are other options that might make more sense than the above would love to hear those too.

Thanks in advance for your help!