Managing imports

Import data regularly to make sure reports include current product data. You should import data during periods of low activity, such as overnight, to avoid impacting application performance.

You can view a summary of import information, schedule imports, perform manual imports, and manage databases you are importing from on the Import Schedule page. This page is displayed when you log in to ALM Data Warehouse if you have permission to administer all license server functions in the Helix ALM License Server Admin Utility.

1. Click Configure and choose Imports.

The Import Schedule page opens.

The following information is displayed for all product servers that the license server can detect:

  • Status icon—Indicates an issue connecting to the product server it is displayed next to. Mouse over the icon for details.
  • Project/Mainline/Default database/Database—Helix ALM project, Helix ALM License Server database, or Surround SCM mainline branch data is imported from.
  • Last Import—Icon that indicates the success or failure of the last import, and the date and time of the last import or a status message. Click the link to view the log for the current or last import.
  • Last Duration—Duration of the last import.
  • Next Import—Next import date and time if automatic imports are scheduled.

Tip:  To sort data by a specific value, click a column heading. Click the heading again to switch the sort order.

2. Click Import now to immediately import data from a specific product database or click Import all now to immediately import data from all databases for a product server. See Manually importing data.

The Import now link is not available if an import is in progress. The page refreshes automatically when an import is complete.

3. Click Schedule imports to choose the databases to import from for the product and set the import schedule. See Scheduling imports

4. Click Manage databases to display information about the databases for the product that the data warehouse imports data from, view database status information, and enable imports from SQLite databases used for the product. See Managing databases.

5. Click View Log to view the reporting database log, which is helpful for troubleshooting issues. See Viewing the log.