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!

Cannot view data from MS SQL Server 2012 R2

User_H59MFDec 7 2017 — edited Jan 16 2018

As a new user, I got the Data Integrator Version 12.2.1 installed on Windows Server 2012 R2 with repository in RHEL\Oracle 12c

Topology\Technologies\Microsoft SQ Server:

weblogic.jdbc.sqlserver.SQLServerDriver

jdbc:weblogic:sqlserver://xx.x.x.xxx:1433;DatabaseName=Source_MSSQL;

I was successful making the connection in the ODI Studio\Designer\Models\Source MSSQL and reverse engineered all user tables.

When I started to map from source MSSQL to target Oracle, the source column datatypes were undefined.

And I am not able to view data and errors ODI-23038 & ODI-26128 were displayed.

I am able to view data in target Oracle but just not from the source MSSQL.

Any help is appreciated.

ODI-23038: Cannot resolve the table name. Check the masks defined for this physical schema.

ODI-26128: Unable to open Editor

This post has been answered by Adrian_Popescu-Oracle on Dec 7 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2018

Added on Dec 7 2017

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

11 comments

784 views