The install file in the <ATG11dir>/Portal/install/
database-vendor
directory runs a set of scripts that create the required tables for the Portal Application Framework (PAF) and baseline gears.
Note: These scripts also create the tables for the Core Platform; you do not need to run the DAS, DPS, and DSS scripts separately. Note also that the install file uses the <ATG11dir>/Portal/install/minimal-data.xml
file to create the minimum set of data structures necessary to run ATG Portal.
Use the following syntax to run the install file appropriate for your DBMS:
install-db2
userid
password
database
install-mssql
userid
password
host
database
install-oracle
userid
password
database
Note: Entering passwords as command line arguments entails some security risks. Do not enter passwords as command line arguments in situations where security is a top priority.
The table creation scripts for ATG Portal are located in the following directories:
<ATG11dir>/Portal/paf/sql/install/
database-vendor
<ATG11dir>/Portal/
gear_dir
/sql/install/
database-vendor
Note: These scripts use an Oracle Commerce Platform-specific JTDatasource
and TransactionManager
, and cannot be used with your application server’s data source or transaction manager.
Script Name | Purpose |
---|---|
| Creates tables for the Alerts Gear |
| Creates tables for the Bookmarks Gear |
| Creates tables for the Calendar Gear |
| Creates tables for the Communities Gear |
| Creates tables for the Discussion Gear |
| Creates tables for the Document Exchange Gear |
| Creates tables for storing membership requests |
| Creates tables used by sample mappers to record portal events |
| Creates tables for the Portal Application Framework |
| Creates tables for the Poll Gear |
| Creates tables for storing profile data for personalized communities and pages |
| Creates tables for the Web Services Client Gear |