About the MySQL connector plugin¶

The MySQL Connector (a Sidra plugin of type connector) enables seamless integration with MySQL enterprise relational database.

Sidra's connector for MySQL allows to configure a Data Intake Process from a MySQL data source in a fast and easy way. The resulting configured Data Intake Process extracts data from any table and view in the source database and loads it into the specified Data Storage Unit at regular intervals. It relies on the Sidra Metadata Model for mapping source data structures to Sidra as destination and uses Azure Data Factory as underlying data integration mechanism within Sidra.

When configuring and executing this plugin of type connector, several underlying steps are involved to achieve the following:

• The necessary metadata and data governance structures are created and populated in Sidra: Data Intake Process, Provider, Entities, Attributes and needed relations among these.
• The actual data integration infrastructure (ADF Pipeline) is created, configured, and deployed.

The resulting Data Intake Process is configured in less than five-minutes. Once the settings are configured and the deployment process is started, the actual duration of the data ingestion from the created pipelines may vary from few minutes to few hours, depending on the data volumes.

After starting the Data Intake Process creation, users will receive a message that the process has started and will continue in the background. Users will be able to navigate through Sidra Web as usual while this process happens.

Once the whole deployment process is finished, users will receive a notification in Sidra Web Notifications widget. If this process went successfully, the new data structures (new Entities) will appear in the Data Catalog automatically, and the Data Intake Process will appear in the Data Intake section including this new data source.

Supported MySQL server versions¶

The supported MySQL server version by this connector plugin is:

• MySQL 8.0.