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?
Issue/Introduction
How to combine data from a relational database and a data historian?
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.
Feedback
Yes
No
Powered by
