Skip to main content

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

V1.png

2: create IB(Integration Bridge): To create Integration Bridge click on eZintegrations tab and then click on ‘Add’  


 

V2.png

 

3: Select Source Type as an API 

 

V3.png

 

4: Select Product name as “Bizdata Universal API” and Business Object as a “MYSQL Database 


V4.png

 


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 

} 


V5.png

Click next  


6: in the Operations select the operations according to the requirement 

V6.png

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 

 

V7.png  

 

And Target name as a Salesforce


V8.png 

And then select required business object 

 

V9.png

If product name and Business object not in the list, we can create new product name and Business object. 

 

V10.png

Change the end point URL and other details  

V11.png    

Change the payload which we created in operations or pass the JSON Data. 

 

V12.png

Click next  

9: Enter the Integrations bridge name and Descriptions to save. 

Fill the interval time or schedule time and submit. 


V13.png

 

 

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 . 


V14.png