No tables listed for new Rule Set creation

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi All,

I am unable to list out the table from the rule set connection.My Ms sql connection is successful but it is unable to retrieve the tables from the connection.

Thanks,
Swathy 
Photo of Swathy Sukumar

Swathy Sukumar

  • 886 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,578 Points 1k badge 2x thumb
Each table in SQL Server has a simple name [MY_TABLE] and full name [MY_DB_NAME].[MY_SCHEMA].[MY_TABLE]

In the delphix connector form you have to fill some information, and in particular:
Database Name: [MY_DB_NAME]
Schema Name: [MY_SCHEMA]

Usually all tables are created into the default schema with the name [dbo].
If you can query your table:
select count(*) from [dbo].[MY_TABLE];

then the MY_TABLE is created under the [dbo] schema and you have to fill the Schema Name with the dbo string.