You can use the Microsoft SQL Server catalog source to extract metadata from a Microsoft SQL Server source system. You can also run profiles and configure other capabilities, such as data classification.
Microsoft SQL Server is a Relational Database Management System (RDBMS) solution for storing and retrieving data.
Extracted metadata
You can use the Microsoft SQL Server catalog source to extract metadata from a Microsoft SQL Server source system.
Metadata Command Center extracts the following metadata from a Microsoft SQL Server source system:
•Database
•Schema
•Table
•View
•Column
- Primary Key
- Foreign Key
•Stored Procedure
•Function
•Trigger
•External Table
•External Column
• Objects created using an SQL Server linked server
Data profiling for Microsoft SQL Server objects
Configure data profiling to run profiles on the metadata extracted from a Microsoft SQL Server source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following objects:
•Table
•View
The data profiling task runs profiles on the following data types:
•BIGINT
•NUMERIC
•BIT
•DECIMAL
•INT
•SMALLINT
•TINYINT
•FLOAT
•REAL
•DATE
•DATETIME2
•SMALLDATETIME
•DATETIME
•TIME
•CHAR
•VARCHAR
•TEXT
•NCHAR
•NVARCHAR
•NTEXT
•UNIQUEIDENTIFIER
Compatible connectors
Before you configure a Microsoft SQL Server catalog source, you must connect to the Microsoft SQL Server source system.
Use the SQL Server connector to connect to the Microsoft SQL Server source system. For information about configuring a connection, see Connections in the Administrator help.