You can quickly import data from your SQL Server into Exploratory.
First, you want to create a connection for SQL Server.
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.
Click ‘Test Connection’ button to make sure the information is correct, before you save it.
Select 'Import Database Data' from Add New Data Frame menu.
Click SQL Server to select.
Click "Run" button to see the data back from your SQL Server.
If it looks ok, then you can click 'Import' to import the data into Exploratory.