Connecting My-SQL to Salesforce Using Bizdata Universal API
User Guide: Configuring Source as My-SQL Database using Bizdata Universal API and Target as Salesforce
1: Login to eZintegrations: enter username and password
2: create IB(Integration Bridge): To create Integration Bridge click on eZintegrations tab and then click on ‘Add’
3: Select Source Type as an API
4: Select Product name as “Bizdata Universal API” and Business Object as a “MYSQL Database”
5: Click on Body attribute and fill in the necessary fields to connect the data base and then click “Test” button to see the connections response, If we get Status: 200 that mean we are successfully connected.
The body will have the following JSON Data:
{
"username": " username ",
"password": " password ",
"query": "Select * from table name",
"schema_name": "data base name",
"hostname": "IP Address",
"portnumber": port number
}
Click next
6: in the Operations select the operations according to the requirement
We can use append operations to make the payload for target. And click next.
7: In the Data Source: Select target type as a API
And Target name as a Salesforce
And then select required business object
If product name and Business object not in the list, we can create new product name and Business object.
Change the end point URL and other details
Change the payload which we created in operations or pass the JSON Data.
Click next
9: Enter the Integrations bridge name and Descriptions to save.
Fill the interval time or schedule time and submit.
After Submitting the Integrations Bridge we can see the bridge in Integrations Bridge list. We can start stop and see the logs file from Source to target .