Delphix Products

Expand all | Collapse all

No tables listed for new Rule Set creation

Jump to Best Answer
  • 1.  No tables listed for new Rule Set creation

    Posted 02-09-2018 06:39:00 AM
    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 
    #Masking


  • 2.  RE: No tables listed for new Rule Set creation

    Posted 02-09-2018 07:22:00 AM
    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.


  • 3.  RE: No tables listed for new Rule Set creation

    Posted 02-09-2018 07:49:00 AM
    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


  • 4.  RE: No tables listed for new Rule Set creation
    Best Answer

    Posted 02-09-2018 08:14:00 AM
    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.



  • 5.  RE: No tables listed for new Rule Set creation

    Posted 02-09-2018 11:58:00 AM
    Thanks a lot Gianpiero.