MSSQL Database Connector

MSSQL (Microsoft SQL Server) is a relational database management system developed by Microsoft, designed to store and retrieve data for various applications. It supports a wide range of data types, transactions, and analytics, making it suitable for enterprise-level database needs.

Getting started with MSSQL

1. Sign up or Sign in for an Azure account.

2. Search for SQL Databases in the global search and click on the search result and click on create.

   

3. Now click on create new button below server field to create a new database server.

   

4. Enter the Server Name, Location, and choose the SQL authentication as login type and finish the form.

   

5. Now choose the Database Name and choose Environment as Production and submit it. For more customization click on next pages before submitting.

   

6. Wait for the database to get deployed.

Setting up the MSSQL connector in Unstract

Head over to the Unstract console, From the side navigation, select Workflows 🞂 + New Workflow 🞂 Create Workflow 🞂 Select Connector Type 🞂 File System 🞂 Settings icon.

• For Name of the connector, enter a name for this connector
• For Server, enter the server name we created in step 4. The Server name needs to be concatenated with the suffix .database.windows.net
• Leave Port number to its default value.
• For Database Name, enter the database name we created in step 5.
• Enter the Username and Password which we set up in step 4.
• Click Test Connection
• Once the test is successful, Submit your changes.

Database Options

The Configuration panel offers a few options:

• Table: The new table name to be created
• Single column name: The column name in which the whole json needs to be written.
• Click on save once the configuration changes are made.

Need a hand?

Talk to us on Slack! We're here to help :)