MySQL

You can create a data pipeline that loads data from an on-premises MySQL database to a destination. To provide the information SnapLogic® AutoSync needs to connect to MySQL, select saved credentials that were created in the IIP.

After selecting MySQL as a source, you'll be asked to select a Groundplex that has connectivity to your on-premises MySQL database. The Connect to on-premises endpoints page provides details about limitations and constraints. When configuring your endpoint, you'll also need to select a column that contains the last updated timestamp. If no such column exists, create the column in the table and then select it when configuring this endpoint.

Supported Account types

The IIP provides multiple Account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list only includes compatible Accounts. AutoSync supports the following IIP Accounts:

Create your MySQL Account in the IIP or AutoSync Manager, using one of the following Account types:

  • MySQL Database Account
  • MySQL Dynamic Account

Known limitations

  • MySQL credentials cannot be created in AutoSync because they need an updated JDBC JAR file. As a work around, create the Account in the IIP and specify the correct JAR file. Learn more about configuring MySQL Accounts.

Configuration

To configure MySQL as a source:

  • Select Groundplex for MySQL: From the drop-down list, select a self-managed Snaplex that has connectivity to your on-premises MySQL instance.
  • Select existing credentials: From the drop-down list, select credentials created in the IIP.
  • Select schema: From the drop-down list, choose the source schema. AutoSync populates the list from your MySQL account.
  • Select tables to synchronize: From the drop-down list, choose a table to synchronize. For each table, you will also need to select a column with the last modified timestamp.
  • Select the column that tracks the last modified time: From the drop-down list, choose the column that stores the last modified date and time. If it does not exist, you must create it in the MySQL database.