> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-center/data-connectors/supported-data-connectors/others/ms-sql-olap.md).

# MS Sql Olap

Provide the following information to create an MSSQL OLAP Data Connector.

* **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).
* **Address Type (IP/Host):** As per the selected Address type, a field appears below. The user needs to 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**.**

![](/files/7YKxBoMMmdgIiwFbSMKV)

* The success messages appear to confirm the connection and creation of a new connector.
* The newly created MSSQL OLAP data connector gets added to the Data Connectors page.