Hope you could help me on my query. My first time to configure PI Integrator for BA. Im a bit confuse on adding up another SQL Server in PI Integration for BA. Do I need to config all of these security(see screenshot: Database security) when creating the database on another Target SQL Server?
Because when i tried to add another SQL Server. When i create table and publish it only on the 1st SQL server where created. It does not create into the 2nd SQL Server.
Do i need to fill up to the SQL Autentication user and password? the publishing timeout?
TIA for your suggestions