Staging

The Staging tab deals with the configuration parameters for the staging database used in SIS. Staging database is a temporary location for the incoming data that needs to be processed asynchronously. The data that comes from the BackBus or Asynchronous events get staged in temporary tables, and is processed in batches as per the page size configured.

This table describes the Staging tab properties:

Property Name Description
Database TNS Name The TNS name of the database. This parameter is used by the sql loader tool for importing the data into Oracle Staging Tables. It should be a valid TNS name as configured in the tnsnames.ora file.
Database User Name The database user name to access the staging table. The default user name is cisdba.
Database User Password The database password for the database user. The default user password is cis2.
Data Source Name The data source JNDI name as defined in the Application server. This is a read-only setting.
End of Job Staging Clean up If Yes, deletes all the records from the staging table EIS_STAGINGTABLE at the end of successful processing of the Asynchronous job. The master record of the job still exists in the EIS_JOBTABLE table for the Admin to view its status. If set to No then all the data remains in the staging tables. The Admin can later use the cleanup scripts to clean the data.
Staging Directory The directory where the incoming data files are stored. These data files gets generated automatically by SIS. They remain in this directory if the End of Job Staging Cleanup parameter is set to No and until the Admin user cleans up the file by executing the cleanup scripts. If the End of the staging Cleanup parameter is set to Yes, then these data files gets removed automatically at the end of successful run of all asynchronous type jobs.
Joblog Location The location of the log files related to jobs. For each asynchronously processed job, SIS generates a job log file. For example, if the job number is 111 then you will find a job111.log file under this location. Same Cleanup rules as explained for the staging data files is applicable for the job log files.