Managing databases

You can view information about each product database you import data from, including the connection status, database type, and type of data stored in the database. You can also enable importing from SQLite databases.

1. Click Configure and choose Imports.

The Import Schedule page opens.

2. Click Manage databases for the product server to work with.

The product database page opens. The following information is displayed depending on the product and database type:

• Status—Icon that indicates the connection status to the database from ALM Data Warehouse. Mouse over the icon for details.
• Type—Database type.
• Host Name—Computer that hosts the database. (SQL Server and Oracle databases only)
• Port—Port number the database listens on. (SQL Server and Oracle databases only)
• Local File—Location of the file that contains the data last imported from the product server. (SQLite databases only)
• Database Name—Name of the database on the product server.
• User—User to connect to the database on the product server.
• Storing—Type of data stored in the database. For example, Helix ALM has project and server databases.

3. Select Use SQLite Importer to import data from SQLite databases on the product server. See Importing data from SQLite databases.

Clear this option if you no longer want to import from SQLite databases.

4. Click Save and Close.