You need to sign in to do that
Don't have an account?
Daily upsert FROM Active Directory to Salesforce
Currently we have a manual process where a SFDC Admin takes an exported file from Active Directory and upserts that into Salesforce.
This happens daily. We would like to automate this process. I have heard of solutions where people have used the free version of Jitterbit to do this and was curious if anyone here could enlighten me in this area. Possible alternatives are also welcome.
Thanks,
Hello, Rstrunk,
The officially supported tool for upserting data into Salesforce is the Data Loader[1]. Going this route allows you to leverage Salesforce Support should you run into any problems with the tool.
The general idea behind the automation (assuming you have a dedicated server on which you can install Data Loader) is:
If you do choose to use Jitterbit, the best way to get support for the free version is through the dedicated Jitterbit community[4].
[1]: Data Loader (http://www.salesforce.com/us/developer/docs/dataLoader/index.htm)
[2]: process (http://www.salesforce.com/us/developer/docs/dataLoader/index.htm)
[3]: batch mode (http://www.salesforce.com/us/developer/docs/dataLoader/index_Left.htm#StartTopic=Content/loader_batchmode_intro.htm)
[4]: Jitterbit community (https://getsatisfaction.com/dataloader)
Regards,
Satish Kumar