Allow default schema to be configurable
Our Database Administrator would like the Integrator to publish using a different schema than dbo for SQL targets, so I would like this to be configurable in the Integrator. Currently it is not possible to change it from the default dbo.
This idea is planned as an update to the SQL writer for the next release after PII4BA 2018 R2 SP1.
Brent Bregenzer commented
I ran into a similar issue with an Oracle target. In this case, the schema corresponds to the user name, but if the user also has access to other schemas, then you hit issues if the table name exists in multiple schemas. So I think this request could be generalized to multiple relational targets.
Nick Pabo-Eulberg commented
I was able to get the PI Integrator for Business Analytics to publish to a different schema by changing the default schema associated with the SQL Login used to write data to the SQL Target. This SQL Login was also db_owner of the Target SQL database, so there may be other permissions needed if your SQL Login has lower permission.