# MSSQL

Provide the following information to create an MSSQL Data Connector.<br>

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FildIzFc42T5vwPIVMv7z%2Fimage.png?alt=media\&token=8d573d2f-a6c7-4dd3-a51a-67e103f7d0bc)

* **Data Connector Name**: Provide a user-defined name to identify the data connector.
* **Description**: Provide connection details (Optional)
* **Username:** Enter a Username (It should be the same as given in the connection server).
* **Password**: Enter the Password (It should be the same as provided in the connection server).
* **IP/Host:** Enter database server details (from where the user wants to fetch data).
* **Port:** Provide the server port number.
* **Database Name:** Name of the database where you wish to store data.
* Click the **‘Save’** option.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FBgyDlyKpL2qKTocqP4kU%2Fimage.png?alt=media\&token=0e6bf164-9529-4fb2-becb-2ce136ce528c)

* A success message appears to confirm the connection.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FEDQJLdpQgHmyjDBZJucO%2Fimage.png?alt=media\&token=737691a3-81db-4d59-9b63-c856bde036aa)

* Another success message appears to assure the creation of the new MSSQL Data Connector
* The newly created MSSQL data connector gets added to the Data Connectors list.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Fg9SQ2upX3gW5naY4grYU%2Fimage.png?alt=media\&token=acb03d42-839b-4236-84d2-0935826272fb)

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F3IIXbXtsfkXvkOM6wdUs%2Fimage.png?alt=media\&token=28764cd6-12a9-48ef-884f-8bc1b7cf023f)

Note: The user can use the following Environment Variables instead of the actual Username and Password to create the MSSQL Data Connectors.

* Username: @ENV.MSSQLUSERNAME
* Password: @ENV.MSSQLPASSWORD