SQL Server Connector: Overview

Overview

The OCF connector for SQL Server was developed by Alation and is available as a Zip file that can be uploaded and installed in Manage Connectors. Contact your Customer Success Manager about receiving the SQL Server connector package.

This connector should be used to catalog SQL Server as a data source in Alation. The connector catalogs SQL Server objects such as tables, columns, views, primary keys, foreign keys, functions, and function def fields. It enables end-users to search and find SQL Server objects from the Alation user interface.

Team

The following administrators are required to install this connector:

  • Alation administrator

    • Installs the connector

    • Creates and configures the SQL Server data source in the Catalog.

  • SQL Server objects administrator

    • Creates a service account with the Enterprise authentication type

    • Provides the JDBC URI to access metadata

    • Provides access to public schemas to extract metadata.

Scope

The table below shows what features are covered by the connector. For version support information, refer to Support Matrix.

Version Support

SQL Server (EC2)

SQL Server (RDS)

Core Capabilities

Automated Metadata Extraction (MDE)

Query-based MDE

Search

Catalog page curation

Catalog sets

Propagation of data quality flags

Popularity

Compose

Compose authentication

Compose query creation

Query execution

QLI

Query-based QLI

Filters

Lineage

Sampling and Profiling

Table sampling

Custom query based table sampling

Custom query based column profiling

Dynamic profiling

Authentication

Basic (username and password)

Kerberos

SSL

NTLM

Technical Metadata

Tables

Attributes

Primary keys

Foreign keys

Views

Schemas

Source comments