No tables listed for new Rule Set creation

  • 0
  • 1
  • Question
  • Updated 5 months 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

  • 866 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,314 Points 1k badge 2x thumb
Did you try to use the "dbo" (usually "dbo") schema in the connection?
Do not use the istance name in the connector (leave it blank).
Best Regards.
Photo of Swathy Sukumar

Swathy Sukumar

  • 866 Points 500 badge 2x thumb
Hi Gianpiero,

Its working fine now.Could you please tell me the use of dbo schema name in the connection.

thanks for your help.

Regards,
Swathy
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,314 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.
Photo of Swathy Sukumar

Swathy Sukumar

  • 866 Points 500 badge 2x thumb
Thanks a lot Gianpiero.