Skip to Main Content

Analytics Software

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!

ODI 12.2.1.2.6 Topology for OWB Runtime Repository. No tab to enter JDBC driver and connection strin

Nelson G.Aug 1 2018 — edited Aug 2 2018

I'm looking to create a topology in ODI 12.2.1.2.6 to connect to OWB 11.2.0.4. When I right click on the OWB Runtime Repository and select New Data Server the page opens but there is no JDBC tab. So I enter all information as per (Doc ID 2063425.1)  and create the new physical schema. create the logical architecture and package with OdiStartOwbJob. I enter the Workspace Name value from drop down (Logical name appears). When I click in Location Name I get ODI-13702: Unexpected error when connecting to OWB workspace IDW_WORKSPACE.IDW_OWNER. What am I missing.

I queried the repo table SNP_CONNECT and the DSERV_NAME, JAVA_DRIVER and I_TXT_JAVA_URL are NULL.

This is a fresh ODI 12C install no prior ODI 11G installed here. I migrate OWB 11.2.0.4 into ODI 12.2.1.2.6. great job of migrating all objects including dimensions and cubes.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2018
Added on Aug 1 2018
5 comments
251 views