Set up your publish targets
- Last UpdatedJun 25, 2025
- 2 minute read
This procedure is an overview of all the steps you must complete to set up the publish target, including any steps you must complete before you create and configure the publish target.
Note: As of PI Integrator for Business Analytics 2020 R2 SP2, the PI View target has been deprecated. To migrate any views using the PI View target to a Microsoft SQL Server target as an alternative, see Migrate PI View target to Microsoft SQL Server target.
-
If you are publishing your PI System data to one of the following targets, follow the instructions in the referenced topic to set up the target. For all other targets, skip to the next step.
-
Oracle Database – Refer to Set up the Oracle Database publish target.
-
Azure SQL Database or Azure Dedicated SQL Pool target – Refer to Set up the Azure SQL Database or Azure Dedicated SQL Pool target.
-
Amazon Redshift – Install Amazon Redshift ODBC driver on the machine where PI Integrator for Business Analytics is installed – Refer to Install and configure the Amazon Redshift ODBC driver.
-
SAP HANA ODBC – Install the SAP HANA Client on the machine where PI Integrator for Business Analytics is installed. Refer to Configure the SAP® HANA® ODBC publish target.
-
-
Add the publish target to PI Integrator for Business Analytics. See Add a publish target.
-
Configure the publish target. Refer to the topic for your target.
-
Grant users access to the publish target. See Grant access to targets.
Related Links
- Add a publish target
- Configure the Amazon Kinesis Data Streams target
- Install and configure the Amazon Redshift ODBC driver
- Configure the Amazon Redshift target
- Configure the Amazon S3 target
- Configure the Apache Hive target
- Configure the Apache Kafka target
- Tips to set up the Azure Data Lake environment
- Configure the Azure Data Lake Storage Gen 2 target
- Append timestamp in ADLS Gen 2
- Configure the Azure Event Hubs target
- Configure the Azure IoT Hub target
- Set up the Azure SQL Database or Azure Dedicated SQL Pool target
- Configure the Google BigQuery target
- Configure the Google Cloud Storage target
- Configure the Google Cloud Pub/Sub target
- Configure the Hadoop Distributed File System (HDFS) target
- Configure the Microsoft SQL Server target
- Set up the Oracle Database publish target
- Configure the SAP® HANA® ODBC publish target
- Configure the text file target
- Grant access to targets
- Migrate PI View target to Microsoft SQL Server target