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 API Substitution using SRC_JAVA_URL and substring java method

3256519Aug 26 2016 — edited Aug 27 2016

Hi,

I'm trying to retrieve the connect string after text "jdbc:oracle:thin:@" from a JDBC URL.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=myservice)))

I need to modify my load knowledge module to create a DBLINK correctly. The substring method is returning the value "SRC_JAVA_URL") ?> instead.

create datbase link <$=odiRef.getFormattedName("<%=odiRef.getInfo("SRC_CON_NAME")%>")$>

connect to <%=odiRef.getInfo("SRC_USER_NAME")%>

identified by "<%=odiRef.getInfo("SRC_PASS")%>"

using <%=odiRef.getInfo("SRC_JAVA_URL").substring(19)%>

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2016

Added on Aug 26 2016

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

596 views