Microsoft SQL

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

Currently, Microsoft SQL connector supports for Table, On platform asset creation and cannot be used as an export location.

Configuration steps

1. Go to Manage->Connectors, select Microsoft SQL option and create a connector using your database details and save selection

2. Connector can now be used within your organisation when creating assets

Creating assets from Microsoft SQL connector

1. When creating assets, user must select:

   1. Database (if one was not specified when setting up a connector)

   2. Schema

   3. Table or a view that will be used to create an asset

2. Once asset is created, further Updates to data can be set up using Updates tab on a scheduled frequency or triggered manually