Migrating SSIS 2016 to SSIS 2022 (Oracle Attunity to Oracle Connector v1.2) LDAP

Question

We're upgrading from SQL Server 2016 to SQL Server 2022. Our current SSIS packages utilize Oracle Attunity drivers to extract data from an external Oracle database using the LDAP protocol. We plan to switch to the Microsoft Oracle Connector v1.2 connection manager, which works well with tnsnames.ora when using the TNS_Admin environment variable. However, our enterprise ecosystem requires us to use LDAP instead of tnsnames.

We've tried connecting using the EZ Connect format (e.g., "//test23.test.com:1234/sampleDB"), but it hasn't been successful, and we haven't found a workaround for using LDAP for MS Oracle Connector.

Could you please provide guidance on this matter?

Answer 1

Hi @windows_mss,

Microsoft Connector for Oracle doesn't support LDAP protocol.

Behind the scenes it is based on the Progress DataDirect Oracle Wire Protocol ODBC driver. One of the best on the market. You can see it in the Control Panel's ODBC Drivers Tab. Its entry is called Microsoft Oracle ODBC Driver.

Its latest version is 1.3, downloadable here: https://www.microsoft.com/en-us/download/details.aspx?id=105811

Benefits: no need to install Oracle Client(s), and use TNS files.

The best option is to use Oracle Easy Connect format. It works without any problems.

You can read about it here: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntcli/specifying-a-connection-by-using-the-easy-connect-naming-method.html#GUID-1035ABB3-5ADE-4697-A5F8-28F9F79A7504