Importing data from SQLite databases

Note:  If you are using Helix ALM 2020.3 or later, ALM Data Warehouse cannot import data from Helix ALM SQLite project databases if the Helix ALM Server database is stored in an RDBMS database. See the Perforce knowledgebase for more information.

Before you can import product data from SQLite databases, you need to enable imports for the product server and configure a connection to the SQLite Importer. If multiple product servers are running on the computer, data from all the databases will be available for import in ALM Data Warehouse. For example, if the Helix ALM License Server and Helix ALM Server databases are on the same computer, you can configure the SQLite Importer for the license server in the data warehouse and data will be available to import from the license server, the Helix ALM Server, and any Helix ALM projects hosted on the computer.

The SQLite Importer automatically looks for new or changed SQLite databases every five minutes.

Note:  The SQLite Importer must be installed and running on the Helix ALM product server computer to import data from. See Running the installer and Starting the Helix ALM SQLite Importer.

1. Click Configure and choose Imports.

The Import Schedule page opens.

2. Click Manage databases for the product server to import data from.

The product databases page opens.

3. Select Use SQLite Importer.

4. Clear this option if you no longer want to import from SQLite databases on the product server.

5. Enter the SQLite Importer port. The default port is 8191.

6. Enter the SQLite Importer password.

The password is initially set when you install the SQLite Importer. To change the password, click Change password. See Changing the SQLite Importer password.

7. Click Test to test the connection.

A results message is displayed. If the connection fails, make sure the SQLite Importer is running on the computer that hosts the product database, the importer port number is correct, and the importer password is correct.

8. Click Save and Close.