I have one requirement states that the lighting subsystem will have the temperature,luminous etc as a parameters to be stored in PI database as well there can be multiple subsystems also.
Is there is a way to exclude the IntegratedSecurity=SSPI in connectionString URL? Is it possible to include the username and password in the connection string URL?
For the above requirement, What can be approach to store the parameters under the lighting sub system and manipulate as well as retrieve the data from PI database?
I am using the Java application to connect with the PI database and able to retrieve the data by using PI JDBC.
Is it possible to execute the DML SQL using java application PI-JDBC interface in PI database?