Please have PI Integrator for Business Analytics supports high availability (HA)
As a user of PI Integrator for Business Analytics, I'd like to have it support high availability (HA).
Please specify what kind of high availability is requested. For PI Integrator for BA to run in a highly available fashion?
To support other applications that are highly available? If so, which ones?
it would be good HA support for both for SQL database and PI Integrator services.
the best would be to have a balanced environment for the Integrator services allowing to run views and streams on all the application nodes. in case of a fault on one will automatically move the jobs on another.
Continued availability of reports in near real time is required. Some reports deal with factors related to safety, legal compliance, etc that are time-sensitive and need to be reliably published on schedule, regardless of availability of the single server that currently handles all integrator operations. Receiving such a report after a significant delay could have serious consequences, including inappropriate management decisions, lost productivity, or continuation of dangerous conditions beyond the normal response time.
HA for the Integrator is requested, compare collective for PI AF. The reason is full uptime of the streams is necessary.
It is also requested that Integrator for BA supports SQL-Server HA. As stated in previous comment, there is ost often a company solution for SQL-server that has built in HA. Using sparate SQL-server solutions only for Integrator for BA causes a lot of administration.
Ignacio Aguirre commented
It might not be extremely necessary to have integrator level HA as it supports History Recovery. But it should be able to support SQL Backend HA.
For the Integrator, a SQL Server Standard or SQL Server Enterprise is recommended.
Most of the time this is a company SQL (non-only for PI purposes) which is built-in HA. This pushes our customers to acquire more SQL licenses.
We had this issue twice in 3 months. Happens during patching. Support for SQL Always On will be great.
Ting-Ying Chung commented
It will be great if PI Integrator for Business Analytics can provide HA options similar to AF, i.e. PI Integrator Framework service HA and SQL database HA.