Connecting to Oracle using Microsoft Oracle Source Component by Attunity via LDAP for SQL 2022 Upgrade

Question

Connecting to Oracle using Microsoft Oracle Source Component by Attunity via LDAP for SQL 2022 Upgrade

MakingEasyLookHard 0

We are upgrading from SQL Server 2016 to SQL Server 2022.. Our current SSIS packages use the Attunity drivers for 2016 to pull data from an external Oracle server database using LDAP protocol. We understand that Microsoft has created the Microsoft version of this component and upgrading the package went smoothly as it recognizes the connection manager. But our packages no longer work. It's as though it doesnt handle LDAP requests. This kept us from going to SQL 2019 like a year or two ago and we assumed it was fixed for SQL 2022. Is there anything we should be doing or is LDAP still not supported with this?

0 comments

2 answers

Your answer

Answer 1

Yitzhak Khabinsky 27,106

Hi @MakingEasyLookHard,

Microsoft Connector for Oracle is not rebranded Attunity Oracle driver.

Microsoft licensed Progress DataDirect Oracle Wire Protocol ODBC driver and created Microsoft Connector for Oracle.

Check it out its details here: https://www.progress.com/odbc/oracle-database

Immediate benefits:

It doesn't require Oracle Client installed. 😊
It doesn't require TNSes.
It supports a so called Easy Connect format:

SERVER=//host:port/service_name;USERNAME=<YourUserName>;PWD=<YourPassword>;WINAUTH=0

Oracle has identical Easy Connect format, documented 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

Elliott, D (EDW) 5 Reputation points

2023-07-13T19:48:25.4+00:00

Yitzhak, when I say rebranded this connector Microsoft Connector for Oracle replaces the Attunity drivers, as stated by the page you link to, starting in version SQL Server 2019. That is why I called them rebranded. Attunity drivers in SQL 2016 support LDAP connectivity to Oracle. This new connector does not, hence the problem. Easy Connect only works for local Oracle databases and our vendor is not local. We have to connect to them via LDAP. Have you had any luck using these new drivers to make an LDAP connection?
Yitzhak Khabinsky 27,106 Reputation points

2023-07-13T20:06:09.45+00:00

@Elliott, D (EDW),

IMHO, the Microsoft Connector for Oracle doesn't support LDAP connection. Please check the link that I provided if the original Progress DataDirect Oracle Wire Protocol ODBC driver supports LDAP connections.
Yitzhak Khabinsky 27,106 Reputation points

2023-07-13T20:12:25.8366667+00:00

It seems it does support it:

https://docs.progress.com/bundle/datadirect-oracle-odbc-80/page/Using-LDAP.html

So, you need to ask Microsoft to add support for it.

You can do it here, in the Comments section: https://techcommunity.microsoft.com/t5/sql-server-integration-services/general-availability-of-microsoft-connector-for-oracle/ba-p/1385558
Elliott, D (EDW) 5 Reputation points

2023-07-13T20:50:39.11+00:00

Thank you Yitzhak! I will make the request. Not sure if it will do anything because we submitted an entry in the blog last year and saw a little chatter from some others with the same problem so we figured it would be fixed by now. Pretty disappointing.. but thanks for the link to Progress DataDirect Site as a possible alternative. We will probably research that and see if it is a viable and cost effective route to go.
Yitzhak Khabinsky 27,106 Reputation points

2023-07-13T20:59:58.18+00:00

Hi @Elliott, D (EDW), please contact me privately on LinkedIn. I will share with you how to contact Microsoft Connector for Oracle development team directly.

Answer 2

ZoeHui-MSFT 41,551

Hi @MakingEasyLookHard,

we assumed it was fixed for SQL 2022

Not sure it was fixed for SQL2022 or not.

If you want to load data from Oracle. it is highly recommended to use Microsoft Connector for Oracle.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Elliott, D (EDW) 5 Reputation points

2023-07-13T17:36:41.7133333+00:00

Zoe, that is the point of this post. We are trying to use Microsoft Connector for Oracle but it doesnt support LDAP connectivity like the Attunity drivers did. Dont understand why the rebranded driver lost capability and I also dont understand why it is still not fixed. We scrapped our plans to go to SQL 2019 because we thought for sure it would be addressed by SQL 2022 but we still cannot connect using the new Microsoft branded Attunity Oracle drivers or Microsoft Connector for Oracle to connect via LDAP which is all our vendor supports. Huge roadblock for us.

Share via

Connecting to Oracle using Microsoft Oracle Source Component by Attunity via LDAP for SQL 2022 Upgrade

2 answers

Your answer