Microsoft SQL Server

Set up

Whitelisting

You will need to whitelist the following IPs:

• 54.78.204.135
• 34.242.207.164

Connection

The following credentials are required to get set up with our Microsoft SQL Server connector.

• Hostname - The default value is Localhost. It can be found by executing the following command in an IDE connected to the SQL Server database: SELECT HOST_NAME();
• Port - By default the value is 1433. If this is not the case follow these instructions.
• Database User - The username used to connect to the database. This can be checked by executing the following command in an IDE connected to the SQL Server database: SELECT USER_NAME();
• Database Password - If you have forgotten this password please follow these steps to recover it.

You will also need to enter the database name that you would like to connect to.

Bastion Tunneling (optional)

If you would like to connect via a bastion, you will need to tick the "Requires tunneling" checkbox and enter your Bastion Host credentials.

To see how to set up your bastion tunneling credentials, check out our documentation here.

Running Extracts

When running an extract you will be asked to select a schema, then a table to extract.

You will also have the option to select the fields you wish to pull back.

🚧

Changing selected fields

If you change the fields you have selected after the extract has been running, any further extracts on append will fail, due to the column mismatch.

If you would like to add new fields, please run a new extract on Drop, Create, Load, to a new destination table. You can then set your extract to append onto this new table.

Please then select your load method and Extract Type.

If you select incremental, you will need to select your incremental key, to see how incremental works, you can head here.

Lastly, in order for Kleene to successfully pull the data without any duplicates or missing rows, we have selected the primary key, if for any reason this primary key selection is wrong or empty, please correctly override it.