About the MS SQL Server collector
Use this collector for the following data sources:
MS SQL Server
Azure Synapse Analytics: Note that the collector currently only supports SQL databases with dedicated SQL pools.
Note
The latest version of the Collector is 2.159. To view the release notes for this version and all previous versions, please go here.
What is cataloged
The collector catalogs the following information.
Object | Information cataloged |
---|---|
Columns | Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, foreign), Column size, Column index |
Table | Name, Description, Primary key, Schema, Created date, Modified date |
Views | Name, Description, SQL definition |
Schema | Identifier, Created date, Modified date |
Database | Type, Name, Identifier, Server, Port, Environment, JDBC URL |
Functions | Name, Description, Function Type |
Stored Procedures | Name, Description, Stored Procedure Type |
Relationships between objects
By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.
Resource page | Relationship |
---|---|
Table | Columns |
Columns | Table |
Lineage for MS SQL Server
The following lineage information is collected by the Microsoft SQL Server collector.
Object | Lineage available |
---|---|
View | The collector identifies the associated column in an upstream view or table:
|
Stored Procedure | The collector identifies:
|
Authentication supported
The collector supports basic authentication to Azure Synapse Analytics and MS SQL Server.