Personalization users who have access to the Data Warehouse may use client tools, such as DBeaver, to access the warehouse directly.

For any software package, you must obtain the Data Warehouse connection information from the Personalization Customer Success team or Acquia Support.

The following information is supplied to connect the dedicated Data Warehouse database:

• DB Host
• Port number 433 or 5439
• DB Name, which is usually the account ID
• Username
• Password

Depending on your needs, either accept the default values for the other fields, or use the generated values based on what you entered as part of the process.

Connecting to the Data Warehouse