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

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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-04T07:00:43Z  
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-04T08:15:13Z  
    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
    Thanks for the response. It was very helpful. I will revert back if I need help again.
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-04T13:55:46Z  
    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
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-05T07:19:16Z  
    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 ?
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-05T14:08:16Z  
    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 ..
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-05T17:39:21Z  
    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.
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-13T05:23:01Z  
    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
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-13T07:32:46Z  
    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.
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-13T07:32:49Z  
    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.
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-13T10:53:40Z  
    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
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-13T11:29:31Z  
    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.
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-13T11:46:46Z  
    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
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-13T12:55:37Z  
    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.
    please un check ref check box on AD and then try it ,will work

    Thanks
    Rajesh
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-17T06:16:38Z  
    please un check ref check box on AD and then try it ,will work

    Thanks
    Rajesh
    Thanks a lot for your support.

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

    Thanks..
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-17T12:00:15Z  
    please un check ref check box on AD and then try it ,will work

    Thanks
    Rajesh
    Hi

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

    Thanks in advance...
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-17T12:09:35Z  
    Hi

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

    Thanks in advance...
    Hi,

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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-17T12:21:32Z  
    Hi

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

    Thanks in advance...
    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
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-17T12:22:55Z  
    Hi,

    It depends on what type of output you are looking for.
    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

    Re: IBM OPTIM - Masking Techniques

    ‏2012-09-18T05:47:56Z  
    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.
    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.