No-code pipeline · Hotmart → Redshift

Send data from Hotmart to Redshift

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

From Hotmart to Redshift: managed, scheduled, no code.

Creating a pipeline that sends data from Hotmart to Redshift data warehouses takes only a few minutes with Kondado. And the whole integration from Hotmart to Redshift is managed and executed by our platform. With Kondado, you can focus on extracting value from Hotmart data and combining it with other data in your Redshift data warehouse

Connect Hotmart now →

Send Hotmart Data to Redshift Automatically

To send Hotmart data to Redshift, start by connecting your Hotmart account as a data source in Kondado, then configure your Redshift cluster as the destination. Select from 11 available pipelines including Subscribers, Sales Commissions, and Hotmart Club data to replicate exactly the information your analytics require. Kondado handles the data extraction and loading automatically on your chosen schedule, whether you need updates every 5 minutes or daily batches. This automated workflow eliminates manual CSV exports and ensures your Redshift warehouse always contains current information for comprehensive business analysis.

Kondado provides a direct integration between Hotmart and Redshift, replicating 11 data pipelines with 202 total fields on a configurable schedule ranging from 5 minutes to daily intervals. The no-code platform maintains your data continuously updated, enabling you to build custom dashboards in Power BI, Looker Studio, or analyze directly within Redshift using SQL.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Available Hotmart Pipelines for Redshift

Once your data arrives in Redshift, you can combine Hotmart Subscribers data with Sales Commissions pipelines to calculate lifetime value and churn rates across your digital products. The Hotmart Club: Student Progress pipeline enables detailed cohort analysis of course completion rates, while Subscription Transactions data allows you to build recurring revenue forecasts using Redshift’s advanced SQL capabilities. These consolidated datasets support sophisticated analytics workflows, from segmenting high-value customers to optimizing pricing strategies based on historical purchase patterns. Connect Redshift to Power BI or Looker Studio to visualize these insights in executive reports.

Try out all the features for free for 14 days

Replicated to Redshift

Hotmart data available for Redshift

Tables Kondado writes into your Redshift, on a schedule you control.

available pipelines

202

extractable fields

Redshift

Destination

Available integrations

Subscribers

Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.

Sales Commissions

Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.

Subscriber Purchases

Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.

Sales Price Breakdown

Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.

Sales History

Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.

Hotmart Club: Students

Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.

Hotmart Club: Modules

Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.

Hotmart Club: Student Progress

Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.

Hotmart Club: Pages

Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.

Products

Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.

Subscription Transactions

Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

See all available data → Send Hotmart to Redshift →

Try out all the features for free for 14 days

How to send Hotmart data to Redshift

Sync data automatically — no code, no manual exports.

Connect Your Hotmart Account

Authenticate your Hotmart data source by entering your API credentials in Kondado's interface to establish the initial connection.

Configure Redshift Cluster

Enter your Redshift host, database name, and access credentials to set up your destination warehouse. Kondado validates the connection to ensure data can flow properly into your PostgreSQL-compatible environment.

Select Pipelines and Schedule

Choose from 11 available pipelines including Subscribers and Sales Commissions, then set your preferred update frequency ranging from 5 minutes to daily. Activate the configuration to begin automated replication.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from Hotmart to other destinations

Hotmart > Looker Studio

Hotmart > Power BI

Other visualizations

Hotmart > Amazon S3

Hotmart > BigQuery

Hotmart > Excel

Hotmart > Google Sheets

Hotmart > MySQL

Hotmart > PostgreSQL

Hotmart > Redshift

Hotmart > SQL Server

Choose a tool to visualize your Hotmart data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hotmart > Airtable

Hotmart > Alteryx

Hotmart > Amazon Quicksight

Hotmart > BIMachine

Hotmart > Cortex

Hotmart > Data Studio

Hotmart > Geckoboard

Hotmart > Grafana

Hotmart > IBM Cognos Analytics

Hotmart > Klipfolio

Hotmart > Looker Studio

Hotmart > Looker

Hotmart > Looqbox

Hotmart > Metabase

Hotmart > Microstrategy

Hotmart > Pentaho

Hotmart > Power BI

Hotmart > Qlik Cloud Analytics

Hotmart > Qlik Sense

Hotmart > Qlik

Hotmart > QlikView

Hotmart > Redash

Hotmart > Superset

Hotmart > Tableau

Hotmart > BI TOTVS

Hotmart > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending Hotmart data to Redshift automatically

How does Kondado replicate Hotmart data to Redshift? ▼

Kondado connects directly to your Hotmart account using your API credentials, extracts data from your selected pipelines, and loads it into your Redshift cluster. The process runs automatically on your configured schedule without requiring manual intervention or coding knowledge.

What specific Hotmart data can I replicate to Redshift? ▼

You can replicate 11 distinct pipelines including Subscribers, Sales Commissions, Subscription Transactions, Products, and four Hotmart Club datasets covering student progress and module completion. Each pipeline contains specific fields like subscriber codes, transaction values, and completion percentages for detailed analysis.

How frequently does Hotmart data update in Redshift? ▼

You can configure updates to run every 5 minutes, 15 minutes, hourly, or daily depending on your business requirements. This automated synchronization on a configurable schedule ensures your Redshift warehouse reflects current subscription statuses without manual exports.

What format does Hotmart data arrive in Redshift? ▼

Data arrives as structured tables within your Redshift schema, with each pipeline corresponding to a specific table containing normalized fields. The PostgreSQL-compatible format allows immediate querying using standard SQL, joining with existing business data, or connecting to visualization tools like Power BI and Looker Studio.

Can I combine Hotmart data with other marketing platforms in Redshift? ▼

Yes, you can replicate data from Hotmart alongside other platforms into the same Redshift warehouse. This enables cross-channel analysis, such as comparing Hotmart course sales against advertising spend data or website analytics stored in your data warehouse.

Do I need coding skills to set up Hotmart to Redshift replication? ▼

No coding is required to configure the connection. You simply authenticate your Hotmart account, provide your Redshift connection details, and select your desired pipelines through Kondado's interface. The platform handles all data transformation and schema management automatically.

Can I track individual student progress from Hotmart Club in Redshift? ▼

Yes, the Hotmart Club: Students, Modules, and Student Progress pipelines replicate detailed learning analytics including completion percentages, module access dates, and page engagement metrics. This data allows you to build retention models and identify at-risk students using Redshift analytics capabilities.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days