# SQLServer

You can quickly import data from your SQL Server into Exploratory.

## 1. Create a connection for MS SQL Server

First, you want to create a connection for SQL Server.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oNBanWuZTrXjv8wd4%2Fconnection-mssqlserver.png?generation=1586795478374234\&alt=media)

After filling the below database information:

* Host - Host name of the SQL Server
* Port - Port number for the SQL Server.
* Database - Database Name
* MS SQL Server ODBC Driver - It shows list of installed drivers. Regardless of the driver selected here, when you publish a Data source that uses the connection, ODBC Driver 17 for SQL Server is used for Scheduling. (Both exploratory.io and Collaboration Server have ODBC Driver 17 for SQL Server)
* Username - Username of the SQL Server
* Password - Password of the SQL Server

To Install ODBC Driver for SQL Server, please follow the [instruction](https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15).

Click ‘Test Connection’ button to make sure the information is correct, before you save it.

## Troubleshooting

If you use Mac and installed ODBC Driver 17 for SQL Server version 17.8 or older, you might see the below error when connection to your SQL Server

```r
[08001][Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed]
```

or

```r
[08000][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746 [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection
```

If this is the case, try the below steps: It assume you use brew to install openssl and brew prefix is `/usr/local`. (you can check it with `brew --prefix`)\
Please note `1.1.1s` might vary for the last character.

```
$ rm -rf /usr/local/opt/openssl

$ ln -s /usr/local/Cellar/openssl@1.1/1.1.1s /usr/local/opt/openssl
```

Then restart Exploratory.

## 2. Open SQL Server Import dialog

Select 'Import Database Data' from Add New Data Frame menu.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN-qBMezITjny_pQQ%2Fimport-database.png?generation=1586795453631702\&alt=media)

Click SQL Server to select.

## 3. Preview and Import

Click "Run" button to see the data back from your SQL Server.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oNBavM2AkQ_8NxFOE%2Fimport-mssqlserver.png?generation=1586795478349147\&alt=media)

If it looks ok, then you can click 'Import' to import the data into Exploratory.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.exploratory.io/data_import/database-data/mssqlserver.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.