---
title: "Connecting to a BI/Database System"
description: "You can establish a direct data connection to different BI/Database systems to pull in data into xP&A.\n\nThe following applies:\n\nIn 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.\nAll 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.\nFor some systems a connection using an SSH tunnel can be configured."
source_url: https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system
language: en
last_updated: 2023-08-16
---
# Connecting to a BI/Database System

## 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](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/defining-database-queries.md).
- For some systems a connection using an SSH tunnel can be configured.

## 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](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-bigquery.md)
- [Databricks](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-databricks.md)
- [Microsoft SQL Server](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-mssqlserver.md)
- [MySQL](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-mysql.md)
- [Postgres](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-Postgres.md)
- [Redshift](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-redshift.md)
- [Snowflake](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-snowflake.md)
- [Looker](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-looker.md)