Submit a ticket My tickets
Welcome
Login  Sign up

MySQL Connector

This article describes how DataGalaxy MySQL connector works.

This connector is available in the following modes:

Desktop mode ✅SaaS Online mode ❌

This connector supports the following import modes:

Standard mode ✅URN mode

Connector Overview

MySQL connector imports metadata from a database into a DataGalaxy database source object.

The extracted objects and their correspondences are detailed in the following table:

MySQL Object
DataGalaxy Object
Comments
SchemaModel (Container)
TableTable (Structure)
ViewView (Structure) 
ColumnColumn (Field)Name, data type (size and precision), description, order are returned when available. Comments are uploaded to the DataGalaxy Technical Comment field.
Primary KeyPrimarey KeyThis information will be used to link tables in DataGalaxy diagrams
Foreign KeyForeign Key

Step 1 : Installation

  • Download DataGalaxy connector from the portal (see here)
  • Extract the connector archive in the directory of your choice
  • Download the MySQL plug-in from the portal and copy it into the /lib directory of the connector

Step 2 : Run MySQL connector

  • After starting the connector, access to Dictionary connectors:  
  • If it has been correctly installed, the MySQL plug-in appears in the list
  • The following information is requested: 
Parameter
Mandatory
Description
ServerYesMySQL Server name
PortYesMySQL Server port
InstanceYesMySQL instance name
UserYes
PasswordYes
Advanced modeNoOption to customize the JDBC URL used to connect

Once these information filled, you can test the connection and start the import.

Releases

DatePlugin
Version
DataGalaxy
release
Desktop Connector
version (minimum)
Description
23/01/20264.0.3v3.302.1
5.15.4Orphaned handling feature bugfix for urn mode
29/12/20254.0.2v3.295.15.15.4Orphaned handling feature bugfix for urn mode
06/09/20243.1.0v3.72.15.2.9Migrated from MySQL driver to MariaDB driver
06/08/20243.0.0v3.65.05.0.5Migrated from java 11 to java 17 + CVE fixes



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.