Setting up MS-SQL Connector

To set up MS-SQL Connector, follow the steps below.

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

• In the APIs and Integration module click the [+ Connector] button.

• The Details tab is preselected.

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

• Optionally provide a description.

• To define the MS-SQL connector, select “MsSQL” from the list of values.

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

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

  2. “Port number”: Enter 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”: Enter username for the connector.

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

  5. “DB (Database) Name”: Enter the Database name.

• To save the connection, click [Save]. This activates the [Test connection] button.

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