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
Sapthagiri ReddySapthagiri Reddy 

Salesforce and JitterBit integration?

Hi,

I am trying to establish a connection between SQL and Salesforce, for which I have opted JitterBit. So, could anyone explain me what all are the things that are neede from both Salesforce and JitterBit respectively to have an syncronized connection established between them.
Satish_SFDCSatish_SFDC
In Jitterbit you will have to create a new Query. This prompts you to login to salesforce. It then retrieves a list of all objects, You select the source objects and then the destination. The destination can be a database as well (in which case you have to enter the database credentials. You will then have to select a table to load data into. 
If you want it to repeat multiple times, you create a schedule.

Regards,
Satish Kumar
Sapthagiri ReddySapthagiri Reddy
Will it be the same procedure if I want to have the data flow from MySQL database to Salesforce through JitterBit. In this case, what all would be needed to have this connection established. And we would want to have the data flow from MySQL database to Salesforce on daily basis, preferably at nights.

Regards
Satish_SFDCSatish_SFDC
Yes, it is the same process.
If you would like to automate the process, you will have to create a schedule.

Regards,
Satish Kumar