topic Re: Connection issue with OleDB from PIsoft in Talend Studio

Connection issue with OleDB from PIsoft

mitulvyas — Sat, 16 Nov 2024 07:49:08 GMT

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

Re: Connection issue with OleDB from PIsoft

Anonymous — Thu, 16 Aug 2018 09:31:23 GMT

Hello,

Please take a look at this doc:

https://docs.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbconnection.connectionstring?redirectedfrom=MSDN&view=netframework-4.7.2#System_Data_OleDb_OleDbConnection_ConnectionString

Best regards

Sabrina

Re: Connection issue with OleDB from PIsoft

mitulvyas — Mon, 27 Aug 2018 18:10:46 GMT

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