Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
File Data
Database Data
SQL Troubleshooting
Create Connection
Amazon Athena
Amazon Aurora
Amazon Redshift
Amazon Redshift (日本語)
Google BigQuery
HP Vertica
MariaDB / MySQL DB
MariaDB / MySQL DB (日本語)
Microsoft Access
MongoDB
ODBC
PostgreSQL
PostgreSQL (日本語)
Presto
Snowflake
SQLServer (DSN)
SQLServer
Teradata
Treasure Data
Cloud Apps Data
Write R Script as Data
Write R Script as Data (日本語)
Web Page Scraping
Free Input Text
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
Snowflake
Next
SQLServer
Last modified 6mo ago
Copy link
Contents
1. Create a connection for SQL Server
2. Open SQLServer Import dialog
3. Preview and Import