Forum Stats

  • 3,769,223 Users
  • 2,252,930 Discussions
  • 7,874,951 Comments

Discussions

Oracle Data Integrator Reverse Engineering not showing Tables

User_XZ9N5
User_XZ9N5 Member Posts: 1 Green Ribbon

I've created a model with a datastore in SQL Server.

But after successful connection and reverse engineering, I can't see the tables in the SQL Server database.

I've tried adding tables, views and systems tables, nothing showing up, even though there are tables on the SQL Server, and the user has select privileges

I've checked the mask, and i have just % there

I've chosen selective reverse engineering for new datastores and existing datastores.

I don't know what else I'm missing that not bringing up the tables.

Any help here?

Answers

  • Adrian_Popescu-Oracle
    Adrian_Popescu-Oracle RomaniaPosts: 1,950 Employee

    Hi,

    Check the permissions of the user setup at Data Server level.

    You can test this by connecting with the same user (setup at Data Server level) in Sql Server Management Studio and creating a query from the same table you expect to see in the model.

    Adrian