Dynamic Data Masking Accelerator Guide for use with SAP

Dynamic Data Masking Accelerator Guide for use with SAP

Compile the Database Objects

Compile the Database Objects

Use the SQL scripts in the SAP folder to compile the database objects.
You can find the SQL script files in the following directory:
<Dynamic Data Masking installation>\Accelerators\SAP\sql\Oracle
  1. Connect to the database with the Dynamic Data Masking database user you created to use the accelerator.
  2. Navigate to the following directory:
    <Dynamic Data Masking installation>\Accelerators\SAP\sql\Oracle
  3. Open DDM_SAP_MATCHERS_TBL.sql and replace
    <schema>
    with the Dynamic Data Masking user you created to use the accelerator.
  4. Save DDM_SAP_MATCHERS_TBL.sql and close the file.
  5. Create the DDM_SAP_MATCHERS_TBL table with the following script:
    DDM_SAP_MATCHERS_TBL.sql
  6. Compile the SAP matchers package spec with the following script:
    DDM_SAP_MATCHERS_spec.sql
  7. Compile the SAP matchers package body with the following script:
    DDM_SAP_MATCHERS_body.sql
  8. Grant execute privileges to all users with the following database command:
    GRANT EXECUTE ON DDM_SAP_MATCHERS TO PUBLIC
  9. Create a public synonym for the SAP matchers package with the following database command:
    CREATE PUBLIC SYNONYM DDM_SAP_MATCHERS FOR DDM_SAP_MATCHERS
  10. Call the DDM_SAP_MATCHERS.SET_BASE_URL function to set the base URL of the Apache Tomcat Web Server with the following command:
    Begin Ddm_Sap_Matchers.Set_Base_Url(<Base Web Server URL>) End;
    The base URL is in the following format:
    http://<Server IP/Name>:<Port>
    The following URL is an example of a base URL:
    http://localhost:8080
  11. Verify that you entered the correct base URL with the following select statement:
    Select DDM_SAP_MATCHERS.GET_BASE_URL From Dual
  12. Verify that the database objects are compiled with the following select statement:
    Select DDM_SAP_MATCHERS.user_match('abcd') from dual
    The returned value is zero.