Microsoft Azure SQL Server is a managed cloud database.
Objects extracted
The metadata extraction service extracts the following objects from a Microsoft Azure SQL Server source system:
•Database
•Schema
•Table
•View
•Synonym (local, public)
•Function
•Procedure
•Package
•Trigger
•Column
- Primary Key
- Foreign Key
- Unique
•External Table
•External Column
Prerequisites for configuring the Microsoft Azure SQL Server catalog source
Use the SQL Server connector to connect to Microsoft Azure SQL Server source system. For information about configuring a connection in Administrator, see Connections in the Cloud Common Services help.
Configure permissions
This section addresses permissions for configuring the Microsoft Azure SQL Server source system. Before you configure a Microsoft Azure SQL Server catalog source, configure the permissions for the Microsoft SQL Server database user account that you use to connect to Microsoft SQL Server. Verify that the user account that you use to connect to Microsoft SQL Server is an SQL Server login account. Configure the VIEW DEFINITION permission for the user account. This permission lists all the schemas from where the user can load metadata.
Permissions to extract metadata
To extract metadata from Microsoft Azure SQL Server, grant the following permissions before you configure the catalog source:
- select on sys.all_columns
- select on sys.all_objects
- select on sys.all_parameters
- select on sys.databases
- select on sys.database_principals
- select on sys.foreign_key_columns
- select on sys.indexes
- select on sys.index_columns
- select on sys.partitions
- select on sys.schemas
- select on sys.sql_modules
- select on sys.synonyms
- select on sys.types
- select on sys.tables
- select on sys.table_types
Permissions to run data profiles
To perform data profiling on Microsoft Azure SQL Server, grant SELECT permissions for tables and views that you want to profile.
Data profiling for Microsoft Azure SQL Server objects
Configure data profiling to run profiles on the metadata extracted from a Microsoft Azure SQL Server source system. You can run data profiles on the following Microsoft Azure 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 Azure 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 Azure SQL Server catalog source:
- All Rows
- Limit N Rows
Data classification for Microsoft Azure SQL Server objects
Configure data classification for Microsoft Azure SQL Server catalog sources to classify and organize data in your organization. You can view the data classification results in Data Governance and Catalog.
Connection properties
When you configure a connection to Microsoft Azure SQL Server in Administrator, you can view the connection properties for that connection on the Registration page in Metadata Command Center.
The following table describes the Microsoft Azure SQL Server connection properties:
Property
Description
Runtime Environment
The execution platform that runs tasks. The runtime environment is either a Secure Agent or a serverless runtime environment.
Username
User name to connect to the Microsoft SQL Server database.
Host
Host name or IP address of the machine where Microsoft SQL Server is running.
Port
Port number of the Microsoft SQL Server database engine service.
Code Page
Character encoding to specify characters in a set of one or more languages.
Schema
The name of the database schema from where you want to extract metadata.