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!

JDBC URL for Complex File (ODI 12.1.3)

Jang-Vijay SinghMay 22 2015 — edited May 28 2015

Hi,

Using ODI 12c, I'm trying to set up a data server for Complex File technology (under Topology -> Physical Architecture -> Complex File)

I want the staging tables where the file gets loaded to be in a separate database and not the in-memory hsqldb

To do that, under the JDBC tab, i'm supplying this URL:

jdbc:snps:complexfile?f=C:/temp/Mydsample7.txt&d=C:/temp/MySchema7.xsd&re=FileRootElement&dp_driver=oracle.jdbc.driver.OracleDriver&dp_url=jdbc:oracle:thin:hr/hr@localhost:1521:XE

Even though my oracle JDBC connection details are fine (as I can connect via sqlplus), when I "Test Connection" via ODI, I keep getting:

Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

IS there something wrong with the above setup? How can I get the staging tables to get created in a user defined schema?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2015

Added on May 22 2015

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

2 comments

1,107 views