You can import data from MySQL to create source datasets in Anaplan Data Orchestrator (ADO). To import data, you need a connection to MySQL and either a pipeline or a connection extract.

You must first create a connection to MySQL with the MySQL connector in Data Orchestrator. Then use that connection to either create a pipeline or use a connection extract for data import.

Connectivity prerequisites

Before you can create a connection to MSSQL, you need to meet these prerequisites.

ItemNotes
MySQL account

You must have access to a MySQL account.

For example, the MySQL instance can be hosted on these cloud platforms: Amazon Web Services (AWS), Azure, Google Cloud Platform (GCP), or any other cloud provider.

Certificate Authority (CA) certificateAn unencrypted CA certificate in a Privacy-Enhanced Mail (PEM) format.
Database user

A database user with a password and permissions (at least read permission).

For example:

CREATE USER <user_name> IDENTIFIED BY 'your_password_here';
GRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *&ZeroWidthSpace;.* TO <user_name>;

Create a connection to MySQL

You need your MySQL credentials to connect the MySQL data with Data Orchestrator. See the MySQL documentation for more information.

To create a connection:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Connections on the left-side panel.
  4. Select Create connection.
  5. Select the MySQL connector and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  6. Enter these details on the Connection details screen, and then select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Enter a description about your connection.
  7. Enter your MySQL credentials on the Connection credentials screen, and then select Next.
    • Username: The MySQL user name required to authenticate.
    • Password: The MySQL password required to authenticate.
    • Host: The MySQL host domain. The host is provided by the administrator of your MySQL instance.
    • Port: The MySQL port number. The port number is provided by the administrator of your MySQL instance.
    • Database: The MySQL database name.
    • CA Certificate: The MySQL connector supports TLS/SSL encryption. TLS/SSL encryption enables you to establish a secure, encrypted connection to MySQL instances. It protects data in transit from being intercepted or read by unauthorized parties. The connection is secured using a digital certificate installed on the server. This provides an essential layer of data protection.

      For the connector to use the CA certificate, you must first decode the Base64-encoded CA certificate in the PEM format. For example:

-----BEGIN CERTIFICATE-----
MIIDBzCCAe+....................
.......multiple line...........
-----END CERTIFICATE-----

  1. After the connection test is complete, select Done.

Note: If you need to edit the connection, you must enter the CA certificate again.

Import data

You can import data from MySQL with a pipeline or a connection extract. Use the connection you created to configure the pipeline or connection extract.