Masking a contact number in the external Experience Portal database

About this task

Use this procedure to mask a specified contact number in all CDR records in the external Experience Portal database.

The MaskContactNumberExtDB script examines all CDR records in the external Experience Portal database and replaces all instances of the specified contact number with a new contact number. The script searches both the Originating Number field and the Destination Number field in each CDR record. For example, any reference to sip:4085551212 can be replaced with sip:408******* or just ****.

Note that only CDR records belonging to the specified Experience Portal system are updated.

Procedure

Log on to Linux on the Primary EPM server.
- If you are an Avaya Services representative, and use Avaya Enterprise Linux, or if the Avaya Service accounts are installed on this server, log on to the local Linux console as root.
- Otherwise, log on remotely as a non-root user, and then change the user to root by entering the su - root command.
Navigate to the Support/VP-Tools directory under the Experience Portal installation directory.
Enter the cd $AVAYA_HOME/Support/VP-Tools command.

$AVAYA_HOME is an environmental variable pointing to the name of the installation directory specified during the Experience Portal software installation. The default value is /opt/Avaya/ExperiencePortal.
Enter the bash MaskContactNumberExtDB “current contact number” “new contact number” “Ext_DB_URL” JDBC_Driver Ext_DB_Username EP_System_Name command.
Where,
- “current contact number” is the contact number to be replaced.
- “new contact number” is the replacement value for the contact number.
- “Ext_DB_URL” is the fully-qualified path to the external database.
- JDBC_Driver is the name of the Java class that implements the JDBC API to the external database.
- Ext_DB_Username is the user name for the external database.
- EP_System_Name is the name of an Experience Portal system.
Ensure to enclose any value that contains non-alphanumeric characters with quotation marks. For example, bash MaskContactNumberExtDB "sip:4085551212" "****" "jdbc:oracle:thin:@148.147.6.139:1521:ep" "oracle.jdbc.driver.OracleDriver" voiceportal scaaep134.

Note that the system may take some time to mask the data depending on the amount of data in the CDR database table.
Enter the external database password.
At the prompt, click Enter to continue.

If the script runs successfully, it returns a message stating how many records were updated. Otherwise, it returns a message stating the problem that it encountered.