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: Installing 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: Installing TIBCO ComputeDB ODBC Driver
To download and install the ODBC driver:
-
Download the TIBCO ComputeDB 1.1.1 Enterprise Version. 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.1_win_x86_32bit.zip 64-bit for 64-bit platform TIB_compute-odbc_1.1.1_win_x64_64bit.zip -
Double-click on the extracted TIB_compute-odbc_1.1.1_win.msi file, and follow the steps to complete the installation.
Note
Ensure that TIBCO ComputeDB is installed and the TIBCO ComputeDB cluster is running.
Connecting 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=TIBCO ComputeDB ODBC Driver;server=<locator address>;port=<LocatorPort>;user=<userName>;password=<password>
In case you want to connect with a specific server:
Driver=TIBCO ComputeDB ODBC Driver;server=<ServerHost>;port=<ServerPort>;user=<userName>;password=<password>;load-balance=false
-
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. You can then enter either TIBCO ComputeDB Server Host, Port, User Name, and Password or TIBCO ComputeDB Locator Host, Port, User Name and Password. Refer to the documentation for detailed information on Setting Up TIBCO ComputeDB ODBC Driver.
Connecting Spotfire® Desktop to TIBCO ComputeDB
Refer TIBCO Spotfire® Connectivity to TIBCO ComputeDB™ for detailed instructions to access TIBCO ComputeDB using this connector.
Also see: