Mssql Setup Guide

Prerequisites

This page guides you through the process of setting up the MSSQL destination connector.

You'll have to do the following:

• Provide the following fields: Username, Password, Hostname, Port, Database.
• Allow Matia IP addresses to access your SQL Server.
• Create a dedicated SQL Server login and user for Matia with permissions to create and update destination tables.

 

Configure your access control systems to allow inbound traffic from the following IPs: 23.21.86.124/32 and 52.20.96.22/32

Create a dedicated user

Connect to your SQL Server database as an admin user and execute the following SQL commands. Replace <database> with the database you want Matia to sync into, <matia_user> with the username you want to create, and <password> with a secure password:

USE [<database>];
CREATE LOGIN <matia_user> WITH PASSWORD = '<password>';
CREATE USER <matia_user> FOR LOGIN <matia_user>;

Grant required permissions

Matia needs permission to create schemas and tables when needed, and to read and write data in the destination database.

Grant database-level permissions:

GRANT CREATE SCHEMA TO <matia_user>;
GRANT CREATE TABLE TO <matia_user>;

If you want Matia to write into an existing schema, also grant schema permissions:

GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON SCHEMA::<schema> TO <matia_user>;

If you prefer to scope access to a specific table only, you can grant:

GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON [&lt;schema&gt;].[<table>] TO &lt;matia_user&gt;;

Setup Guide

1. Fill in the Username, Password, Hostname, Port and Database for your Microsoft SQL Server database.
2. Enter a Name for the connector.
3. (Optional) Enter a Description for the connector.
4. Select the Owner of the connector.
5. (Optional) Verify that your Microsoft SQL Server database is successfully connected by clicking on Test Connection.
6. Click Connect.

Supported Sync Modes

• Full Refresh
• Incremental