How to Connect using ODBC Driver¶

You can connect to SnappyData Cluster using SnappyData ODBC Driver and can execute SQL queries by connecting to any of the servers in the cluster.

Step 1: Installing Visual C++ Redistributable for Visual Studio 2015 and above¶

To download and install the Visual C++ Redistributable for Visual Studio 2015 and above:

1. Download Visual C++ Redistributable for Visual Studio 2015 and above

2. Select Run to start the installation and follow the steps to complete the installation.

Step 2: Installing SnappyData ODBC Driver¶

To download and install the ODBC driver:

1. Download the drivers zip file snappydata-odbc_1.3.0_win64.zip using the steps provided here.
2. Extract snappydata-odbc_1.3.0_win64.zip. Depending on your Windows installation, extract the contents of the 32-bit or 64-bit version of the SnappyData ODBC Driver.

1. Double-click on the corresponding msi file, and follow the steps to complete the installation.

   Note

   Ensure that SnappyData is installed and the SnappyData cluster is running.

Connecting to the SnappyData Cluster¶

Once you have installed the SnappyData ODBC Driver, you can connect to SnappyData cluster in any of the following ways:

• Use the SnappyData Driver Connection URL:

  Driver=SnappyData;server=<ServerIP>;port=<ServerPort>;user=<userName>;password=<password>
  

• Create a SnappyData DSN (Data Source Name) using the installed SnappyData ODBC Driver. Refer to the Windows documentation relevant to your operating system for more information on creating a DSN. When prompted, select SnappyData from the list of drivers and enter a Data Source name, SnappyData Server Host, Port, User Name and Password. Refer to the documentation for detailed information on Setting Up SnappyData ODBC Driver.

Connecting Spotfire® Desktop to SnappyData¶

Refer TIBCO Spotfire® Connectivity to SnappyData™ for detailed instructions to access SnappyData using this connector.

Also see:

ODBC Supported APIs in SnappyData Driver