Comments
Sort by recent activity
Hi @PlantBasedSQL Thanks for the information. I do have one more question ,Can we upload XML files, JSON files into database records using "Insertion"? I have seen that there is an option to insert from Disk ,and those files resides in the "Data sets ".Since I don't have needed privileges, I can't update the data sets and see whether it supports xml, JSON or not Thank you, Arun / comments
Hi @PlantBasedSQL Thanks for the information. I do have one more question ,Can we upload XML files, JSON files into database records using "Insertion"? I have seen that there is an option to insert...
Hi @PlantBasedSQL Thank you so much for the detailed explanation. I will be having a meeting with the tool support team, just wanted to have some things ready before going to that meet. Thank you, Arun / comments
Hi @PlantBasedSQL Thank you so much for the detailed explanation.I will be having a meeting with the tool support team, just wanted to have some things ready before going to that meet.Thank you,Arun
Hi @PlantBasedSQL My bad. I didn't get a chance till today and Yes I did exactly as you mentioned and it's working great. Thanks you soo much:) / comments
Hi @PlantBasedSQL My bad. I didn't get a chance till today and Yes I did exactly as you mentioned and it's working great.Thanks you soo much:)
Hi @PlantBasedSQL, I was able to perform basic XML masking and working on Insertion and Masking multiple tables with synchronization. As you know from our previous conversation I have the same data in 2 tables and I wanted to get the synchronized records after masking. I am able to perform the same in single table but for 2 tables, I even tried multiple ways like having Table-To -Table rules, Synch manager, etc., but couldn't get the results. I am thinking that I have to add some additional rules to my masking set which I used for single table masking. I might be missing the order of rules. Below is the sample data in 2 tables(attaching one screen shot since the same data exists in 2 tables) [image] If you can suggest me a better way that would be great. Thanks, Arun / comments
Hi @PlantBasedSQL,I was able to perform basic XML masking and working on Insertion and Masking multiple tables with synchronization.As you know from our previous conversation I have the same data i...
Hi @PlantBasedSQL Thank you so much for the step by step explanation, it worked well and I've got the expected results. In my Implementation I have so many scenarios that I have to work. Since we have the license for the tool, do you think of any licensed video courses (besides official documentation and 10 courses on Red Gate website) for customers who bought the tool. If there are any that would be helpful. Below ae some of my scenarios I am going to work. 1)Same data masking in multiple tables with consistency 2)XML masking 3)Data Insertion Thank you, Arun / comments
Hi @PlantBasedSQL Thank you so much for the step by step explanation, it worked well and I've got the expected results.In my Implementation I have so many scenarios that I have to work. Since we ha...
HI @PlantBasedSQL That was so helpful and thanks for the clear explanation. Everything is good except that I wanted to perform masking for some specific records(like "where id in (2,3,4,5,6)").So my actual scenario is to apply masking to those records ONLY.I wanted to have this where Clause in my substitution rule. When I had this Where Clause, I can't achieve the consistent masking with name because I didn't convert the Substitution into "Synch Manager Rule" . If I convert the Substitution into Synch Manager I can't insert my where Clause. I tried having Where Clause in command rule before the substitution rule but it did not help. So in short I wanted to have a where clause in your process which you explained in previous reply. Thank you so much for your time. / comments
HI @PlantBasedSQL That was so helpful and thanks for the clear explanation. Everything is good except that I wanted to perform masking for some specific records(like "where id in (2,3,4,5,6)").So ...
Hi @PlantBasedSQL, I have tried the way you mentioned with Substitution and Row Internal but the same name value in the same column is not getting masked in a consistent way. That is the reason I went with Synch Manager Rule. Please see the below pic. [image] [image] [image] And with the synch manager I was not able to enter the Where Clause as I mentioned in my earlier post(please see the picture). Thank you, Arun / comments
Hi @PlantBasedSQL,I have tried the way you mentioned with Substitution and Row Internal but the same name value in the same column is not getting masked in a consistent way. That is the reason I we...
Hi @PlantBasedSQL, Thanks for the quick response .It really helped and I was able to get the synchronization. / comments
Hi @PlantBasedSQL,Thanks for the quick response .It really helped and I was able to get the synchronization.
HI @PlantBasedSQL I have an extended requirement for the above use case. Please see the attached sample data [image] [image] I have to mask both the columns from the picture. I tried the way you suggest with synch manger rule. Please see the steps I followed to mask the above data. **The first 3 steps are same as you suggested. 0 1 -0001 - Substitution Rule (mask both name fields with First Names, for security) x x -0002 - Row-Internal Rule (set [lower first name] to LOWER itself) x x -0003 - Row-Internal Rule (set upper first name to UPPER [lower first name]) The final step is I have converted the Substitution Rule into "Synch Manager Rule" . But the issue is I can't have the "Where clause " before converting the Substitution Rule into "Synch Manager Rule" and after conversion there is no Option to enter the Where Clause. I tried inserting the where Clause in "Row Internal" but has no effect. What ever the Options I tried under "Where Clause and Sampling " tab in "Row Internal" that has no value in the masking of two columns except maintaining the consistency in masking values. My motive is to mask the selected records and also not mask the NULL values as shown in picture. Thank You, Arun. / comments
HI @PlantBasedSQL I have an extended requirement for the above use case. Please see the attached sample dataI have to mask both the columns from the picture. I tried the way you suggest with synch ...
Hi @PlantBasedSQL, Thanks for the quick response .It really helped and I was able to get the synchronization. / comments
Hi @PlantBasedSQL,Thanks for the quick response .It really helped and I was able to get the synchronization.