How to combine data from a relational database and a data historian?
Article ID: KB0081791
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.7 and above |
Description
How to combine data from a relational database and a data historian? Is there an easy way to do this?
Resolution
Statistica Extract, Transform, and Load (ETL) under Data tab provides the capability to process data from standard databases (Microsoft SQL® , Oracle® ) as well as specialized process databases (e.g., OSI Pi®), with data filtering, alignment, and aggregation.
Disparate sources can be aligned by batch number and time interval and/or by one or more ID fields. Merging many-to-one data sets is a common scenario.
Disparate sources can be aligned by batch number and time interval and/or by one or more ID fields. Merging many-to-one data sets is a common scenario.
Issue/Introduction
How to combine data from a relational database and a data historian?
Feedback
Yes
No
Powered by
