Forum Discussion

dgrace's avatar
dgrace
New Member
2 months ago

Zephyr Data Model - Databricks/PowerBI

I hope to import our Zephyr Data into Databricks (via the API) and produce BI dashboards in PowerBI. I want to produce BI dashboards around test coverage per release, test execution progress, traceability etc etc. Has anyone accomplished something like this and is there a data model available or do we need to build it from scratch ourselves in Databricks? 

Zephyr Scale (general)

1 Reply

  • christovskia's avatar
    christovskia
    Icon for Staff rankStaff
    23 hours ago

     

    To import Zephyr data into Databricks via the API and create BI dashboards in Power BI for test coverage, execution progress, and traceability, here’s what you need to know:

    1. Data Model: 

    Zephyr does not provide a prebuilt data model for Databricks or Power BI. You will need to build a custom data model from scratch based on the data you extract.

    2. Data Extraction:

    • Use the Zephyr REST API to extract the required data. Key endpoints include `GET /testexecutions` for retrieving execution results, test case coverage, and Jira issue coverage.
    • The API supports fetching test cases, test cycles, test executions, and execution results.

    3. Power BI Integration:

    • Zephyr documentation supports using the Tempo Power BI Connector for Jira to expose Zephyr test management data in Power BI.
    • Load Zephyr-related tables (test cases, test cycles, test executions, execution results) into Power BI.
    • Define relationships between Zephyr tables and Jira work item tables to build dashboards.


    4. Databricks:
      
    While the documentation does not explicitly mention Databricks, you can transform the API data into a structure suitable for Databricks and then use it as a data source for Power BI.

    5. Dashboard Creation:

    • Build dashboards in Power BI by creating measures such as pass rate, execution count, and coverage.
    • Visualise test coverage, execution progress, and traceability using the loaded data.

     

    Sources

    • Using Power BI with Zephyr (https://support.smartbear.com/zephyr/docs/en/reports-and-analysis/using-power-bi.html)
    • Zephyr REST API Documentation (https://support.smartbear.com/zephyr-dc/docs/en/test-cases/import-test-cases/via-rest-api.html)
    • Zephyr Migration Scripts (https://support.smartbear.com/zephyr-dc/docs/en/test-automation/migration-scripts.html)