This content has been marked as final. Show 5 replies
For LDAP default user Root is having all the priviledge to access all the Ldap data.
Go to physical architecture and insert a new dataserver
user - cn=root,dc=css,dc=hyperion,dc=com [ change this according to your requirememnt for you it will be *cn=Administrator ,dc=oracle,dc=com* ]
password - null
jdbc driver : com.sunopsis.ldap.jdbc.driver.SnpsLdapDriver
jdbc url : jdbc:snps:ldap?ldap_url=ldap://<server name :port/&ldap_password=KLLEJMNLKFLBKLKODDGPGPDB&ldap_basedn=dc=css,dc=hyperion,dc=com
[ for you it will be *jdbc:snps:ldap?ldap_url=ldap://ten.mydomain.com:636/&ldap_password=<encoded password>ldap_basedn=dc=oracle,dc=com* ]
Here the Default Ldap password for ROOT is SECURITY and if its changed or you are using for some other user . Please use that .
you also need to encode the password using this command
java -cp C:\OraHome_1\oracledi\drivers\snpsldapo.jar com.sunopsis.ldap.jdbc.driver.SnpsLdapEncoder <enter password here>
Later test the connection and you should be able to connect successfully.
That solved the issue.
Thanks a lot for your help.
So, the trick here is that, JDBC URL should have ldap_password and ldap_baseddn only and not username.
I am trying to connect to MQ through JMS queue. I tried with existing drivers , i got error as "Cannot create the initial JNDI context". Then my MQ team told me to use com.sun.jndi.fscontext.RefFSContextFactory driver for JNDI.
when I used this as JNDI driver and click on JNDI Url it says "Thsi driver is not referenced in the list of URLs"
Any idea how to add this driver in ODI ?
under the topology - > JMS queue - > jndi tab
put the driver
JNDI DRIVER = com.sun.jndi.fscontext.RefFSContextFactory
JNDI URL = file:// [ where the required jndi directory is ]
Refer to the metalink.oracle doc id -Doc ID: 552671.1 for more information .
Thanks a lot for the doc ref. I have tried all the steps mentioned in the document but having some issue connecting to MQ server
getting error as
"7000 : null : com.sunopsis.sql.l: Oracle Data Integrator Timeout: connection with URL JDBC:SNPS:JMSQueue:jndi:file:/C:\JNDI?factory.initial=com.sun.jndi.fscontext.RefFSContextFactory&jndi_ressource=NYDEXQCF&security.authentication=None& and user"
I guess my ODI setup is right , now i have to check the MQ setups.