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:
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;