MSSQL

Create a connection and import from your MSSQL database.

In order to use this connector, you must install the proper database driver. For instructions, refer to How to Install Database Drivers.

Configuring MSSQL as a Connection

In order to import and export with MSSQL, you must first create a connection.

  1. Click the + (plus) button and select Connection or right-click in the browser and select Create new > Connection.
  2. From drop-down list, select MSSQL as the connection type.
  3. Enter the MSSQL connection string and authentication credentials.
    Select if the connection is to be used for import, export, or both.

    As of Datameer X v6.3
    A separate authentication section has been added.

  4. If required, add a description and click Save.

Importing Data with an MSSQL Connector

For step-by-step directions for database connectors, refer to Importing Data from a Database.