Features Table

Pi Business Integrator

Odin

Vertical and horizontal scaling architecture

Vertical only

Horizontal and Vertical scaling

Support for data sources

PI AF, PI EF

PI AF, PI EF, PI Batch, PI Tags, Wonderware, more coming soon

Ability to tunnel across network layers to retrieve source data

No

Yes via ODIN agents

Audit trail inbuilt

No

Yes

Centralized Logging

Yes

Yes

Inbuilt job statistics

Yes

Yes

Performant UI

Medium

High

Direct Data Destinations Support

Relational Database

Microsoft SQL Server

Supported

Supported

Oracle Database

Supported

Not Direct

Azure SQL Database

Supported

Supported

SAP HANA (ODBC)

Supported

Not Direct

Data Warehouse

Apache Hive

Supported

Not Direct

Azure SQL Data Warehouse

Supported

Supported

Amazon Redshift

Supported

Not Direct

Google BigQuery

Supported

Supported

Data Lake

Hadoop HDFS

Supported

Not Direct

Azure Data Lake Storage Gen 1 – (previously named Azure Data Lake Store)

Supported

Not Direct

Amazon S3

Supported

Supported

Google Cloud Storage

Supported

Supported

Azure Data Lake Storage Gen 2

Supported

Supported

Messaging Hub

Apache Kafka

Supported

Supported

Azure IoT Hub

Supported

Supported

Azure Event Hubs

Supported

Supported

Amazon Kinesis Data Streams

Supported

Not Direct

Google Cloud Pub/Sub

Supported

Supported