Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
File Data
Database Data
SQL Troubleshooting
Create Connection
Google BigQuery
Snowflake
MySQL DB
Amazon Aurora
Amazon Athena
Amazon Redshift
MongoDB
PostgreSQL
Treasure Data
HP Vertica
ODBC
Presto
SQLServer (DSN)
SQLServer
Teradata
Cloud Apps Data
Write R Script as Data
Write R Script as Data (日本語)
Web Page Scraping
Data Source Extension
Create Custom Data Source
Data Wrangling
Visualization
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
SQLServer (DSN)
You can quickly import data from your SQLServer into Exploratory.

1. Create a connection for SQL Server

First, you want to create a connection for SQL Server.
After filling the database information, click ‘Test Connection’ button to make sure the information is correct, before you save it.

2. Open SQLServer Import dialog

Select 'Import Database Data' from Add New Data Frame menu.
Click SQLServer to select.

3. Preview and Import

Click "Get Data" button to see the data back from your Presto.
If it looks ok, then you can click 'Import' to import the data into Exploratory.
Previous
Presto
Next
SQLServer
Last modified 1mo ago
Copy link
Contents
1. Create a connection for SQL Server
2. Open SQLServer Import dialog
3. Preview and Import