Setting Up SnappyData ODBC Driver

This feature is available only in the Enterprise version of SnappyData.

Note

Step 1: Install the SnappyData ODBC Driver

  1. Download the SnappyData 1.0.2.1 Enterprise Edition.

  2. Click ODBC INSTALLERS to download the snappydata-odbc-1.0.2.zip file.

  3. Follow steps 1 and 2 to install the SnappyData ODBC driver.

Step 2: Create SnappyData DSN from ODBC Data Sources 64-bit/32-bit

To create SnappyData DSN from ODBC Data Sources:

  1. Open the ODBC Data Source Administrator window:

    a. On the Start page, type ODBC Data Sources, and select Set up ODBC data sources from the list or select ODBC Data Sources in the Administrative Tools.

    b. Based on your Windows installation, open ODBC Data Sources (64-bit) or ODBC Data Sources (32-bit)

  2. In the ODBC Data Source Administrator window, select either the User DSN or System DSN tab.

  3. Click Add to view the list of installed ODBC drivers on your machine.

  4. From the list of drivers, select SnappyData ODBC Driver and click Finish.

  5. The SnappyData ODBC Configuration dialog is displayed.
    Enter the following details to create a DSN:

    • Data Source Name: Name of the Data Source. For example, snappydsn.

    • Server (Hostname or IP): IP address of the data server which is running in the SnappyData cluster.

    • Port: Port number of the server. By default, it is 1528 for the first data server in the cluster, if all the nodes in the cluster are started on the same machine.

    Note

    ODBC driver cannot connect to the locator and must connect directly to one of the servers. Therefore, in cases where you start a cluster with multiple nodes on different machines and if the server and locator are collocated on a specific machine, then the port number of the server would be higher than that of the locator port which will be 1528. In case the locator is not collocated with the server on a machine then the server port will be 1527.

    • Login ID: The login ID required to connect to the server. For example, app

    • Password: The password required to connect to the server. For example, app

Note

Ensure that you provide the IP Address/Host Name and Port number of the data server. If you provide the details of the locator, the connection fails.

For information about connecting Tableau using SnappyData ODBC Driver, refer to Connect Tableau using ODBC Driver