I would like to inquire regarding the configuration for PI integrator for BA going to MS SQL.
why does when publishing the table to its configured ms sql "PI VIEW" the database name is different?
see screenshot below:
The table name is: ValidatedTags
MS SQL Destination: PI View [default]
MS SQL Database: why does the name is diffrent and must be ValidatedTags?
But when adding another MS SQL Server i have no problem the database Name in sql is the same name in PI Integrator BA
My Table name in PI Integrator is ValidatedTagsDEV
MS SQL Destination
MS SQL Database
Do i need to create new database in my 1st SQL? and add a publish target pointing in the 1st SQL?
Appreciate your help. TIA!