STATISTICA Connectivity and Data Integration Solutions

StatSoft customers depend on STATISTICA Enterprise for their business intelligence and data mining needs. STATISTICA answers these needs by providing streamlined, single-tool access to data from a wide variety of sources. Once STATISTICA Enterprise is configured, users have easy access to data extraction, filtering, and drill-down tools - all within STATISTICA. The data sources supported by STATISTICA Enterprise include the following:

  • Enterprise Resource Planning (ERP) such as SAP
  • Laboratory Information Management Systems (LIMS)
  • Manufacturing Execution Systems (MES)
  • Any OLE DB or ODBC relational database such as Oracle, Microsoft SQL Server, or Microsoft Access
  • Hierarchical Process Cubes
  • Flat files such as Microsoft Excel spreadsheets
  • Data historian repositories such as the PI Data Historian from OSI Soft, Inc.
  • In-Place Database Processing (IDP), query multidimensional databases containing terabytes of data and process data without importing to local storage
  • Web-based data entry

STATISTICA Enterprise can be combined with STATISTICA Extract, Transform, and Load (ETL), providing for efficient processing of data from standard databases (Microsoft SQL, Oracle) as well as specialized process databases using the optional PI Connector tool (e.g., OSI Pi), with the powerful STATISTICA data processing capabilities for data filtering, aggregation, and analyses.

STATISTICA Enterprise also provides convenient tools for filtering your data and for viewing the metadata associated with those data sources, including  Hierarchical Process Cubes, that contains all the information about how material moved through the sequence of steps, so that meaningful monitoring, qc-charting, reporting, and root cause and other analyses can be performed. In STATISTICA Enterprise, engineers and analysts are empowered to select the relevant process and easily gain access to the necessary data and to review the movement of materials and batches through the production process. Read more...

STATISTICA Enterprise also provides convenient tools for viewing the metadata associated with those data sources. And the STATISTICA Enterprise administration application (the Enterprise Manager) supports a multi-layered role-based approach, providing precision access control to data. For example, your database administrators can be given permission to create and modify database connections and queries, and your engineers can be given permission to run those queries and analyze the resulting data. Furthermore, each engineer can be assigned permissions for only the analyses that pertain to his or her work.