How to Connect using ODBC Driver
You can connect to TIBCO ComputeDB Cluster using TIBCO ComputeDB ODBC Driver and can execute SQL queries by connecting to any of the servers in the cluster.
Step 1: Install Visual C++ Redistributable for Visual Studio 2013
To download and install the Visual C++ Redistributable for Visual Studio 2013:
-
Select Run to start the installation and follow the steps to complete the installation.
Step 2: Install TIBCO ComputeDB ODBC Driver
To download and install the ODBC driver:
-
Download TIBCO ComputeDB™ - Enterprise Edition. The downloaded file contains the TIBCO ComputeDB ODBC driver installers.
-
Depending on your Windows installation, extract the contents of the 32-bit or 64-bit version of the TIBCO ComputeDB ODBC Driver.
Version ODBC Driver 32-bit for 32-bit platform TIB_compute-odbc_1.1.0_win_x86_32bit.zip 32-bit for 64-bit platform TIB_compute-odbc_1.1.0_win_x86_64bit.zip 64-bit for 64-bit platform TIB_compute-odbc_1.1.0_win_x64_64bit.zip -
Double-click on the SnappyDataODBCDriverInstaller.msi file, and follow the steps to complete the installation.
Note
Ensure that TIBCO ComputeDB is installed and the TIBCO ComputeDB cluster is running.
Connect to the TIBCO ComputeDB Cluster
Once you have installed the TIBCO ComputeDB ODBC Driver, you can connect to TIBCO ComputeDB cluster in any of the following ways:
-
Use the TIBCO ComputeDB Driver Connection URL:
Driver=SnappyData ODBC Driver;server=<ServerHost>;port=<ServerPort>;user=<userName>;password=<password> -
Create a TIBCO ComputeDB DSN (Data Source Name) using the installed TIBCO ComputeDB ODBC Driver. Refer to the Windows documentation relevant to your operating system for more information on creating a DSN. When prompted, select the TIBCO ComputeDB ODBC Driver from the list of drivers and enter a Data Source name, TIBCO ComputeDB Server Host, Port, User Name and Password. Refer to the documentation for detailed information on Setting Up TIBCO ComputeDB ODBC Driver.