4 Replies Latest reply on Oct 5, 2018 1:36 AM by jyi

    How can I connect KNIME with PI Archive? Is it PI JDBC Driver a solution?


      Hello everyone, I'm new with PI environment but I want to try some experiments in order to get it soon... but I got in troubles.


      The situation is like this: I'm on the client's side of a real-time database on PI but I would like to do the Streaming analysis from KNIME.

      KNIME allows the reading of real-time databases through JDBC drivers, and I found that PI has its own PI JDBC Driver.

      The restrictions I have, like I said before, I'm on the client's side and only have acces to the PI Archive Server.


      On the other hand, from KNIME platform I have the next window:

      As you can see, the Database Driver is the PI JDBC one. The Database URL is the one with I'm having problems.

      I'm not pretty sure about how should I introduce the statements.

      On first place, I couln't found the protocol for this driver. As an example, for mysql driver KNIME shows me this:

      Second, I have the name of the host and port but, It is necessary to add a prefix or sufix to the host name?

      Third, what can be the database name, It also has a sufix like .sql or comething like that?


      So, in conclusion my questions are:

      To connect realtime or streaming data from PI to KNIME, the PI JDBC is a good idea or there are another ways?

      If this driver is the only solution:

      Which could be the protocol for the PI JDBC Driver?

      Which are the rules to introduce the host, port and database names?


      Thanls so much! I hope someone could help on something...


      Note: with Java 7 version, this could have been solve by the Sun JDBC ODBC Driver, but it is not longer available on Java 8 (I also thought of that as a solution)