Before deploying your application in a production environment, configure both your application server and ATG products to use a production-quality database management system such as Oracle or Microsoft SQL Server. Your applications can then access application server resources and ATG components simultaneously. For a list of supported databases, refer to the Oracle ATG Commerce Supported Environments Matrix document in the My Oracle Support knowledge base (https://support.oracle.com/).

The Oracle ATG Web Commerce platform includes a number of tools for creating a database, adding and removing tables, configuring data sources and connection pools, and importing and exporting data. This chapter covers the following topics:

Note: The Configuration and Installation Manager (CIM) utility will create database schemas and data sources for you. It will also import any required data. See Configuration and Installation Manager (CIM).

Note: Changing Oracle ATG Web Commerce’s out-of-the-box database schemas is not recommended, although you can extend the schemas as necessary. If you do make any schema changes, you must migrate the changes manually when you upgrade to a new version of Oracle ATG Web Commerce.

Note: JBoss comes with its own demo database, Hypersonic (note the datasource hsqldb-ds.xml in the /deploy directory). Some JBoss components require that database, so do not remove it unless you also plan to remove those components.