Connection information

Overview

The connection information page provides you with information about the data warehouse integrated in AP. This information is useful when connecting desktop applications, like Power BI, Tableau and other BI tools, or cloud services, like AWS and Azure.

When connecting directly to the AP data warehouse, it is typically required to open a port in the firewall. Make sure to follow best security practices when allowing direct connections.

If your AP user account has permission for accessing the data warehouse, this means that a corresponding user account exists in the data warehouse. You can authenticate to the data warehouse using the same password as you use for logging in to AP.

Information

The connection information page offers the following information.

Field	Description
Provider	Data warehouse management system
Hostname	Hostname of data warehouse
Port	Port of data warehouse
Database	Database name
Username	Database username
Password	Use the AP user account password