Microsoft SQL Server is a Relational Database Management System (RDBMS) solution for storing and retrieving data.
Objects extracted
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 run data profiles on the following Microsoft SQL Server objects:
•Table
•View
You can view the profiling statistics in Data Governance and Catalog. The data profiling task runs profiles on the following data types for Microsoft SQL Server objects:
•BIGINT
•NUMERIC
•BIT
•DECIMAL
•INT
•SMALLINT
•TINYINT
•FLOAT
•REAL
•DATE
•DATETIME2
•SMALLDATETIME
•DATETIME
•TIME
•CHAR
•VARCHAR
•TEXT
•NCHAR
•NVARCHAR
•NTEXT
Sampling type
Determine the sample rows on which you want to run the data profiling task. You can choose one of the following sampling types for a Microsoft SQL Server catalog source:
- All Rows
- Limit N Rows
Data classification for Microsoft SQL Server objects
Configure data classification for Microsoft SQL Server catalog sources to classify and organize data in your organization. You can view the data classification results in Data Governance and Catalog.
Data Lineage
The following lineage data is available for Microsoft SQL Server assets:
•From table to view
•Stored Procedures linked to tables or views
•Functions linked to tables or views
•Procedure calling a procedure
•Procedure calling a function
For more information about data lineage, see Data Lineage in the Working With Assets help.