cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

OSISoft PI Integration

Level 1

OSISoft PI Integration

Hi,

As per the below

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

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

Thanks,

Bala

5 REPLIES 5

Re: OSISoft PI Integration

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

Re: OSISoft PI Integration

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

Re: OSISoft PI Integration

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

Re: OSISoft PI Integration

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?

Highlighted

Re: OSISoft PI Integration

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

Thanks for the assist!

Keri