Microsoft SQL Server is a relational database management system developed by Microsoft. Organizations use MS SQL to store and query information about their business operations; from inventory to sales, and beyond.

With the Microsoft SQL connector, Toric users can:

• Read and ingest data into Toric.
• Streamline ingestion by creating automations to trigger data import on a schedule or source update.
• Perform data engineering tasks on ingested data including processing, cleaning, enriching, and transforming data into insights.

Configuration guide

Setup time: 45 seconds

Depending on cloud infrastructure you may use an API gateway from one of the cloud providers to proxy the traffic to the internal MSSQL server.

Alternatively, if self hosted, you can forward the traffic, remapping the port (as policy dictates) filtering traffic by Toric's static IPs - Toric IP Addresses.

Requirements:

• MS SQL Subscription
• Web Browser (Safari, Chrome, Edge, Firefox)

1. Navigate to the Connectors

To find connectors in Toric, you must be signed in to your account. On the left side panel of your Workflow, click on "Integrations".

‍2. Select the MS SQL Connector

Under the ‘Databases’ header, find the “MS SQL” connector and click on “Setup Integration”.

3. Click on Create a Connection

4. Fill in your MS SQL Credentials

Enter the following information:

1. Configuration Name
2. Host
3. Port
4. Database
5. Username
6. Password

5. Click on Validate Configuration

Now that you have all Configuration details filled in, click on Validate Configuration

If the information entered is valid, a Validation Successful message will appear.

- Invalid fields will be highlighted in red and a successful validation will show in green.

6. Click “Add Configuration” to finalize your configuration

Data Access

Don't see what you are looking for? We're always happy to answer any questions or explore new functionalities. Contact us here!

Integration Capabilities Supported by the Connector

Toric ingests data from Microsoft SQL Server via APIs, and users can currently read and ingest data into Toric.

Related articles

https://www.toric.com/support/configure-ms-sql

Common issues when connecting to SQL Servers:

Can we connect to the DB? If not,

• Have you approved/whitelisted Toric IP's? See this article for a list of Toric's IPs
• Does the machine have a public facing IP?
• Are the correct ports open?
• Does the public facing IP route to the proper host?

Can we access the DB? If not,

• Did you provide the correct DB name?
• Did you setup an account with DB access?
• Is the password correct?

Additionally, the typical failure points for most SQL connections are:

1. Wrong host/IP - the host needs to be a Publicly Routable name or IP
2. IP allow list does not include Toric IPs
3. Incorrect Port
4. TCP Support not enabled
5. Invalid/Wrong DB name

Questions?

W‍e're very happy to help answer any questions you may have. Contact support here or send us an email at support@toric.com.