Before you can begin building your Web application, you need to install and configure a production-ready database. Follow these steps to set up your database:

Step

Description

Procedure

1

Set up the ATG Content Administration server.

Follow the steps provided in the Setting Up an ATG Content Administration Server chapter of the ATG Content Administration Programming Guide.

2

Start your database according to the instructions provided by your database vendor.

See the documentation included with your database.

3

Create tables for ATG Content Administration by running the biz_ui_all_ddl.sql script located in the <ATG9dir>/BIZUI/sql/install/
database-vendor directory.

See the Creating ATG Content Administration Database Tables section of the ATG Content Administration Programming Guide.

4

If you have ATG Search, create tables that support the Search Integration by running the search_ddl.sql script located in the <ATG9dir>/DAF/Search/Index/sql/
db_components/
database-vendor directory.

See the Creating ATG Search Database Tables section of the Getting Started chapter in the ATG Commerce Search Guide.

5

Create the tables that support ATG Merchandising.

See Creating Versioned Core Commerce Tables.

ATG Consumer Commerce users who plan to use custom catalogs or users who plan to run the custom catalogs module on its own should also see Creating Versioned Custom Catalogs Tables.

ATG Business Commerce users should also see Creating Versioned Business Commerce Tables.

6

If you have ATG Search and you want to use the Search Merchandising and Faceted Search add-on features, create the database tables necessary to support these features.

See Creating Versioned Search Tables.

If you use ATG Business Commerce or ATG Consumer Commerce with custom catalogs, also see Creating Versioned Custom Catalog Tables with Search Support.

7

Import the data required by ATG Content Administration, if you have not already done so.

See the Initialize the Database section of the Setting Up the ATG Content Administration Database chapter in the ATG Content Administration Programming Guide.

8

Import ATG Merchandising content into your ATG Content Administration database. If you have ATG Search, run an additional import script.

See Importing Required Content.

9

Create tables for other ATG applications you want to use.

See the documentation provided with those applications.

 
loading table of contents...