Create Oracle Accounts for the Oracle DMW InForm Connector

The InForm Connector is a component of Oracle DMW. It is required to import study data and metadata from InForm. On each InForm study database, run scripts to create a read-only user account for Oracle DMW to use to access data and metadata in InForm.

The account has Select privileges on all tables and views in study accounts referenced by the InForm Connector, including metadata views, operational data views, and RDE views. This schema also has packages that facilitate the data load process.

Use the credentials of this account when you set up a database connection (remote location) in the Oracle DMW InForm configuration for each study using the InForm database. See the Oracle Health Sciences Data Management Workbench Administration Guide.

• Create Directory on Each InForm Database
  
• Copy Scripts
  
• Run the Driver Script
  

Create Directory on Each InForm Database

On each InForm database with a study that you plan to use in Oracle DMW, create one OS directory using the mkdir command to hold the scripts that you must copy and run.

You need one directory per database. (You do not need one directory per study.)

Copy Scripts

Copy the following files from the directory $CDR_TOP/patch/115/sql/ on the computer where you installed Oracle Life Sciences Data Hub to each InForm database directory you created in Create Directory on Each InForm Database:

• DMWInFormInstall.sql—the driver script
• DMWInFormUser.sql—creates new users or confirms existing users
• DMWInFAdms.pls—installs a package specification into the Oracle DMW administration account
• DMWInFAdmb.pls—installs a package body into the Oracle DMW administration account
• DMWInFormROAccessObjs.sql—installs a table into the Oracle DMW read-only access account
• DMWInFroas.pls—installs a package specification into the Oracle DMW read-only access account
• DMWInFroab.pls—installs a package body into the Oracle DMW read-only access account

Run the Driver Script

The driver prompts for all required input parameter values and calls the other scripts as required.

1. Log into SQL*Plus with an account with DBA privileges.
2. Go to the directory that contains the downloaded scripts.
3. Execute DMWInFormInstall.sql. The script prompts for:
   • A name to give the log file.
   • TNS name or connect string for the InForm database. If you enter the connect string, do not enter any spaces.
   • system or other DBA username and password.
   • Name of the Oracle DMW Admin account to be used or created for the purpose of giving privileges to the Oracle DMW read-only access account. The system creates the account if it does not already exist.
   • Name of the Oracle DMW read-only access account to be used or created. The system creates the account if it does not already exist.

     Note:

     Do not use spaces or special characters other than underscore (_) in the username or password.
   • Passwords for both accounts. If the accounts are new, the script prompts you to confirm each password. If the accounts already exist, you must enter a password, but the system does not change the existing password. It proceeds to create or update the packages owned by the schema.
   • If the read-only access account is new, the script also prompts for a tablespace name. It then creates a tablespace on the InForm database to be used for the integration with Oracle DMW and creates or updates all Oracle DMW objects in this tablespace.