User Guide: Configuring Source as My-SQL Database using Bizdata Universal API and Target as Salesforce
Overview
This guide provides a step-by-step walkthrough for configuring a MySQL database as the data source using Bizdata Universal API and Salesforce as the target. It explains how to establish database connectivity, extract records, process data, and transmit structured payloads to Salesforce.
The integration uses API-based communication to securely fetch data from MySQL and synchronize it with Salesforce business objects through an Integration Bridge.
When to Use
This configuration is suitable for organizations that need to transfer relational database data into Salesforce for CRM, reporting, or operational workflows.
- When synchronizing MySQL data with Salesforce
- When using Bizdata Universal API for database access
- When automated data transfer is required
- When scheduled integration jobs are needed
- When building no-code or low-code data pipelines
How It Works
The integration follows a structured workflow to move data from MySQL to Salesforce.
- User logs in to eZintegrations
- Creates an Integration Bridge
- Configures Bizdata Universal API as the source
- Connects to MySQL using credentials
- Extracts records using SQL queries
- Processes data using operations
- Constructs payload for Salesforce
- Delivers data through Salesforce API
How to Configure
Step 1: Login to eZintegrations
Log in to eZintegrations using your registered username and password.
Step 2: Create Integration Bridge
Navigate to the eZintegrations tab and click Add to create a new Integration Bridge.
Step 3: Select Source Type
On the source configuration screen, select the source type as API.
Step 4: Select Product and Business Object
Configure the source as follows:
- Product Name: Bizdata Universal API
- Business Object: MYSQL Database
Step 5: Configure Database Connection
Click on the Body attribute and enter the required database connection details. After configuration, click Test.
A status code of 200 indicates a successful connection.
Sample request body:
{
"username": "username",
"password": "password",
"query": "Select * from table name",
"schema_name": "data base name",
"hostname": "IP Address",
"portnumber": port number
}
Click Next to proceed.
Step 6: Configure Data Operations
Select the required operations based on business requirements.
Append operations can be used to construct the payload for the target system.
After configuring operations, click Next.
Step 7: Configure Data Target
Configure the target system as follows:
- Select Target Type as API
- Select Target Name as Salesforce
- Choose the required Salesforce business object
If the product name or business object is unavailable, create a new product and business object.
Update the API endpoint URL and required configuration details.
Modify the payload created in the operations section or pass the JSON data directly.
Click Next to continue.
Step 8: Save Integration Bridge
Enter the Integration Bridge name and description.
Configure the interval time or schedule time and submit the configuration.
Monitoring and Management
After submission, the Integration Bridge appears in the Integration Bridge list.
- Start or stop the integration
- Monitor execution status
- View source-to-target logs
- Analyze processing errors
Troubleshooting
- Connection Failed: Verify database credentials and network details.
- Status Not 200: Review API body configuration.
- Data Not Loaded: Validate SQL query and schema name.
- Invalid Payload: Check Append operation mapping.
- Integration Not Running: Confirm scheduling and activation status.
Frequently Asked Questions
What is Bizdata Universal API used for?
Bizdata Universal API is used to connect and extract data from MySQL databases through standardized API requests.
How do I verify database connectivity?
Click the Test button after configuring the request body. A status code of 200 confirms successful connectivity.
Can I use custom SQL queries?
Yes. Custom SELECT queries can be specified in the request body.
Is scheduling supported?
Yes. Integration Bridges can be configured with interval or scheduled execution times.
Where can I view execution logs?
Execution logs are available in the Integration Bridge list after deployment.
Notes
- Secure database credentials before deployment.
- Test all connections prior to production use.
- Validate SQL queries for performance.
- Review logs regularly for errors.
- Update payload mappings when Salesforce schema changes.
This guide enables reliable and automated integration between MySQL databases and Salesforce using Bizdata Universal API and eZintegrations Integration Bridge.
