MySQL source

The MySQL source supports both cloud and on-premises endpoints. To connect to an on-premises database, your environment must have a self-managed Groundplex configured in the Classic Manager shared folder. Refer to Connect to on-premises endpoints for more information.

To use the Incremental load type, you'll need to select a column that contains the last updated timestamp for each table.

To support incremental load, a last modified column must:
  • Be one of the following types:
    • datetime
    • timestamp
  • Be non-nullable and have no null values, unless the environment is configured in Admin Manager to support nulls, as described in AutoSync settings.

Supported Snap account types

Create your MySQL Account in Classic Manager or AutoSync Manager, using the following account type:

  • MySQL Database 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 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.
  • Select the column that tracks the last modified time: To use Incremental or SCD2 load, select a column that tracks modifications. To use Full load, leave this field empty. Refer to Incremental load for more information.
  • Click Select another table to add another table to synchronize.