API/Python/Open-Source Solutions

Expand all | Collapse all

Creating RuleSets

Jump to Best Answer

Gary Hallam02-14-2018 10:21:00 AMBest Answer

Mayank Ahluwalia02-15-2018 02:57:00 PMBest Answer

Mayank Ahluwalia02-15-2018 02:57:00 PM

Gary Hallam02-19-2018 07:07:00 AMBest Answer

Mouhssine SAIDI02-19-2018 08:27:00 AMBest Answer

  • 1.  Creating RuleSets

    Posted 02-14-2018 10:12:00 AM
    We have a Siebel application with approx 5300 tables. If i try to select all tables while creating a ruleset, the ruleset creation keeps showing 'Activity in progress' with an hourglass symbol. I can't click on the ruleset and enter inside to check the inventory.

    Is there an issue due to large number of tables ? Even after days it still shows in progress, so I am assuming the operation in the backend is no longer active.
    #Masking


  • 2.  RE: Creating RuleSets
    Best Answer

    Posted 02-14-2018 10:17:00 AM
    Hi Mayank,

    I suggest you to split your siebel schema into pieces and so into multiple rulesets:
    1. create 5 db users (or more, if needed) and grant them SELECT on a subset of tables (you could use a PL/SQL to iterate lots of tables from the siebel schema)
    2. create 5 connectors (one for each user)
    3. create 5 ruleset using those connectors
    After you created rulesets, come back to the connector list and then change the user with the owner, so you can mask tables inside.

    Regards.
    Gianpiero


  • 3.  RE: Creating RuleSets
    Best Answer

    Posted 02-14-2018 10:19:00 AM
    Hi Mayank,
    If you are having issues it would be worth contacting support.  For large numbers of tables it might be useful setting up a user with access only to the tables that you need and use that for your connector.  In version 5.2 Delphix have introduced a masking configuration API, which might prove useful.  We have leveraged this to introduce our SAP Masking capability with similarly huge numbers of tables.

    If you still have issues let me know and I can try to help you directly.
    Regards,
    Gary


  • 4.  RE: Creating RuleSets
    Best Answer

    Posted 02-14-2018 10:21:00 AM
    Thanks Gianpiero - a far more eloquent and detailed answer than mine!


  • 5.  RE: Creating RuleSets

    Posted 02-14-2018 10:23:00 AM
    Ah ah ah! Thanks.
    Your answer is more effective because you're Delphix Employee.
    Regards.
    Gianpiero


  • 6.  RE: Creating RuleSets

    Posted 02-14-2018 10:57:00 AM
    Thanks Guys, i have already done this as a workaround to proceed further. I just wanted to know why it fails with huge number of tables and if there is a limitation to what can be imported at once.


  • 7.  RE: Creating RuleSets

    Posted 02-14-2018 10:59:00 AM
    Thanks Gary, I understand, unfortunately, we have to profile through all 5300 tables and so for now split rulesets is what i have done, however, I will upgrade to 5.2 and see if we have a solution, else will connect with support. Thanks for the guidance !


  • 8.  RE: Creating RuleSets
    Best Answer

    Posted 02-14-2018 11:21:00 AM
    Okay - well the new API will be ideal for the profiling of lots of tables.  In fact we had a guy in our team demonstrate that to us - we had a customer who complained that he had thousands of tables to profile... You should check it out and if you need some guidance let me know.  There's even an API client to help you on the way, but I might be able to get some sample code to you too.
    The new API Client details here.  Version 5.2.3 is the latest release.
    I have seen the UI slow down with lots of tables (especially wide ones), we build an internal table so it takes some time... but I am not aware of the exact limitations.
    Good luck with your project.
    Gary


  • 9.  RE: Creating RuleSets
    Best Answer

    Posted 02-14-2018 06:50:00 PM
    Hi, I’ve done this experience with one of my customers and can confirm that the issue with huge table list is resolved in 5.2.3 Regards, Mouhssine


  • 10.  RE: Creating RuleSets
    Best Answer

    Posted 02-14-2018 06:53:00 PM
    Hi, I’ve done this experience with one of my customers and can confirm that the issue with huge table list is resolved in 5.2.3 Regards, Mouhssine


  • 11.  RE: Creating RuleSets
    Best Answer

    Posted 02-15-2018 02:57:00 PM
    Thanks Gary, i am getting the upgrade done to 5.2.3 and will check this out.


  • 12.  RE: Creating RuleSets

    Posted 02-15-2018 02:57:00 PM
    Thanks Mouhssine, will try after the upgrade once.


  • 13.  RE: Creating RuleSets
    Best Answer

    Posted 02-19-2018 07:01:00 AM
    So i retested after the upgrade and the import of 5300 tables worked perfectly fine.
    Thanks a lot !


  • 14.  RE: Creating RuleSets
    Best Answer

    Posted 02-19-2018 07:07:00 AM
    Superb!  Well done Mayank, that's great to hear.


  • 15.  RE: Creating RuleSets
    Best Answer

    Posted 02-19-2018 08:27:00 AM
    Thank to my customer for his contribution ;)