Connecting to a BI/Database System
Last updated on 2025-11-07
Overview
You can establish a direct data connection to different BI/Database systems to pull in data into xP&A.
The following applies:
- In order to set up the integration, you must follow individual authentication procedures to link to your system account with xP&A. Detailed set-up instructions are provided for each supported system.
- All fields (variables and dimensions) that are pulled in need to be defined individually for each BI/Database system using custom queries. For instructions on how to define such queries, see Defining Database Queries.
- For some systems a connection using an SSH tunnel can be configured.
This article contains the following sections:
Supported BI/Data Warehouse Systems
Currently, xP&A supports connections to the following BI/Data Warehouse systems. Click on a system name to open the individual set-up instructions:
- BigQuery
- Databricks
- Microsoft SQL Server*
- MySQL*
- Postgres*
- Redshift*
- Snowflake
- Looker
* Detailed instructions for connecting to these system will be provided shortly.
Please consult the documentation of the former product Causal for the time being.