Connection issue with OleDB from PIsoft

Five Stars

Connection issue with OleDB from PIsoft

Hi All,

I have been trying to connect with the OleDB provided by PIsoft. But not working.

For POC, I am using a simple structure as below:

(tOleDBInput --> tlogrow)

Could you please advise on the following aspects?
1. Are there any pre-requisites for connecting with OleDB? On windows as well as Linux environment?
2. Any driver / connector installation required?
3. What should be a typical connection string for such connection?

Kindly respond at the earliest.

Regards,

Mitul Vyas

Moderator

Re: Connection issue with OleDB from PIsoft

Hello,

Please take a look at this doc:

https://docs.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbconnection.connectionstring?redir...

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Connection issue with OleDB from PIsoft

Thanks Sabrina.

 

I could connect through the Talend studio on Windows system.

 

But could you please advise me how to connect with the same system on Linux environment?

 

I have been trying to connect using JDBC connection using PI JDBC driver, but not working. I believe it is because PI JDBC driver only uses a specific port, whereas PI DAS server is active on a different port.

 

Could you please advise if someone has already implemented similar solutions?

 

Regards,

Mitul Vyas

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download