Connecting an external data warehouse#

Introduction#

In Adverity, a warehouse is used as an internal destination for your data before loading it to data sharing destinations. By default, Adverity stores data in Adverity Data Storage (ADS), a data warehouse managed by Adverity. Instead of storing your data in ADS, you can store it in your own external warehouse. This integration is particularly valuable if you:

  • Need to meet specific compliance, security, or data sovereignty requirements

  • Have invested in a cloud data infrastructure

  • Want to eliminate data duplication and reduce infrastructure costs

  • Require data to remain within your organization’s cloud environment

When you connect your external warehouse to Adverity:

  • Collected data is written to your external warehouse instead of ADS when loading to storage is enabled for the datastream.

  • You can send this data to data sharing destinations, for example, Power BI and Tableau, directly from your warehouse.

Supported warehouse providers#

Adverity supports integration with the following external warehouse providers:

Choose the guide that matches your warehouse provider to get started with the connection process.

Requesting additional warehouse support#

If you need support for a warehouse provider that is not currently available, you can request it through Adverity:

  1. From the Warehouse tab of the Administration page, click Request a warehouse.

  2. Fill in the contact form with the following information:

    • Your email address

    • Which warehouse provider you would like to request (e.g., Databricks, Azure Synapse, etc.)

    • Whether you are currently using this warehouse provider to store data

    • If yes, what platform you are using to host your warehouse

This feedback helps us understand user needs and prioritize support for new warehouse platforms.