Mon, 20 May 2013 19:00:00 GMT
Fri, 17 May 2013 20:28:00 GMT
Mon, 13 May 2013 08:48:00 GMT
STATISTICA Extract, Transform, & Load (ETL) combines the capabilities of the STATISTICA system 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.
If you need to manage and optimize complex processes, you need STATISTICA Extract, Transform, and Load (ETL).
Given your current databases and process monitoring methods, can you quickly determine how different process steps affected measured quality an hour ago, yesterday, last week?
Can you quickly determine whether or not changes in trends have occurred? Whether the relationships between certain process parameters are starting to drift?
STATISTICA ETL can be combined with the capabilities of STATISTICA Enterprise for a complete advanced statistical process monitoring solution. This solution can support highly specialized data warehouses that can integrate time-stamped parameter data for multiple process steps with quality, rework, and outcome data.
STATISTICA ETL provides capabilities to extract, transform, and load data.
STATISTICA Extract, Transform, & Load (ETL) combines the capabilities of the STATISTICA system for efficient processing of data from standard databases (Microsoft SQL, Oracle) as well as specialized process databases with the optional PI Connector tool (e.g., OSI Pi), with the powerful STATISTICA data processing capabilities for data filtering, aggregation, and analyses. STATISTICA ETL can be combined with the capabilities of STATISTICA Enterprise for a complete advanced statistical process monitoring solution. This solution can support highly specialized data warehouses that can integrate time-stamped parameter data for multiple process steps with quality, rework, and outcome data.
STATISTICA Enterprise provides a secure platform for managing efficiently multiple database connections to various types of databases, including process databases (e.g., via the specialized STATISTICA PI Connector). STATISTICA Enterprise will store the metadata describing the nature of the tables that are queried, such as control limits, specification limits, valid data ranges etc. See STATISTICA Enterprise for more details.
The STATISTICA ETL module provides unique capabilities for processing and merging data, in particular process data that are difficult to manage using standard database tools.
In order to monitor ongoing continuous processes, such as chemical or pharmaceutical manufacturing, power generation, refining, and so on, it is necessary that critical process parameters be recorded into a process "historian" at regular time intervals. Dedicated high-performance databases, such as the OSI Soft's PI database, are typically deployed to provide efficient high-frequency data recording capabilities. However, to make such data available for useful data analyses, e.g., for root-cause analyses or process monitoring, it is necessary that such data are aggregated and aligned, for example, with outcome data.
The manufacture of pharmaceuticals and chemicals often involves the processing of batches of materials through multiple steps, where in each step some maturation of the batch is recorded. The resulting data, recorded into some laboratory information management system (LIMS) consist of time-stamped process data, organized by batch ID. In order to make such data available for useful data analyses, it is necessary to transform the time-stamps into elapsed-within-process-step times, and to normalize the data so that for each batch a comparable number of elapsed time recordings are available for analyses.
The aggregation of real process data (e.g., time-stamped one-minute-interval data to align with hourly data) usually requires the application of aggregation methods that go far beyond the capabilities of standard database tools. For example, time-stamped data may include outliers, or may be very "noisy," thus hiding important trends, or changes in trends.
Complex processes, such as the manufacture of semiconductors, pharmaceutical manufacturing, etc. require complex data storage, suited to the specific nature of the process that is to be recorded and monitored. Therefore, it is common that multiple separate databases or data sources, such as automatically created (from gages) CSV files, data from OSI PI, assay data from a LIMS system, etc., must be aggregated and aligned, to enable meaningful root cause analyses of problems, or comprehensive process monitoring.
The Transformation capabilities of STATISTICA ETL go far beyond those available in standard database or querying tools, and will allow you to build dedicated specialized data warehouses to optimize your processes without the need to program custom-applications in-house. STATISTICA ETL is the one-stop solution for creating data warehouses with automated simple and sophisticated analytic capabilities that will allow you to derive the full value from the data that you are collecting!
The STATISTICA ETL solution will automate the process of validating and aligning multiple diverse data sources into data tables suitable for ad-hoc or automated analyses. When deployed inside the STATISTICA Enterprise framework, data can be written back to dedicated database tables, or to STATISTICA data tables, to provide analysts or process engineers convenient access to real-time performance data, without the need to perform tedious data preprocessing or cleaning before any actionable information can be extracted.
STATISTICA Extract, Transform, & Load is compatible with Windows XP, Windows Vista, and Windows 7.
Native 64-bit versions and highly optimized multiprocessor versions are available.