Sun B2B Suite HIPAA Protocol Manager User's Guide

ProcedureTo Create HIPAA Tables

  1. In Enterprise Explorer, in the project tree, expand the following folders: Sun SeeBeyond ⇒ eXchange ⇒ Protocol Manager ⇒ HIPAA Manager ⇒ Download Database Scripts

  2. Right-click hipaa_oracle510.zip and, on the popup context menu, click Export; then use the Save dialog box to save the file to a local directory.

  3. Extract the files in hipaa_oracle510.zip into this local directory, yielding:

    • create_hipaa_tables.cmd

    • create_hipaa_tables.sql

    • setenv.cmd

  4. To edit the setenv.cmd, open a command prompt and change directories to the local directory where you saved the scripts .

  5. Use a text editor to edit the as-supplied version of setenv.cmd:


    @REM SET YOUR DATABASE CONNECTION INFORMATION HERE
    *
    echo * This file should be edited to use appropriate
    echo * database connection settings. *
    echo * SETENV.CMD
    @REM TNS_NAME
    @set TNS_NAME=< TNS NAME >
    @REM ORACLE_SID
    @set ORACLE_SID=< SID >
    @REM Oracle system login password
    @set SYSTEMPWD=< PWD >
    @set USERID=ex_admin
    @set USERPWD=ex_admin
  6. Supply the appropriate values forTNS_NAME,ORACLE_SID, and SYSTEMPWD. For example:


    @set TNS_NAME=eXchange_myOracleHostname
    @set ORACLE_SID=ORCL
    @set SYSTEMPWD=manager
    @set USERID=ex_admin
    @set USERPWD=ex_admin
  7. Open a command prompt and change directories to the local directory where you saved the .cmd scripts in the previous procedure.

  8. Enter the following command:


    create_hipaa_tables.cmd

    The script starts SQL*Plus, invokes an SQL script to create HIPAA tables.


    Note –

    Create and configure the eXchange database using the Oracle510.zip file. For complete information on how to perform this and other eXchange setup operations, see the eXchange Integrator User’s Guide. You need to create HIPAA specific database tables after the eXchange database is created.