# MSSQL

Provide the following information to create an MSSQL Data Connector:

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FpEBCFBbbo0M3oMFLQzbd%2Fimage.png?alt=media&#x26;token=8d573d2f-a6c7-4dd3-a51a-67e103f7d0bc" alt=""><figcaption></figcaption></figure>

* **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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FmbfG4z28BBY5kyXs462J%2Fimage.png?alt=media&#x26;token=0e6bf164-9529-4fb2-becb-2ce136ce528c" alt=""><figcaption></figcaption></figure>

* A success message appears to confirm the connection.

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

* Another success message appears to assure the creation of the new MSSQL Data Connector.

<figure><img src="https://content.gitbook.com/content/IctE5LjGWDD6zEdW4vpJ/blobs/uOkTCGw5rMIer7SCTFrR/image.png" alt=""><figcaption></figcaption></figure>

* The newly created MSSQL data connector gets added to the Data Connectors list.

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> 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
  {% endhint %}