The MySQL Synapse enables data synchronization between MySQL schema and Syncari entities. After the Synapse is authenticated, a user can activate the MySQL Synapse, which enables Syncari to replicate the schema of MySQL and make it available within the Unified Data Model. Using Sync Studio, a user can map MySQL tables to Syncari entities, and MySQL fields to Syncari fields.
If your MySQL security requires you to whitelist an IP you can find that here.
MySQL Information
You will need the following information from your MySQL administrator:
- Host Address
- Database Name
- User
- Password
Recommended process for creating a new database for use with Syncari
If you plan on connecting the synapse to a newly created database, our recommended process is to do the following:
Create a new dedicated Syncari sync user
CREATE USER 'newuser'@'host' IDENTIFIED BY 'password';Create a new database
CREATE DATABASE databasename;Grant permissions to the newly created user on the new database
GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'host';
Synapse Setup
Step 1: Start by logging in to your Syncari subscription
- Navigate to Synapses
- Find MySQL in the Synapse Library
- Drag the MySQL Synapse to the canvas
Step 2: Configure your Synapse parameters
- Enter
[Synapse Name]
This will be the label name for the Synapse in Syncari - Enter
[Host] - Enter
[Database Name] - Click "Next"
[OPTIONAL] Instantiate with Syncari entities - Enables Syncari to automatically create entities in MySQL
The "Instantiate with Syncari entities" option enables all the existing entities in Syncari to be created as tables in MySQL. This feature is useful if you want the schema from the Syncari Unified Data Model to be replicated in MySQL.
Talk to one of our Onboarding and Support Team members if you would like any clarification or a recommendation.
Step 3: Define your authentication parameters and authenticate:
- Enter
[User Name] - Enter
[Password] - Click "Save and Authenticate"
- Click "Next"
[OPTIONAL] Use SSL Connection - Select this option if the connection to your server requires SSL.
Step 4: Activate your Synapse
- Click "Make Synapse Active"
- Click "Close"
Congratulations! You have completed the setup of MySQL.
If you receive any errors message after clicking Authenticate, confirm each of the parameters in the previous steps are configured properly. If the error persists, contact one of our Onboarding and Support team members.
What's Next?
- Learn how to designate the Id and Watermark fields for MySQL Entities in Schema Studio.