MySQL Server Data Connection Setup
Setting up a MySQL connection should only take 5-10 minutes.
There may be fees associated with setting up a new data connection. Please contact your account team to confirm pricing.
Pre-Implementation
To connect you will need the BUCS Remote Agent installed on the machine where your MySQL data is located. Remote Agent installation instructions can be accessed here.
Implementation
1. Connect to MySQL
Go to BUCS Customer Portal > Connection Management > Connection Hub. Locate or search for the MySQL connector and click Connect..
2. Name Connection
Enter a Name for your connection on the first page of the connection wizard and then click Next. The connection name should be descriptive and specific to the connection you want to establish.
3. Provide Connection Details
Provide your MySQL Username and Password and the Server Name and Database where your MySQL Server data is located. Enter the Application Name of the data source you are connecting. Click Save.
The Username and Password can be associated to an existing user or you can setup a new dedicated BUCS user in your MySQL account.
4. Connection Established
If the connection was established successfully, you will see a Connection Established message and data from your MySQL data source will continuously sync to BUCS. If the connection was not successful, you will be asked to try again.
NOTE: If you don't see your data appear in BUCS reporting in 24 hours, please contact your account team.