Your ATG platform installation includes a preconfigured SOLID SQL database that contains the data necessary for running the ATG demo applications. The SOLID database is intended for evaluation and development purposes only. Before deploying your application in a production environment, you should 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, see the Supported Environments page on the ATG web site (http://www.atg.com/en/products/requirements/).
The ATG 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: Changing ATG’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 ATG.
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.
