Staging Table Creation

This creates staging tables for the SIS installation in the database of your choice, creating an independent tablespace.
This task explains how to create the staging tables:
  1. Edit the installEISTables.sh/bat located under <CES Install>SIS/dbscripts to set these variables:

  • ORACLE_HOME=to your Oracle installation path.
  • EIS_HOME=to your SIS folder.
  • ORA_USER= oracle user with DBA privilege.
  • ORA_PASSWORD=oracle user passwd.
  • TNS_NAME=TNS name of oracle DB to create staging table
  1. Run the script.

  2. Specify the explicit path to create the tablespace file (/data1/db1/SIS.dbf) for data file location.

  3. Type a value corresponding to the size of data being used for integration use cases (for example, 300M) for data file size.

  4. Edit SIS/bin/oracleEnv.sh script to set the ORACLE_HOME variable to your oracle installation for UNIX. This enables asynchronous operations.

  5. Edit SIS/dbscripts/SISdbdriver.sh/bat to specify the EJS_HOMEvariable for the Explore java server location.
    For example, /data/CES613/exploreJS.

  6. Edit DB_LABELvariable to specify the CES database being used.  This label must match the entry within the dbload.cfg under EJS_HOME/admin/configs.

    Executing the script will then populate SIS seed data within the CES database.

  7. Edit the file SISdbdriver.bat and modify EJS_HOME and DBLABEL
    EJS_HOME=<intel_a\resources\sdm\exploreJS>
    DBLABEL=<
    db label given in dbload.cfg file>

  8. Restart the CES application server.

  9. Go to <CES Installation>/SIS/application/cis-src, and then run the launch.sh/bat script.  The Infrastructure Service Launcher page is displayed.
    Note: Make sure that your CIS agent is running and CIS_HOME is defined in your environment.

  10. Expand Scripts > Schemes in the navigation pad. The Infrastructure Service Launcher run page is displayed.

  11. Select the installSISAdapter.py script, and then click Run. The CIS Manager page running at http://localhost:8088 is displayed.

  12. Select Agent Manager > Adapters, and then click the Start icon to start the sis adapter.

  13. Click the Instance ID for the sis adapter to make sure that SIS CIS operations are available. The CIS Manager sis Adapter Configuration page is displayed.