Creating the Workflow Database for AgilePoint Server

Prerequisites

• These instructions apply to all installation scenarios.
• Determine the answers to the following questions:
  • What database technology will be used to host the AgilePoint BPMS database?

    AgilePoint supports MS SQL Server and Oracle as your workflow database technology options. We recommend you to use MS SQL Server as your workflow database due to the added integration functionality with SQL Reporting Services and AgilePoint Enterprise Manager for reporting.

  • What privilege level will be granted to the connection user?

    AgilePoint requires read/write access to run, but the MSI installer requires db_owner rights to create the initial database tables and constraints.

• For Oracle database installations, on the AgilePoint Server machine, download and install Oracle Database 11g Client that is appropriate for the system on which you are installing (32 bit or 64 bit). You will also need to install the Oracle Data Provider for ADO.NET 2.111.6.0.

Navigation

1. Make sure your SQL Server is up and running.
2. Open the SQL Server Management Studio via Start > Programs > Microsoft SQL Server [Version] > SQL Server Management Studio.

Instructions

1. In SQL Server Management Studio, Right-click on Databases and select New Database. The New Database window appears.
2. Enter a database name (for example, AP200 or APDB), and click OK.