• State Not Answered
  • Replies 1 reply
  • Subscribers 93 subscribers
  • Views 153 views
  • Users 0 members are here
Options
Related

Not able to sync view in sync editor - Oracle DB Connector

NewDev_OneIM
4 months ago

Hi Team,

I have a target system - Oracle Database with 1 table and 1 view.

Able to connect to the DB, but only able to see the table not the view in Target System -> Browse

Any idea how to fetch/use the view in the sync editor ?

Any workaround of resolving this issue ?

Thank you in advance.

  • 0 3 months ago

    Is the view an updatable one? Is it part of the same schema as the table in Oracle? Did it show in the connection dialog as selectable?

    If the data should only be synced into OneIM you could use the generic ADO.NET connector using the Oracle .NET Provider. Drawback, you need to provide some more configuration / code if you want to update the data in the Oracle Database fo