Test Data Manager

Hi,

 I created a Custom Masking Function using the IMaskFunction interface, as described in Create Custom Masking Functions.

My function receives 2 parameters as input. I tested it several times with literal values and it works just fine.

A customer asked me whether it was possible to have these 2 parameters coming from columns from the database. Of course I did not implement anything in my code to handle the column names, but I tried anyway and it failed as expected.

I know that the standard CONCAT function can receive literal values as well as column names. 

Is there anything in the interface implementation that allow us to parse the information from the other columns without the need to code a SQL query?

If implement a SQL query is the only way, is there a way to capture the active connection information to use, instead of requesting this as an input parameter?

Do you know how it is implemented in the CONCAT function?

Best regards,

.

Hi Aldo, there is no ability to pass other column values in custom masking functions at this time.   Please open an Enhancement Request using a Support Ticket.

Scott

Hi,

 I created a Custom Masking Function using the IMaskFunction interface, as described in Create Custom Masking Functions.

My function receives 2 parameters as input. I tested it several times with literal values and it works just fine.

A customer asked me whether it was possible to have these 2 parameters coming from columns from the database. Of course I did not implement anything in my code to handle the column names, but I tried anyway and it failed as expected.

I know that the standard CONCAT function can receive literal values as well as column names. 

Is there anything in the interface implementation that allow us to parse the information from the other columns without the need to code a SQL query?

If implement a SQL query is the only way, is there a way to capture the active connection information to use, instead of requesting this as an input parameter?

Do you know how it is implemented in the CONCAT function?

Best regards,

.

Hi Scott,

How are you?

I am working with IntelliJ and it opens the .jar files we use as reference. I can see that inside the com.grid_tools.products.datamasker package there are much more than just the IMaskFunction interface. In the class Datamasker, there are the public classes getOrigVal and getMaskedVal. 

Do you think these can be used?

Regards,

Aldo

Hi Aldo, there is no ability to pass other column values in custom masking functions at this time.   Please open an Enhancement Request using a Support Ticket.

Scott

Hi,

 I created a Custom Masking Function using the IMaskFunction interface, as described in Create Custom Masking Functions.

My function receives 2 parameters as input. I tested it several times with literal values and it works just fine.

A customer asked me whether it was possible to have these 2 parameters coming from columns from the database. Of course I did not implement anything in my code to handle the column names, but I tried anyway and it failed as expected.

I know that the standard CONCAT function can receive literal values as well as column names. 

Is there anything in the interface implementation that allow us to parse the information from the other columns without the need to code a SQL query?

If implement a SQL query is the only way, is there a way to capture the active connection information to use, instead of requesting this as an input parameter?

Do you know how it is implemented in the CONCAT function?

Best regards,

.

Hi Aldo, there is no ability to pass other column values in custom masking functions at this time.   Please open an Enhancement Request using a Support Ticket.

Scott

Original Message:
Sent: 12-23-2020 11:57 AM
From: Aldo Munhoz
Subject: Custom Masking Functions - column names as parameters

Hi,

 I created a Custom Masking Function using the IMaskFunction interface, as described in Create Custom Masking Functions.

My function receives 2 parameters as input. I tested it several times with literal values and it works just fine.

A customer asked me whether it was possible to have these 2 parameters coming from columns from the database. Of course I did not implement anything in my code to handle the column names, but I tried anyway and it failed as expected.

I know that the standard CONCAT function can receive literal values as well as column names. 

Is there anything in the interface implementation that allow us to parse the information from the other columns without the need to code a SQL query?

If implement a SQL query is the only way, is there a way to capture the active connection information to use, instead of requesting this as an input parameter?

Do you know how it is implemented in the CONCAT function?

Best regards,

.