|
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)
|
Staff