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