Installation Guide for Oracle Self-Service E-Billing > Configuring the Oracle Database >

Process of Implementing Transparent Data Encryption

Transparent Data Encryption encrypts the columns listed in two CSV files during the creation of the Oracle Self-Service E-Billing database.

By default, columns in the Oracle Self-Service E-Billing OLAP and OLTP databases already known to contain sensitive data are listed in the CSV files:

• tde_olap_columns.csv. Columns in the OLAP instance that contain sensitive data; 0 columns included by default.
• tde_oltp_columns.csv. Columns in the OLTP instance that contain sensitive data; 95 columns included by default.

You can identify additional columns that contain sensitive data and add them to these files.

To implement Transparent Data Encryption, perform the following tasks:

1. In the following CSV files, specify the additional data columns you want to encrypt, if any. These files can be found in the EDX_HOME/db/ebilling/oracle/encrypt directory (or the EDX_HOME\db\ebilling\oracle\encrypt directory on Windows), where EDX_HOME is the directory where you installed Oracle Self-Service E-Billing:
   • tde_olap_columns.csv
   • tde_oltp_columns.csv

     Add the additional columns using the following format:

     table_name1, column_name1

     table_name1, column_name2

     ...

     table_name2, column_name1

     table_name2, column_name2

     ...

     table_nameN, column_name1

     table_nameN, column_name2

     ...

2. Specify the Oracle Wallet Location using the steps in Specifying the Oracle Wallet Location.
3. Follow Step 1 through Step 9 in Creating the Oracle Self-Service E-Billing Database Using Ant to create the OLAP database instance. In the same procedure, follow Step 12 through Step 15 to create the OLTP database instance.
4. Follow the steps in Setting the Master Encryption Key to set the master encryption key.
5. Follow the steps in Opening the Encrypted Wallet to open the encrypted wallet.
6. Run the Ant script again. Select Option 1, Install the OLAP database. Select Option 4, Create OLAP tablespaces. Then select Option 5, Create an OLAP schema, and Option 6, Create OLAP database objects. Return to the Main Menu, and select Option 2, Install the OLTP database. Select Option 4, Install Application Database - Create tablespace and user, and Option 5, Create the OLTP database objects.
7. Complete Step 18 to encrypt the data.
8. Complete Step 19 through Step 23. It is critical to follow these steps to load the seed data and perform the ETL installation process.

This process is a step in Roadmap for Configuring the Oracle Self-Service E-Billing Database.