InterAction only supports the Microsoft SQL Server database platform.
For details about the specific versions and service packs that are supported, see the Version Compatibility Matrix and the System Resource Guidelines documents in the Documentation area of the InterAction Support Center web site.
Overview of the Relational Database Platform
The relational database platform is sometimes referred to as the database engine.
The relational database platform must be installed on a server. The minimum hardware and software requirements for this server depend on the platform. For recommendations, see the InterAction System Resource Guidelines document available in the Documentation area of the Support Center Web site.
Once the database platform is installed on the server, use the tools included with the platform to create a physical database on the server. This database initially is empty; use InterAction Administrator to initialize this database. Initializing the database for InterAction creates all the necessary tables, indexes, records, stored procedures, views, and triggers needed to support InterAction. An initialized database is referred to as an InterAction database.
Depending on the platform, you may also need to create and configure the transaction log. The transaction log records changes to the data and is used as part of your disaster recovery strategy.
Overview of the InterAction Database
The InterAction database is the set of tables, indexes, records, stored procedures, views, and triggers needed to run InterAction. InterAction Administrator is used to initialize, edit, and delete the InterAction database.
It is important to understand the distinction between the physical database, created using the database manager for your platform, and the InterAction database, initialized using InterAction Administrator. The physical database you create contains no InterAction tables, records, stored procedures, views, or triggers; it is initially empty.
“Creating” or “initializing” the InterAction database adds the tables, indexes, records, stored procedures, views and triggers needed by InterAction to the empty database, as shown in
The InterAction Database
Throughout this guide, InterAction database or just database refers to the initialized database. The term physical database refers to the database created with your database platform tools.