How can we improve PI Integrators?

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.

12 votes
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...
  • Brent Bregenzer commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED