My SQL

The My SQL connector allows you to connect directly to MySQL, an open-source database. Once connected, you can create tabular assets that pull data from your source database into the platform.

Unlike storage connectors (e.g., Amazon S3 or Google Cloud Storage), which connect to data in files or object stores, the My SQL connector is a database connector that enables access to structured data stored in relational databases. It currently supports creating tabular assets and cannot be used as an export location.

Prerequisites

Before setting up a MySQL you must have the following information:

• Host – Your database host’s IP (e.g., 1.1.1.2) or domain (e.g., my.server.com)

• Port –

• Database ( Optional for SQL Server, required for Synapse Dedicated Pools) – Specify this to limit the connector’s scope or target a specific database

  • Minimum Role/Permission:

    • SELECT on information_schema + target tables

• Username and Password – Credentials for the user account with read access to the required data

• Firewall Rules – Ensure the platform’s IP ranges are permitted in your database

Creating the Connector

1. Navigate to Manage from the navigation bar.

2. Select Connectors to open the Manage Connectors screen.

3. Click Create Connector in the top right corner.

4. Enter a Name for your connector and an optional Description.

5. Select Type → My SQL:

6. Enter the required connection details:

   • Host

   • Port

   • Database (if applicable)

   • Username

   • Password

7. Add any Integration Metadata if needed for programmatic integration.

8. Click Create to save the connector.

9. Click Close to return to the Connectors screen.

Creating an Asset

To create a tabular asset using your My SQL

1. Select Create Asset from the navigation bar.

2. Choose Tabular as the asset type.

3. Select your My SQL connector from the list.

4. If your connector does not have a database specified, choose a database from the dropdown.

5. Select a Schema and Table/View.

6. Complete the remaining configuration steps and Release the asset.

Once released, the asset can be:

• Shared directly with other users

• Added to a data product

• Consumed via data sharing or integrations

The database user configured in the connector must have read access to all schemas and tables intended for asset creation. For best practice, use a service account created specifically for the platform integration, rather than a personal or admin account.