Connection issue with OleDB from PIsoft

[mitulvyas]

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

[Anonymous]

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

[mitulvyas]

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