Skip to main content

MySQL

Category: Direct connection

Relational database. Direct connection.

Expected input​

You add MySQL through the Add source wizard. Besides the general fields that apply to every source — Source name (unique, 2–45 characters; becomes the name of the linked service and the basis for the Key Vault secrets adf-{bronnaam}-…), type, integration runtime, credentials identical across all environments?, credential expiry date and tags — the MySQL form asks for the following connection fields:

Field (label)Description
HostServer name or IP address on which MySQL runs.
Database nameThe name of the specific schema/database you want to connect to.
PortThe database's listening port (default 3306).
User nameUsername of the database account.
PasswordPassword for that account.
  • Authentication: Basic — username + password.
  • Integration runtime: choose AutoResolveIntegrationRuntime (cloud) if the database is publicly reachable. If MySQL runs on-premises or behind a firewall, choose a self-hosted integration runtime (in the bundled template, pwccIntegrationRuntimeLinked). See Connecting a data source.
  • Secrets: the password (and the other connection details) are never stored by the frontend. They go to the customer's Azure Key Vault under the group adf-{bronnaam}-…; the linked service references them.

Requirements​

  • A database account with read-only rights (least privilege) on the relevant database — preferably use a dedicated service account rather than a personal or admin account.
  • For an on-prem/firewalled database: an installed and published self-hosted integration runtime that can reach the MySQL server.

Gathering the details​

These values come from your database administrator (DBA) or from the existing JDBC/ODBC connection string.

  • Host / Port — Host is the server name or IP address on which MySQL runs; Port is the database's listening port (default 3306). Found in the server configuration, or available from your DBA.
  • Database name — The name of the specific schema/database you want to connect to (visible via SHOW DATABASES; or from your DBA).
  • Username / Password — Preferably use a dedicated service account with read-only rights (least privilege) on the relevant database, rather than a personal or admin account.

Is the database behind a firewall or on-premises? Then an Integration Runtime is needed to establish the connection — see Connecting a data source.

Load types and delta​

MySQL supports the standard load types (FULL, DELTA, OVERWRITE, RELOAD, IMAGE, ADDITIONAL).

Two delta columns supported

MySQL supports — like the other SQL/database sources — two delta columns (comma-separated, same data type; the highest value counts). See Load types → Multiple delta columns.

Official documentation: MySQL Connector/J — Connection URL Syntax

See also: Integration catalog · All data source requirements · Integrations — overview