This article describes how DataGalaxy SQL Server 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 scope
The connector allows you to import the following metadata from SQL Server into a Database source:
- The set of schemas for a given database
- The content of the schemas: tables, views and columns
- Primary and foreign keys between tables
The extracted objects and their correspondences are detailed in the following table:
SQL Server Object | DataGalaxy Object | Comments |
| Schema | Model (Container) | |
| Table | Table (Structure) | Comments are uploaded to the DataGalaxy Technical Comment field. |
| View | View (Structure) | Comments are uploaded to the DataGalaxy Technical Comment field. |
| Column | Column (Field) | Name, data type (size and precision), description, order are returned when available. Comments are uploaded to the DataGalaxy Technical Comment field. |
| Primary Key | Primarey Key | This information will be used to link tables in DataGalaxy diagrams |
| Foreign Key | Foreign Key |
Configuration of a connection
DataGalaxy SQL Server connector uses the JDBC driver provided by Microsoft.
The following information is required to set up a connection:
Parameter | Mandatory | Description |
| Server | Yes | Server name |
| Instance | No | Name of the SQL Server instance |
| Port | Yes | Server port |
| Database | Yes | Limits the scope to the specified database |
| Schema | No | Limits the scope to the specified schema |
| User | Yes | |
| Password | Yes | |
| Advanced mode | No | Option to customize the JDBC URL used to connect |
Execution of the connector
To create a connection via the Online connector, the entry points are as follows:
From the Import button of the "Shortcuts" widget on the home screen of a client space or workspace
From the Import button of one of the modules when it is empty
From the Import button in the contextual menu of one of the modules, on the right side of the filtered views
From the Add a connection button in the Connector tab available in the workspace setup screen
You can optionally filter (by module, connector type or by using the search bar), then click on the desired technology: 
You then need to complete the login form using the login information described above to perform an import. For more details on the steps involved in running the Online connector, you can consult the following article: [HowTo] Running the Online Connector.
This technology is also available via the Desktop Connector, you can find more information on the procedure here: [How to] How to use the connector.
Releases
| Date | Plugin Version | DataGalaxy release | Desktop Connector version (minimum) | Description |
| 23/01/2026 | 5.0.5 | v3.302.1 | 5.15.4 | Orphaned handling feature bugfix for urn mode |
| 29/12/2025 | 5.0.4 | v3.296.1 | 5.15.4 | Orphaned handling feature bugfix for urn mode |
| 02/12/2025 | 5.0.2 | v3.285.3 | 5.15.3 | CVE fixes |
| 30/07/2024 | 4.0.0 | v3.63.0 | 5.0.4 | Migrated from java 11 to java 17 + CVE fixes |