How to connect to TIBCO ComputeDB using TIBCO Statistica
Article ID: KB0075454
Updated On:
| Products | Versions |
|---|---|
| TIBCO ComputeDB | All supported versions. |
Description
This article explains how we can connect to TIBCO ComputeDB from TIBCO Statistica.
Issue/Introduction
How to connect to TIBCO ComputeDB using TIBCO Statistica
Environment
All Supported Operating systems
Resolution
Prerequisites:
> Login and download TIBCO Statistica from TIBCO eDelivery website
> Launch the installer application and follow the setup guidelines.
> Download Simba Spark ODBC driver from the below link.
https://www.simba.com/drivers/spark-jdbc-odbc/
> Create Simba Spark ODBC DSN (Data Source Name) by providing the required details.
There are two different ways of connecting to TIBCO ComputeDB from TIBCO Statistica:
1. ODBC Connection (Using Simba Spark ODBC driver/TIBCO ComputeDB ODBC driver):
> From the Data > External Data > Create Query > New ADO.NET.
> Select the DSN corresponding to Simba Spark ODBC Driver/Snappydata ODBC Driver from the “Use user or system data source name” drop-down and provide necessary “Login information”. (Confirm the connectivity using “Test Connection”)
2. Using OLE DB (Simba Spark ODBC driver or TIBCO Apache Spark driver):
> Login and download TIBCO Statistica from TIBCO eDelivery website
> Launch the installer application and follow the setup guidelines.
> Download Simba Spark ODBC driver from the below link.
https://www.simba.com/drivers/spark-jdbc-odbc/
> Create Simba Spark ODBC DSN (Data Source Name) by providing the required details.
There are two different ways of connecting to TIBCO ComputeDB from TIBCO Statistica:
1. ODBC Connection (Using Simba Spark ODBC driver/TIBCO ComputeDB ODBC driver):
> From the Data > External Data > Create Query > New ADO.NET.
> Select the DSN corresponding to Simba Spark ODBC Driver/Snappydata ODBC Driver from the “Use user or system data source name” drop-down and provide necessary “Login information”. (Confirm the connectivity using “Test Connection”)
2. Using OLE DB (Simba Spark ODBC driver or TIBCO Apache Spark driver):
Note: Snappydata ODBC Driver doesn’t work with OLE DB option
> Inside Statistica Application, go to Data > External Data > Create Query > New OLE DB.
> Select “Microsoft OLE DB Providers for ODBC Drivers” from the “Data Link Properties” dialog box.
> Select the DSN corresponding to Simba Spark ODBC Driver from the “Use user or system data source name” drop-down and provide necessary “Login information".(Confirm the connectivity using “Test Connection”).
Additional Information
Documentation for connecting to TIBCO ComputeDB using TIBCO Statistica.:
https://docs.google.com/document/d/1YwgiD94krRKFMkL5TrNxWE8uy-OgXTE5Q-34dTsf12o/edit#
https://docs.google.com/document/d/1YwgiD94krRKFMkL5TrNxWE8uy-OgXTE5Q-34dTsf12o/edit#
Feedback
Yes
No
Powered by
