PI Integrator for Business Analytics editions
- Last UpdatedJun 25, 2025
- 5 minute read
There are two editions of PI Integrator for Business Analytics:
-
Standard
The Standard edition is an enterprise solution for customers who want to publish their PI System data to an external data warehouse. Once exported to these data warehouses, PI System data can be merged with data from other systems.
-
Advanced
In addition to publishing data to external data warehouses, the Advanced edition supports streaming data to supported streaming targets. Once published, this data can be used to train machine-learning applications to discover patterns and predict future behavior.
Supported Publish Targets
The following table shows the different publish targets supported with each edition and the types of views that are supported with each target. For more information about views, see PI Integrator for Business Analytics views.
|
Destination Type |
Target Destination |
Format |
Supported Views |
Standard Edition |
Advanced Edition |
||
|---|---|---|---|---|---|---|---|
|
Asset Views |
Event Views |
Streaming Views |
|||||
|
General |
Text File |
row-column |
|
|
|
|
|
|
Relational Database |
Microsoft SQL Server |
row-column |
|
|
|
|
|
|
Oracle Database |
|
|
|
|
|||
|
Azure SQL Database |
|
|
|
|
|||
|
SAP HANA (ODBC) |
|
|
|
|
|||
|
Data Warehouse |
Apache Hive |
row-column |
|
|
|
|
|
|
Azure Dedicated SQL Pool |
|
|
|
|
|||
|
Amazon Redshift |
|
|
|
|
|||
|
Google BigQuery |
|
|
|
|
|||
|
Data Lake |
Hadoop HDFS |
row-column |
|
|
|
|
|
|
|
|
|
|
||||
|
Amazon S3 |
|
|
|
|
|||
|
Google Cloud Storage |
|
|
|
|
|||
|
Azure Data Lake Storage Gen 2 |
|
|
|
|
|||
|
Messaging Hub |
Apache Kafka |
stream |
|
|
|||
|
Azure IoT Hub |
|
|
|||||
|
Azure Event Hubs |
|
|
|||||
|
Amazon Kinesis Data Streams |
|
|
|||||
|
Google Cloud Pub/Sub |
|
|
|||||
