Receive Data from Oracle Internet Directory

Question

Receive Data from Oracle Internet Directory

Tis

SSC Veteran

Points: 252
More actions
August 2, 2012 at 4:04 am

#260067

Hi all...
I have to create a view that shows data from a OID (Oracle Internet Directory).
I created a linked server, that uses "OLE DB Provider for Microsoft Directory Services" and tried to query by LDAP. But it does not work.
Anyone with experience?
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

I googled "SQL server linked server to "Oracle Internet Directory" " with no luck at all;

how often does the data change in the "Oracle Internet Directory"? is it something you could export to text, and import into SQL via BULK INSERT or SSIS as a table instead of a view, refreshing it at intervals appropriate to the amount of changes that occur? if it's pretty much static, it doesn't really need to be a view to a linked server right? if it changes a lot, i would look deeper into creating the linked server to do it.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Tis SSC Veteran Points: 252 More actions · Answer 2

Thanks for your reply.

This OID changes daily. In the end this should become the source for a synchronization between the OID and MSSQL-Data. And this synchronization should run unattended several times per day.

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

Tis (8/2/2012)
... tried to query by LDAP. But it does not work.

Would you mind in defining "does not work"?

OID is supported by an Oracle database therefore a SQL Server side linked server pointing to the underlying Oracle database - provided the connection presents itself with the right credentials, should suffice to provide the needed access.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Tis SSC Veteran Points: 252 More actions · Answer 4

I don't mind defining... 🙂

I get errors like:

The provider indicates that the user did not have the permission to perform the operation.

Access to the remote server is denied because no login-mapping exists.

But anyway, I guess it is just not possible to access OID by "OLE DB Provider for Microsoft Directory Services".

I can't access the Oracle-DB, the company policy does not allow that. I have to access OID by LDAP.

Tis

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 5

Tis (8/2/2012)
I get errors like:
The provider indicates that the user did not have the permission to perform the operation.
Access to the remote server is denied because no login-mapping exists.
Tis

Sounds like you're not using the right credentials to the OID.

Tis SSC Veteran Points: 252 More actions · Answer 6

Sounds like you're not using the right credentials to the OID.

Yes, but I can login to OID with these credentials with a LDAP Browser.

This is what I have to use as value for the user name: cn=clientele_dev_01,cn=tech_users,cn=dev_env,o=******,c=ch

I guess that OID can't handle the credentials if I'm using the ADsDSOObject to connect. ... I dont't know.

I tried for days to find a working solution. I would like to know if anyone ever accomplished to read data from OID into a view.

Tis

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 7

Right, your LDAP credentials may be fine. But SQL Server isn't connecting to the OID Linked Server using LDAP. I know the provider you're using should technically be LDAP b/c that's what AD uses also but I wouldn't trust MS LDAP and Oracle LDAP to speak to each other easily.

I know it mentions SQL 2005, but have you tried something like this: MSDN.

Edited for clarity.

Tis SSC Veteran Points: 252 More actions · Answer 8

I know it mentions SQL 2005, but have you tried something like this: MSDN.

Thank you for this link but I still can not find a working solution for MSSQL-OID.

Tis SSC Veteran Points: 252 More actions · Answer 9

I have found no solution for this.

Best answer is here: http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/f1265c43-da8d-44c5-8788-14639ba01376

Thank you for trying to help me.