Database connector node for PI OSISOFT Database

database

#1

Greetings to everyone. I hope someone could help me out with the sequence of steps to configure the DataBase Connector or Database Table Connector nodes to a PI OSISOFT Database.

I have installed the PIJDBC Driver and I already add it to the Knime Preferences Database Drivers.

When trying to configurate the node I select the com.osisoft.jdbc.Driver and then on the Database URL it appears:

  <protocol>://<host>:<port>/<database_name>

How do I substitute this labels, is the main question. What does it mean “protocol” and how do I find the one I need? Because for SQL the example is:

   jdbc:mysql://host:port/database_name 

Thanks!


#2

Hi there!

I believe jdbc is the protocol used here as well. Try with it.

Br,
Ivan