Dynamic Data Masking Accelerator Guide for use with SAP

Back Next

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

Connect to the database with the Dynamic Data Masking database user you created to use the accelerator.

Navigate to the following directory:

<Dynamic Data Masking installation>\Accelerators\SAP\sql\Oracle

Open DDM_SAP_MATCHERS_TBL.sql and replace

with the Dynamic Data Masking user you created to use the accelerator.

Save DDM_SAP_MATCHERS_TBL.sql and close the file.

Create the DDM_SAP_MATCHERS_TBL table with the following script:

DDM_SAP_MATCHERS_TBL.sql

Compile the SAP matchers package spec with the following script:

DDM_SAP_MATCHERS_spec.sql

Compile the SAP matchers package body with the following script:

DDM_SAP_MATCHERS_body.sql

Grant execute privileges to all users with the following database command:

GRANT EXECUTE ON DDM_SAP_MATCHERS TO PUBLIC

Create a public synonym for the SAP matchers package with the following database command:

CREATE PUBLIC SYNONYM DDM_SAP_MATCHERS FOR DDM_SAP_MATCHERS

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

Verify that you entered the correct base URL with the following select statement:

Select DDM_SAP_MATCHERS.GET_BASE_URL From Dual

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.