Bulk sync (ELT) from HubSpot to PostgreSQL
Before getting started make sure to set your Polytomic API key as an environment variable:
This example tutorial will cover three steps:
- Connecting to HubSpot.
- Connecting to PostgreSQL.
- Loading data from HubSpot to PostgreSQL.
1. Create a HubSpot connection
The following request will create a Hubspot connection. The configuration for each type of connection can be found at the connection configuration docs page.
Since Hubspot connections uses OAuth to authenticate, we’ll need to follow the link returned in the auth_url
parameter in the response
Redirection
By default, the API expects the auth_url
to be open in a new browser window. If you’d like to modify the redirect behavior, there is an optional redirect_url
parameter that can be added to the request body.
2. Create a PostgreSQL connection
The PostgreSQL server must be network-accessible from Polytomic.
Bulk sync schemas
Polytomic may take a few moments to cache source schemas after creating new connections.
3. Create a bulk sync
This will create a bulk sync of all Hubspot objects into Postgres: