Note: This article only applies to Helix ALM (and TestTrack 2012 - 2016.1). If you use TestTrack 2011.1 or earlier, see Exporting Data to Excel Using the TestTrack ODBC Driver.
Helix ALM uses SQLite for native project databases. To export data to Microsoft Excel from Helix ALM native databases, you need to install a third-party SQLite ODBC driver, such as SQLite Pro Enterprise Manager.
Note: If you only want to work with data displayed in item list windows, it is easier to open items in Excel from Helix ALM and save the data in a new worksheet. In the Helix ALM Client, select the items in the list window to export from and choose Activities > Open in Excel. See the Helix ALM help for information.
Configuring the ODBC driver
- Choose Start > Settings > Control Panel.
- Open the ODBC Data Source Administrator.
- On the User DSN tab, click Add.
- Select the SQLite ODBC Driver and click Finish. You are prompted to enter the DSN configuration information.
- Enter the Data Source Name.
- Enter the full path to the project database you want to query in the Database Name field or click Browse to locate the database. The default project database location is the computer where the Helix ALM Server is installed.
- Click OK. The driver is configured.
- Click OK to close the ODBC Data Source Administrator.
Querying data in Excel
Note: The following steps were tested using Excel 2010. If you use a different version, refer to the Excel help for information about using database queries to import external data.
- Start Excel and open a new workbook.
- Click the Data tab.
- Click From Other Sources in the Get External Data area and select From Microsoft Query. The Choose Data Source dialog box opens.
- On the Databases tab, select the ODBC data source you created and click OK. The Excel Query Wizard opens.
- In the list of available tables and columns, select the columns you want to query.
- Click Next.
- Continue through the Query Wizard and set any options for filtering and ordering data.
- At the end of the wizard, select what to do next with the data.
- Select Return Data to Microsoft Excel to import data to the workbook.
- Select View data or edit query in Microsoft Query to perform more complex data queries.
- Click Finish.
- If you chose to return data, the data is imported to Excel.
- If you chose to edit the query, the Microsoft Query Editor opens. See the ‘Using Microsoft Query to retrieve data’ section in Exporting Data to Excel Using the TestTrack ODBC Driver for an example of more complex queries.