The install file in the <ATG10dir>/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 Oracle ATG Web Commerce Adaptive Scenario Engine; you do not need to run the DAS, DPS, and DSS scripts separately. Note also that the install file uses the <ATG10dir>/Portal/install/minimal-data.xml
file to create the minimum set of data structures necessary to run Oracle ATG Web Commerce 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 Oracle ATG Web Commerce Portal are located in the following directories:
<ATG10dir>/Portal/paf/sql/install/
database-vendor
<ATG10dir>/Portal/
gear_dir
/sql/install/
database-vendor
Note: These scripts use an Oracle ATG Web Commerce-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 |