This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 98%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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?
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 47%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
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:
SERVER=//host:port/service_name;USERNAME=<YourUserName>;PWD=<YourPassword>;WINAUTH=0
Oracle has identical Easy Connect format, documented here:
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?
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.
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
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.
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.