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 PDF PDF 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