Allow Configuration of Target Table Name from View for PII4BA
We have a use case where there is a need to publish data from one PI Integrator instance to multiple environments for IT to run through their dev / test / prod on the datalake setup. Our targets are SAP HANA instances, but this problem applies to all targets as it is inherent in the setup of the Integrator that the table name created is the same as the view name.
Right now this requires the view names to change between targets and the view name is the name of the database table that is created. I would like to see either:
- the database table name to be configurable
- uniqueness constraint to be View name + target and not just view name.
I believe option 2 would be the easiest to implement as you could just check the 2 together to make sure the combination is unique. With configurable table names, you might end up with name collisions unless you the Integrator checks those for uniqueness in the same fashion of table name + target.