Configuring the ALM Data Warehouse database location

Before you can import data from Helix ALM products, you need to configure the ALM Data Warehouse database location. 

1. Click Configure and choose Database.

The Configure Database page opens.

2. Select the RDBMS type for the ALM Data Warehouse database.

3. Enter the Service name (Oracle) or Database name (PostgreSQL or SQL Server).

4. Enter the Host name and Port for the RDBMS server. The default ports are:

  • Oracle—1521
  • PostgreSQL—5432
  • SQL Server—1433

Note:  If you are using a SQL Server database in a named instance, enter the port number for the instance.

5. Enter the database Username and Password.

6. Click Test.

A connection results message is displayed. If the connection fails, errors from the RDBMS are displayed.

7. Click Save and Close.

The connection is saved.