Creating RuleSets

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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.
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,466 Points 1k badge 2x thumb
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
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,946 Points 1k badge 2x thumb
Thanks Gianpiero - a far more eloquent and detailed answer than mine!
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,466 Points 1k badge 2x thumb
Ah ah ah! Thanks.
Your answer is more effective because you're Delphix Employee.
Regards.
Gianpiero
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb
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.
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,946 Points 1k badge 2x thumb
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
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb
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 !
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,946 Points 1k badge 2x thumb
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
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb
Thanks Gary, i am getting the upgrade done to 5.2.3 and will check this out.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb
Thanks Mouhssine, will try after the upgrade once.
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb
So i retested after the upgrade and the import of 5300 tables worked perfectly fine.
Thanks a lot !
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,946 Points 1k badge 2x thumb
Superb!  Well done Mayank, that's great to hear.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
Thank to my customer for his contribution ;)
(Edited)
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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