Data Export Overview

qTest Data Export is a set of APIs that asynchronously gives you access to your raw testing data from qTest once per day. You can use data in a variety of ways:

  • Import your qTest data into business intelligence tools, such as Microsoft PowerBI or Tableau.

  • Display your qTest data in your own custom dashboards and queries.

  • Link your qTest data to data from any of your external systems.

This allows you to make decisions about your testing process with clarity and accuracy.

What you need to do

We provide you with the basics you need to get started: your qTest data, API access, and data samples to help you set up your database. We'll also support you with any pipeline issues or data gaps you encounter.

Here's the tasks your team will need to complete to start using Data Export:

  1. Ask us to enable Data Export: This starts the onboarding process on our end.

  2. Set up the destination database: Create the environment where you're going to store the data we send you.

  3. Pull the initial historical data load: We send you an email when your historical data is available for download. You'll use the Data Export API to download the full historical snapshot.

  4. Implement daily delta sync: Build and schedule automation to download and apply the daily delta files to the database in the correct order.

Once your database and pipeline are set up, you're ready to connect to your preferred BI platform, such as Power BI or Tableau, so you can start building custom reports and dashboards.

Assemble your team

To use the Data Export API, you need a data engineer who can complete your setup to download and store the data.

Alternatively, you can assemble a few experts who can complete the necessary tasks to store and update your data.

Have a database administrator set up database tables where you can store the data you download from the API.

During the setup process, the database administrator uses our schema information, in addition to either our sample data or your historical data, to create an empty database.

Log into the Support Hub to download the sample data (opens in a new tab).

Have a data engineer automate your delta data downloads and updates.

Since the API sends delta data once per day, we recommend that you set up a program to automate your API calls and update your data.

You will not receive a notification when your data is about to expire. Each data upload is available for 90 days before it expires. If you miss a single data point in a table, it will corrupt your data. If this happens, contact our support, so we can help you replace your missing data points.

Appoint a BI developer who can import your updated data into your choice of business intelligence platform.

You can get as creative as you want with your solutions. For instance, import your transformed data into a business intelligence platform, such as Power BI or Tableau. Or, you may want to combine data from different tables, or even different programs, to create custom dashboards, views, or visualizations.

Is Data Export right for your use case?

Data Export continuously replicates your qTest data into a database or data lake that you manage, so you can use it for ongoing BI and reporting. This tool is meant for active and continuing qTest subscriptions that have a provisioned location to receive the data.

Data Export isn't designed for:

  • Offboarding from qTest or migrating to another platform.

  • A one-time backup or archive of your qTest data.

  • Downloading specific records for ad-hoc use.

For these scenarios, you can use Data Query to export directly from the qTest UI for individual modules, or use the qTest REST API to perform bulk retrieval, migration, or integration with external systems.

Is your environment supported?

Data Export supports the following environment types:

  • qTest SaaS (Multi-tenant)

  • qTest SaaS (Single-tenant on private cloud)

Data Export does not support customer-hosted private AWS environments. As an alternative, you can use the qTest REST API to perform certain functions.

What's next

Before you can access your data, you'll subscribe to Data Export and wait for your data to be onboarded.

While we onboard your data, you can use the sample data we provide to set up your database. Or, if you're already onboarded, you can also use the Data Export API.