TIBCO Statistica® Data Connectors
To use connectors that require a data source’s driver, the driver must be installed on the same computer with the Statistica application or service.
Statistica can connect to most data sources that have an ADO.NET, OLE DB or ODBC driver. Statistica does not support connection via JDBC driver directly. Most data sources that use JDBC, also have an ADO.NET, OLE DB or ODBC driver. If the data source only has a JDBC driver, the options are:
- Locate a .NET-JDBC and ODBC-JDBC bridge driver
- Use the JDBC driver to connect to TIBCO® Data Virtualization and publish an ODBC connection for Statistica to use
- Write data into a database that Statistica can connect to with ADO.NET, OLE DB or ODBC driver
If the data source has an API, you can write a Code Node in C#, R, Python or Spark for a Statistica workflow to use.
Connectors
The table below contains additional information about various data connectors. This is not a complete list of data sources.
Data Type | Data Source | Connector | Details |
---|---|---|---|
Analysis Service | Microsoft SQL Server Analysis Services (SSAS) | ADO.NET, OLE DB or ODBC | Query data from SQL Server Analysis Servicess SSAS OLAP |
Application | TIBCO Statistica® Data Entry Server | Statistica Enterprise Manager application and Statistica application | Manually enter data into smart web forms for validating data with double-blind data entry. You can also import data from spreadsheets through these web forms to correct and validate data. Data can also be retrieved and analyzed using Analysis Configuration or Data Configuration. |
Application | TIBCO® Data Science - Team Studio | Team Studio Import node for Statistica workspace | A node within the Statistica workspace calls a Team Studio workflow. See example workspace, Example_TeamStudio_Import. Examples are installed with the application in directories like C:\Program Files\TIBCO\Statistica\Examples\Workspaces. |
Application | TIBCO® Data Virtualization | ADO.NET, OLE DB | Connecting to Tibco Data Vitualization data source |
Application | TIBCO® Spotfire Server | Spotfire Data Connection node within Statistica application or Data Function within Spotfire application | Use Spotfire 10.3 to 10.9 with Statistica 13.4, 13.5 or 13.6. Use Spotfire 10.10 or later with Statistica 14.0. Refer Importing and Exporting data into Spotfire Binary Data file and Statistica Data Function Spotfire. |
Data warehouse | Azure HDInsights | ODBC | Querying data from Azure HDInsights into TIBCO Statistica Enterprise |
Data warehouse | Azure SQL Data Warehouse | ODBC | - |
Data warehouse | Google BigQuery | Google BigQuery | Querying data from Google Big Query into Statistica Enterprise for analyses |
Data warehouse | Microsoft SQL Server Parallel Data Warehouse (PDW) | ADO.NET, OLE DB or ODBC | - |
Database | Amazon Redshift | ODBC | |
Database | AWS RDS for Oracle, Oracle database | ADO.NET, OLE DB, ODBC | |
Database | GreenPlum Database | ODBC | - |
Database | Hive | ODBC | - |
Database | IBM DB2 | ODBC | - |
Database | Microsoft Access | ODBC | - |
Database | AWS RDS for SQL Server, Azure RDS for SQL Server, Microsoft SQL Server, Microsoft SQL Server Express | ADO.NET, OLE DB, ODBC | OLEDB recommended |
Database | MySQL | ADO.NET, ODBC | |
Database | Oracle database | ADO.NET, OLE DB, ODBC | Any driver can be used |
Database | OSIsoft PI Asset Framework (AF) | Statistica PI Connector with PI AF SDK | General Information for the PI Connector in Statistica |
Database | OSIsoft PI batch data | Statistica PI Connector with PI SDK | General Information for the PI Connector in Statistica |
Database | OSIsoft PI Event Framework (EF) | Statistica PI Connector with PI AF SDK | General Information for the PI Connector in Statistica |
Database | PostgresSQL | ODBC | - |
Database | BusinessObjects | ODBC | - |
Database | SAP HANA, SAP HANA Cloud | OLE DB (SAP HANA MDX Provider) | Connecting to SAP HANA from Statistica using MDX |
Database | SAP HANA, SAP HANA Cloud | ODBC | Connecting to SAP HANA from Statistica using ODBC driver |
Database | Sybase | ODBC | - |
Database | Teradata | ODBC | Pulling data from Teradata into Statistica using ODBC |
Document Management | Sharepoint | Sharepoint | - |
File | dBase | dBase file; .dbf | File types that can be opened in Statistica |
File | Excel | Excel file; .xls, .xlsx, .xlsm, xlsb | Data can be imported from excel into a Statistica spreadsheet or the Excel workbook can be opened within Statistica and Statistica's algorithms can be used on the data within Excel. You can see two menus in this mode; Statistica's menus on top of the Excel ribbon bar. If you code Visual Basic, you can call Statistica algorithms from Excel |
File | Google Sheets | ODBC | - |
File | Image files | Image files; .bmp, .jpeg, .png, .gif, .tiff | Digitize RGB color or grayscale to numbers and save to a Statistica spreadsheet or export to other formats. |
File | JMP | JMP data file; .jmp | File types that can be opened in Statistica |
File | Lotus | Lotus data files; .wk1, .wk3 | File types that can be opened in Statistica |
File | Minitab | Minitab data file; .mtw | File types that can be opened in Statistica |
File | Output analytic results | ||
File | PMML | PMML file; .xml | PMML 4.2 or older is supported for 14.0. Refer, PMML versions supported by Rapid Deployment Node in Statistica |
File | PowerPoint or Word | PowerPoint file or Word file | Opens document within Statistica application. When you only have a single monitor, you can more easily view, copy and paste between the two applications. |
File | Quattro | Quattro data file; .wq1 | File types that can be opened in Statistica |
File | RTF | RTF file | File types that can be opened in Statistica |
File | SAS | SAS data files; .sd, .ssd, .sas7, .tpt, .xpt | File types that can be opened in Statistica |
File | Spotfire | Spotfire Data File; sbdf | - |
File | SPSS | SPSS data files; .sav, .por | Opening SPSS data file in Statistica |
File | Statistica spreadsheet | Statistica data file; .sta | - |
File | Statistica spreadsheet | ODBC | Driver installed with Statistica |
File | Text File with delimiters | Text file; .csv, .txt, etc.. | File types that can be opened in Statistica |
File | Text file with fixed position (source: Mainframe files) | Fixed position text file | File types that can be opened in Statistica |
Library | Python Pandas | data frame | Sending data frame to Statistica using Python Pandas |
Query service | Amazon Athena | ODBC | Pulling data from Amazon Athena into Statistica |
Storage | Amazon S3 | Amazon S3 | Fetching public data from Amazon S3 bucket into Statistica You must write custom code to call API to retrieve private data. |
Storage | H20 Sparkling Water data | H20 Sparkling Water data | - |
Storage | Hadoop | HDFS files | Connecting to HDFS Server and fetch data |
Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.