AnsweredAssumed Answered

Neo4j APOC failing authentication with OSI PI JDBC

Question asked by Jhatzis on Jun 7, 2020
Latest reply on Jun 19, 2020 by gregor

I'm trying to use Neo4j APOC to connect to and query data from a OSI-PI Historian using the OSI-PI JDBC driver.

I'm able to successfully load the driver using: CALL apoc.load.driver("com.osisoft.jdbc.Driver");

When I run my test query, i'm getting a security error that states the credentials are invalid and that I must enter a username. A prompt then appears to allow authentication, when I enter the correct user credentials I'm given the same error.

CALL apoc.load.jdbc("jdbc:pioledbent://[Servername]/DataSource=[Datasourcename];DCA=[filename].dca;ProtocolOrder=https/Soap:5461,NetTcp:5462;","[Table]")YIELD row RETURN row.Name;

Error-Picture

Outcomes