Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle MySQL 2012 heterogeneous connectivity using windows AD authentication

UtsavApr 17 2017 — edited Apr 18 2017

I am facing a challenge, where our application uses two databases Oracle 9i for text data and SQL Server 2012 for BLOBs (attachment/documents)

Now, I've to pull data from these heterogeneous databases along with other metadata information.

Currently, In Oracle side we got a DB user access but in SQL Server we got access using windows Active directory authentication(I can login into database using my windows account)

Is there a way to create a heterogeneous db link which uses windows authentication, and I can access SQL Server tables from Oracle using that db link?

This post has been answered by mxallen-Oracle on Apr 17 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2017

Added on Apr 17 2017

#heterogeneous-connectivity

3 comments

394 views