Setting up MS-SQL connector

The MS-SQL Connector is set up as follows.

• To go to the Connector menu, select "Connector" under the APIs and Integration menu.

• In the APIs and Integration module, click [+ Connector] to create a new connector.

• The Details tab is preselected.

• Enter the Connector name as "Tutorial_MSSQL". This name will be used to refer to this connector in the ETL applications.

• Add a description, optionally.

• Select “MsSQL” from the list of values.

• Add relevant details in the MsSQL Host & Login section:

  1. “Host name”: The server details of the host.

  2. “Port number”: The port number to connect. (By default, Langstack pre-fills it with the default MS-SQL port 1433. However, users can change the port number as needed.)

  3. “Username”: The username for the connector.

  4. “Password”: The password for the connector.

  5. “DB (Database) Name”: The Database name.

• Save the connection by clicking [Save]. This activates the [Test connection] button.

• To test the connection, click [Test connection].