APIPythonOpen-Source Solutions

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

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

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

Thanks Gianpiero - a far more eloquent and detailed answer than mine!

Ah ah ah! Thanks.
Your answer is more effective because you're Delphix Employee.
Regards.
Gianpiero

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.

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 !

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

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

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

Thanks Gary, i am getting the upgrade done to 5.2.3 and will check this out.

Thanks Mouhssine, will try after the upgrade once.

So i retested after the upgrade and the import of 5300 tables worked perfectly fine.
Thanks a lot !

Superb!  Well done Mayank, that's great to hear.

Thank to my customer for his contribution ;)