Mssql Retl Setup Guide

Prerequisites

• Access to a Microsoft SQL Server database and a destination table you want to sync into.
• Credentials for direct database access, or SSH tunnel details if your SQL Server is only reachable through a bastion host.
• A primary key on the source model and a matching primary key column on the destination table.

Setup Guide

Connect to your SQL Server database as an Admin user and execute the following SQL commands to create a user for Matia. Choose a memorable username (for example, Matia). Replace <database> with the name of your database and <password> with a password of your choice:

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

Grant permissions

Execute the following commands to grant the Matia user CREATE permission for the database you would like Matia to sync:

GRANT CREATE SCHEMA TO Matia;
GRANT CREATE TABLE TO Matia;

1. Create or choose a destination table in SQL Server.
2. Connect Matia using the same connection details you would use for the MSSQL source connector.
3. Select the destination table in schema.table format.
4. Map your model primary key to the destination primary key column.
5. Map the remaining model fields to destination columns and run a test sync.

Supported Sync Modes

• Mirroring