We have a requirement of creating a real time dashboard. The dashboard solution/data toolbox intends to receive data from Apache Kafka.
PI is one of the data sources. On researching, I found PI Integrator for Business Analytics can be used for this.
Please confirm if there can be any other way as I have never used PI Integrator for BA. Moreover below are some queries-
1. As per the document on PI Integrator for BA 2020, advanced edition will be required to stream data to Apache Kafka. Standard edition will not suffice. Kindly confirm.
2. Will a separate license be required for this?
3. Instead of this, can OLEDB be used to transfer real time data to an SQL database(with latency less than few seconds)? Kafka in this case can then further pull the data from the SQL Database.
Any lead and advise on this will be helpful.