OSISoft PI Integration

[bmurugan]

Hi,

As per the below

PTC and OSIsoft to Collaborate to Accelerate Industrial Internet of Things Solution Development | PTC

Are there any ready made connectors available to take data from OSISoft PI to Thingworx?

Thanks,

Bala

[PaiChung]

You can already use the OSI PI JDBC driver to connect using Thingworx

[bmurugan]

Thanks for the information.

In Marketplace, I could see  "JDBC Connector Extension" connector.

Can we use ThingWorx Integration Runtime connector to connect using REST Protocol in OSI PI?

Thanks,

Bala

[keriw]

Hi Pai,

I have installed the JDBC driver in Thingworx and have verified my jdbc connectivity outside of ThingWorx via GetSnap from the same server.  When I test a query service though I am receiving back Cannot get a connection, pool error Unable to validate object.  Any thoughts, on what I may have misconfigured?

Thanks,

Keri

[PaiChung]

Can you post your full configuration of the database Thing?

If the application log doesn't say an authentication problem, then it could be the Validation Statement

That Validation statement has to be a valid osi pi statement

besides that it might be firewalls?

[keriw]

It was the validation statement, wasn't even thinking that it would be different than the standard Select GetDate().

Thanks for the assist!

Keri