New data warehouse connector

Hey there,

We are excited to announce the release of a new connector: a Postgres Data Warehouse connector.

This new connector allows you send all of your user and account profiles, as well as events in Hull to your data warehouse. This will allow you to unlock immeasurable clarity from your Hull data.

This choice to work on this connector essentially stems from the need for our customers to run accurate reports based on the data gathered inside Hull. Indeed, to design your personas, visualize your customers journeys, run attribution reports and to make many other reportings, you often have to use a BI tool (Tableau, Periscope, Chartio, etc.) on top of your data warehouse. But you can only achieve that if you have enough data inside your data warehouse. Thanks to the release of this new connector, Hull allows you to do that by sending all the data you captured from various tools (product data, firmographic data, offline data, etc.) inside your data warehouse.

Once the Data Warehouse Connector has been installed, authorize it by entering your data warehouse credentials:

  • Database connection information Screenshot_2019-07-15_at_15.49.22.png
  • Database login information Screenshot_2019-07-15_at_15.49.34.png Your Hull data will be sent in three different tables: one for users, one for accounts and one for events. Thus, the second step is to fill-in the names of these tables as they are going to appear inside your data warehouse. Screenshot_2019-07-15_at_15.50.05.png Last, we allow to filter the users and accounts that you want to send to your data warehouse. You can either choose to send all the segments or select the segments users need to belong for their data to be sent.