Loading Data from Microsoft SQL Server

This section describes how you can connect SQL Server with Exasol and then load data. The driver for SQL Server is pre-installed with Exasol. You can see the driver details in the EXAoperation (Configuration > Software > JDBC Drivers tab).

Run Statement

The jTDS connection string format used to connect to SQL Server is as follows: 

jdbc:jtds:sqlserver://{SERVER_NAME};databaseName={DATABASE_NAME);instance={INSTANCE}

Run the following statement to create a connection.

CREATE OR REPLACE CONNECTION JDBC_SQLSERVER
    TO 'jdbc:jtds:sqlserver://192.168.99.100:1433;databaseName=master;instance=v1'
    USER 'user'
    IDENTIFIED BY 'Password';

Run the following statement to test the connection.

select * from 
(
import from JDBC at JDBC_SQLSERVER
statement 'select ''Connection works'' '
);

To view details about data type mappings or to migrate data, see the SQL Server to Exasol migration script in our GitHub repository.