There are three main connection types in PowerTester: Source, Report and Key Vault connections. PowerTester requires at least one source and report connection before you can create a test case.
One a connection has been created its connection type cannot be updated.
Source
Source connections are connections used in test cases to determine the expected results. During a test run execution PowerTester will connect to the data source and execute the query provided, this provides the expected dataset result.
Supported data sources
PowerTester currently supports the following data sources:
Relational Databases
- Azure SQL Database
- SQL Server (on prem or VM hosted)
- Microsoft Fabric Warehouse (Public preview)
- Microsoft Fabric Lakehouse (Public preview)
- Postgres
- Snowflake (Private preview)
- Synapse dedicated & serverless pools (Private preview)
Storage Accounts (Private preview)
- Excel, Delta, Parquet & CSV Files on a cloud storage provider (e.g., Azure storage account)
Report
Report connections hold the information PowerTester requires to connect to your Power BI workspace and retrieve the actual dataset result. The report connection type connects to a specific Power BI or Microsoft Fabric (Public preview) workspace.
Key Vault
Key Vault connections are a special connection type used to retrieve secrets from your Azure Key Vault for authentication in other connections. This ensures none of your sensitive details are stored outside your environment, but rather retrieved and held in memory during a test run execution.
For more information on Azure Key Vaults view this Microsoft article