Topic
19 replies Latest Post - ‏2012-09-18T05:47:56Z by SystemAdmin
SystemAdmin
SystemAdmin
304 Posts
ACCEPTED ANSWER

Pinned topic IBM OPTIM - Masking Techniques

‏2012-09-04T06:49:44Z |
For Data Masking using Optim v8.1 , we see there are only 3 masking techniques like CCN, Email and SSN
what are the other techniques available or which ibm optim support for data masking ?
Updated on 2012-09-18T05:47:56Z at 2012-09-18T05:47:56Z by SystemAdmin
  • RajeshKumarSingh
    RajeshKumarSingh
    9 Posts
    ACCEPTED ANSWER

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-04T07:00:43Z  in response to SystemAdmin
    Hi

    Other Masking Provider are Lookup ,Age ,Trans COl ,shuffle ,you can use any one as per your requirement ,
    please go through Optim document for complete syntax details .
    If you are using Optim 8.1.3 then you can use Trans Nid masking provide by which you can mask 6 diff country NID.
    Nid countries are US,CS,UK,ES,FR and IT ..

    BTW can you tell me what kind of masking you are looking ..

    Also Optim provides User Column Map Routine where a user can write his own logic (C/C++ code) to mask data ,build it out of optim can call build lib from optim ..

    Rajesh
    • SystemAdmin
      SystemAdmin
      304 Posts
      ACCEPTED ANSWER

      Re: IBM OPTIM - Masking Techniques

      ‏2012-09-04T08:15:13Z  in response to RajeshKumarSingh
      Thanks for the response. It was very helpful. I will revert back if I need help again.
    • SystemAdmin
      SystemAdmin
      304 Posts
      ACCEPTED ANSWER

      Re: IBM OPTIM - Masking Techniques

      ‏2012-09-04T13:55:46Z  in response to RajeshKumarSingh
      Currently, we are using Lookup Function for replacing the source values with the lookup table values as a part of masking. We need to understand , if the lookup table can be a flat file as well ?
      • RajeshKumarSingh
        RajeshKumarSingh
        9 Posts
        ACCEPTED ANSWER

        Re: IBM OPTIM - Masking Techniques

        ‏2012-09-05T07:19:16Z  in response to SystemAdmin
        No in Optim lookup ,lookup table can't be flat files ..as a alternative you can write your own column map exit out of optim whether you can write code access flat files as a lookup tables ,but for that you have to write whole code /logic ..
        • SystemAdmin
          SystemAdmin
          304 Posts
          ACCEPTED ANSWER

          Re: IBM OPTIM - Masking Techniques

          ‏2012-09-05T14:08:16Z  in response to RajeshKumarSingh
          Thanks for your response. It was very helpful.

          Can you please tell us about Propogation function(Masking).

          We are unable to carry out the cascading activity by using the propogation function.

          Thanks in advance.
          • RajeshKumarSingh
            RajeshKumarSingh
            9 Posts
            ACCEPTED ANSWER

            Re: IBM OPTIM - Masking Techniques

            ‏2012-09-05T17:39:21Z  in response to SystemAdmin
            Propagate Primary or Foreign Key Value Function
            The Propagate Function assigns a value to a primary key or foreign key column and propagates that
            value to all related tables.
            You can look in rt4scomn.pdf file under doc folder inside rt folder which comes within optim installation folder .

            Please look at page No 148 ,

            Can you please tell me what is your masking requirement,then I would suggest a easy ,complete end to end masking solution ..

            Thanks
            Rajesh
            • SystemAdmin
              SystemAdmin
              304 Posts
              ACCEPTED ANSWER

              Re: IBM OPTIM - Masking Techniques

              ‏2012-09-13T05:23:01Z  in response to RajeshKumarSingh
              Hi thanks a lot for your replies. They were very helpful.

              We are trying to implement propagation using a few masking techniques, but even though the parent table is getting loaded with the masked values, the corresponding values are not getting propagated.

              Kindly help us in resolving this...

              Thanks in advance.
              • RajeshKumarSingh
                RajeshKumarSingh
                9 Posts
                ACCEPTED ANSWER

                Re: IBM OPTIM - Masking Techniques

                ‏2012-09-13T07:32:46Z  in response to SystemAdmin
                Hi ..

                Could you please provide me answer for the following query then only I will be able to find out issue.

                1. How Many Tables you have and what relationship they have is it DB relation or Optim relation ?
                2. What are data types of column on which you are applying propagate function .
                3 Please provide me complete syntax of column map which you used for propagation

                Thanks
                Rajesh
              • RajeshKumarSingh
                RajeshKumarSingh
                9 Posts
                ACCEPTED ANSWER

                Re: IBM OPTIM - Masking Techniques

                ‏2012-09-13T07:32:49Z  in response to SystemAdmin
                Hi ..

                Could you please provide me answer for the following query then only I will be able to find out issue.

                1. How Many Tables you have and what relationship they have is it DB relation or Optim relation ?
                2. What are data types of column on which you are applying propagate function .
                3 Please provide me complete syntax of column map which you used for propagation

                Thanks
                Rajesh
                • SystemAdmin
                  SystemAdmin
                  304 Posts
                  ACCEPTED ANSWER

                  Re: IBM OPTIM - Masking Techniques

                  ‏2012-09-13T10:53:40Z  in response to RajeshKumarSingh
                  Hi..

                  We have 2 tables, 1 Parent and 1 Child.

                  The relationship is maintained both at DB and Optim Level.

                  The data type of columns is CHAR(5).

                  Please find the snap of the column map used for propagation in the attachment.

                  Thanks.
                  • RajeshKumarSingh
                    RajeshKumarSingh
                    9 Posts
                    ACCEPTED ANSWER

                    Re: IBM OPTIM - Masking Techniques

                    ‏2012-09-13T11:29:31Z  in response to SystemAdmin
                    Hi

                    Same request is working fine for me ,I tested in my environment ,prop is masking data in optim_customers and custid value in optim_orders table have been populated with masked data ..

                    Have you override nay DB relation with Optim relation ?

                    Make sure during traversing check only one relation either DB or optim

                    BTW what is your second (child ) table ? is it optim_orders ?

                    Thanks
                    Rajesh Singh
                    • SystemAdmin
                      SystemAdmin
                      304 Posts
                      ACCEPTED ANSWER

                      Re: IBM OPTIM - Masking Techniques

                      ‏2012-09-13T11:46:46Z  in response to RajeshKumarSingh
                      Hi..

                      Second table is Optim Orders and pls find attached the snaps for our Access Definition. and explain "Make sure during traversing check only one relation either DB or optim ". Is it that the relation wud be defined only for either table level or Optim Level ????

                      Thanks.
                      • RajeshKumarSingh
                        RajeshKumarSingh
                        9 Posts
                        ACCEPTED ANSWER

                        Re: IBM OPTIM - Masking Techniques

                        ‏2012-09-13T12:55:37Z  in response to SystemAdmin
                        please un check ref check box on AD and then try it ,will work

                        Thanks
                        Rajesh
                        • SystemAdmin
                          SystemAdmin
                          304 Posts
                          ACCEPTED ANSWER

                          Re: IBM OPTIM - Masking Techniques

                          ‏2012-09-17T06:16:38Z  in response to RajeshKumarSingh
                          Thanks a lot for your support.

                          The problem was resolved and the propagate function is working fine.

                          Thanks..
                        • SystemAdmin
                          SystemAdmin
                          304 Posts
                          ACCEPTED ANSWER

                          Re: IBM OPTIM - Masking Techniques

                          ‏2012-09-17T12:00:15Z  in response to RajeshKumarSingh
                          Hi

                          Can anyone please explain me how to carry out Phone Masking in Optim???

                          Thanks in advance...
                          • SystemAdmin
                            SystemAdmin
                            304 Posts
                            ACCEPTED ANSWER

                            Re: IBM OPTIM - Masking Techniques

                            ‏2012-09-17T12:09:35Z  in response to SystemAdmin
                            Hi,

                            It depends on what type of output you are looking for.
                            • SystemAdmin
                              SystemAdmin
                              304 Posts
                              ACCEPTED ANSWER

                              Re: IBM OPTIM - Masking Techniques

                              ‏2012-09-17T12:22:55Z  in response to SystemAdmin
                              Masking format can be of 999-999-9999 or (999)-999-9999 kind of .
                              This formating is not an explicit requirement.
                              We want to mask telephone number ,format can be of any.
                              • SystemAdmin
                                SystemAdmin
                                304 Posts
                                ACCEPTED ANSWER

                                Re: IBM OPTIM - Masking Techniques

                                ‏2012-09-18T05:47:56Z  in response to SystemAdmin
                                ok, so we can say that format of masked phone number will be similar to the format of the original number but what about the validity.

                                1. Will you be doing any validations on the masked number?

                                2. Will this masked phone number be used in any for e.g. parsing the phone number to find the country code, or operator code etc.
                                As I said earlier TRANS COL will preserve the format of the phone number after masking but the masked number will become invalid for e.g. 999-999-9999 is not a valid phone number.

                                If we need valid masked phone numbers then we need to go for Optim Lookup.
                          • SystemAdmin
                            SystemAdmin
                            304 Posts
                            ACCEPTED ANSWER

                            Re: IBM OPTIM - Masking Techniques

                            ‏2012-09-17T12:21:32Z  in response to SystemAdmin
                            Hi,

                            Your use case for using the masked phone number drives the choice of masking algorithm.

                            For example what matters to you in the masked phone number

                            1. If the validity, format, structure etc. of the masked phone number matters to you (e.g. you want phone number to be masked into a different but a valid phone number) then you might want to go with Optim Lookup.

                            2. If validity is not that important but format/structure matters (e.g. if you are ok with masking a phone number from 1-111-2345630 to 4-435-9898912) then using TRANS COL will be sufficient.
                            I hope this helps, if you want a more detailed discussion then please provide your exact use case for masking and we can discuss more on this.

                            Thanks
                            Ritesh