Hello,
I have a question maybe more related to system architecture. Currently, we have an Azure web app that requires some PI tag values to be fed to it via our web API. We currently use Azure Data Factory to get data to our API from different sources which we also like to utilize for PI data retrieval. I've identified two options for connecting to the PI system:
1/ PI ODBC: This involves using Azure ODBC, which seems feasible based on some discussions I've seen on PI Square. It may require the installation of self-hosted Azure integration runtime service on the machine where the DSN to be configured.
2/ PI Integrator: My understanding is that this tool is more straight forward and can export PI data directly to Azure SQL DB (table) or CSV files (maybe a Azure storage account).
Questions:
- Which approach is more commonly used for similar use cases?
- Are there any restrictions or barriers for one solution over the other?
- As a third party software without access to PI servers, is there a way to test PI Integrator to retrieve sample PI data from an OSIsoft PI test environment maybe through the Devclub subscription (also test environment for the PI ODBC option if that is a better solution)?
- Are there any other viable options that have been used/recommended to meet similar integrations?
