Microsoft SQL

Rather than a storage connector, that connects to a GCP or S3 bucket for example, a Microsoft SQL connector is referred to as a database connector. Currently, the Microsoft SQL connector is supported for the creation of platform, tabular assets and cannot be used as an export location.

Pre-requisites

To connect your Microsoft SQL database , you need:

1. Your database host's IP (e.g., 1.1.1.2) or domain (e.g., my.server.com)

2. Your database's port (usually 1521 for unencrypted connections and 2484 for encrypted connections using SSL/TLS)

3. Database (optional) - you can specific a database to limit the scope of access for a connector

4. A user created for accessing the required data and username and password for that user

Supported versions: Microsoft SQL Server 2019, 2022

Create the Connector

1. Click Manage on the Navigation bar.

2. Select Connectors to view the Manage Connectors screen

3. Click the Create Connector button at the top right

4. Enter a Name for your Connector and a Description (optional)

5. Choose Type > Microsoft SQL.

6. Add any Integration Metadata needed for programmatic integration.

7. Click Create.

8. Click Close