External SQL database templates
There is an archiving folder under the root and site level. This folder contains the SQL template scripts for table creation and insertion.
These templates are compatible with Oracle 11. Other external databases may require different data types.
The scripts that are described here are installed at the root level. To customize the table creation or data insert, copy these templates to the site level to customize for a site. You can also copy them to the master site level to customize for a group of sites.
- If the template file is not found in $HCISITEDIR/archiving, then it searches the master site.
- If it is not found there, then it searches $HCIROOT/archiving.
- If the template file is not found in any of these locations, then an error is thrown and the archiving does not complete.