MSSQL Exporter

📘

General MSSQL information can be found here

---

Set up

To get set up with the MSSQL Exporter connector, you will need the following:

• Hostname

• Port

• Database User

• Database Password

• Database Name

Whitelisting
You will need to whitelist the following IPs:

54.78.204.135
34.242.207.164

Bastion Tunneling

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.

Reports detail

---

The only report currently available is Full Table. Full table truncates the Destination Table in the database if the database exists otherwise it creates a new table with the given name. It then loads all the data in the source table into the destination table.

📘

Report setup

Source Table selection allows you to choose the table you want exported from your source Data Warehouse

Destination Table allows you the set where the data will land in your MSSQL database. Please ensure you input the schema and table name (e.g. test_schema.test_table).

🚧

Redshift DW not supported

Redshift DW not supported currently for this connector. In case you would like to use the connector and you are on Redshift DW, please raise this with your CS representative, so we can build this for you.

🚧

Column types

Some differences between how the data appears in your source table vs how it lands in the MSSQL database can be expected, due to differences between how these systems handle column types.