Talend and OLE DB Connection to MS SQL

[Waffle]

Hello Everyone,

Using SSIS I'm noticing that the Microsoft Software seems to include directly a way to connect to an OLE DB Azure MS SQL.

I'm not finding a way to work with OLE DB with Talend.

Do you have an idea how I could manage that ?

Respectfully,

Waffle

[Anonymous · Accepted solution]

Hello,

So far, here is only support for Microsoft Azure SQL Database (via JDBC) in talend.

The following OleDB components are removed from the Talend 7.3 General Availability release onwards:

tOleDBInput

tOleDBOutput

tOleDBRow

Best regards

Sabrina

[williamedward2120]

Connecting Talend with MS SQL via OLE DB can be tricky, especially when dealing with drivers, authentication, and compatibility issues. A clear understanding of connection settings and proper configuration makes the integration smoother and more reliable for data workflows. Using press release for books can also help authors get their content noticed in niche communities.

[jacobnoah9876]

A thoughtfully designed workspace plays a key role in improving efficiency and creativity. Simple adjustments like organized layouts, comfortable seating, and proper lighting can significantly enhance productivity and overall work performance.