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!

ODI12c - need to read data from a remote sql server database - how to setup dataserver and physical

Deena URSep 28 2018 — edited Oct 10 2018

Hi All,

I appreciate all of your help in the past.

I need to read data from a remote sql server, along with my local oracle db server. I have the server name and a readonly logon to the sql server database. It is necessary to have an 'ODI'

user created on the sql server database? Also what jdbc sql server driver is working for people?

Thank you

This post has been answered by Adrian_Popescu-Oracle on Sep 28 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2018

Added on Sep 28 2018

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

21 comments

1,848 views