How do I connect Hubspot to Pentaho using Kondado?

Start by adding Hubspot as a data source in your Kondado account and authenticate with your credentials. Then select Pentaho as your destination and choose which pipelines you want to replicate, such as Deals, Contacts, or Email Events. The connection requires no intermediate databases or technical setup, so you can begin visualizing data within minutes.

What specific Hubspot data can I visualize in Pentaho?

You can access 24 different pipelines including Companies, Contacts, Deals, Email Events, Tickets, and Marketing Emails with a total of 805 fields available. This covers your complete CRM data, marketing campaign performance, sales pipeline stages, and customer service interactions. Build custom reports showing conversion rates, deal progression, or customer engagement metrics tailored to your business needs.

How frequently does my Hubspot data update in Pentaho?

Kondado offers configurable refresh schedules ranging from every 5 minutes to daily updates, depending on your operational requirements. You control the frequency for each pipeline individually, ensuring your Pentaho dashboards reflect the most current information without manual exports. This keeps your marketing and sales reports accurate without overwhelming your systems with unnecessary updates.

Can I create sales pipeline reports in Pentaho with Hubspot data?

Yes, by replicating the Deals and Pipelines data into Pentaho, you can build comprehensive sales dashboards showing deal stages, values, and conversion rates. Combine this with Contacts and Companies data to analyze which customer segments generate the most revenue. Sales managers can track team performance and forecast revenue with visual charts that update automatically on your chosen schedule.

How do I share Hubspot dashboards with my marketing team in Pentaho?

Once you build your reports in Pentaho, use the platform's native sharing features to distribute dashboards to stakeholders across your organization. Since Kondado maintains the data connection on a configurable schedule, your team always sees current information without requesting manual data pulls. This ensures everyone from marketing coordinators to executives bases decisions on the same accurate Hubspot data.

What marketing KPIs can I track by visualizing Hubspot in Pentaho?

You can monitor email open rates, click-through rates, form submission volumes, and campaign ROI by analyzing the Email Events and Contacts pipelines. Track lead generation trends over time and measure conversion rates from initial contact to qualified opportunity. These insights help marketing teams optimize campaign spending and improve content strategies based on actual performance data.

Connect Hubspot to Pentaho: Dashboards in Minutes

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

Visualize Hubspot Data in Pentaho

Kondado makes it simple to visualize your Hubspot data in Pentaho without technical complexity or coding requirements. Our direct integration replicates your marketing, sales, and service information on a configurable schedule, keeping your reports current for better decision-making. You choose exactly how often your data updates: every 5 minutes, hourly, or daily, depending on your business needs and operational rhythm.

With Kondado, business users can access insights from CRM records, marketing campaigns, and customer interactions without waiting for IT support or managing complex infrastructure. This approach puts data-driven decision making directly in the hands of marketing teams, sales managers, and operations staff who need immediate access to performance metrics and customer behavior trends. Whether you track lead generation, monitor sales pipelines, or analyze customer service tickets, your data flows seamlessly into Pentaho for immediate visualization.

Kondado connects Hubspot to Pentaho through a direct integration that requires no intermediate databases or complex setup, allowing business teams to build custom reports with 24 available pipelines covering 805 fields including Companies, Deals, Contacts, and Email Events.

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

Combine your Hubspot data with Pentaho’s visualization capabilities to uncover actionable business insights across marketing, sales, and service operations. By analyzing pipelines such as Deals, Contacts, and Email Events together, you can track your complete customer journey from initial lead capture through final conversion and ongoing support interactions. Marketing teams can measure campaign effectiveness while sales managers monitor pipeline health and revenue forecasts in unified dashboards.

This combination enables you to identify trends in customer behavior, optimize your marketing spend, and improve sales forecasting accuracy based on historical deal data. Operations teams benefit from having centralized access to support Tickets and engagement data, ensuring no customer interaction goes unnoticed while making informed decisions about resource allocation and team priorities throughout the customer lifecycle.

Try out all the features for free for 14 days

Hubspot data available in Pentaho

available pipelines

805

extractable fields

Available integrations

Integration	Description
Companies	Includes information such as id, name, and properties related to contacts and deals.
Contact lists	Presents contact lists with details on membership and relevant properties.
Contacts	Brings contact information such as id, email, name, and created date.
Contacts: form submissions	Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership	Displays the association of contacts to specific lists and their properties.
Custom object	Represents custom objects with fields such as id and specific properties.
Deals	Contains information about deals, including id, value, and related contacts.
Email events	Records email events with details on sending, opens, and clicks.
Engagements: Calls	Includes call details such as id, dispositions, and related objects.
Engagements: Emails	Presents email details including id and related objects.
Engagements: Meetings	This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes	Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks	Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions	Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads	Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items	Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails	Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners	Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments	Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines	Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products	Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata	Table presents metadata of properties, including fields such as name, type, and description.
Property History	Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets	Table includes information about tickets, with fields such as id, status, priority, and created_at.

Companies

Includes information such as id, name, and properties related to contacts and deals.

Contact lists

Presents contact lists with details on membership and relevant properties.

Contacts

Brings contact information such as id, email, name, and created date.

Contacts: form submissions

Includes form submissions with fields such as conversion id, content type, and form id.

Contacts: lists membership

Displays the association of contacts to specific lists and their properties.

Custom object

Represents custom objects with fields such as id and specific properties.

Deals

Contains information about deals, including id, value, and related contacts.

Email events

Records email events with details on sending, opens, and clicks.

Engagements: Calls

Includes call details such as id, dispositions, and related objects.

Engagements: Emails

Presents email details including id and related objects.

Engagements: Meetings

This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.

Engagements: Notes

Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.

Engagements: Tasks

Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.

Feedback Submissions

Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.

Leads

Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.

Line Items

Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.

Marketing Emails

Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.

Owners

Owners table contains fields such as id, name, email, and created_at, essential for user management.

Payments

Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.

Pipelines

Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.

Products

Table contains information about products, including fields such as id, name, price, and description.

Properties Metadata

Table presents metadata of properties, including fields such as name, type, and description.

Property History

Table logs changes to properties, with fields such as id, created_at, and previous_value.

Tickets

Table includes information about tickets, with fields such as id, status, priority, and created_at.

See all available data →

Try out all the features for free for 14 days

Get started for free

Get started for free

Get started for free

Connect Hubspot to Pentaho: Dashboards in Minutes

Get started for free

Visualize Hubspot Data in Pentaho

Hubspot data available in Pentaho

Available integrations

How to create Hubspot dashboards in Pentaho

Connect Hubspot as data source

Select Pentaho as destination

Build dashboards and configure refresh

Access Hubspot data in Pentaho and combine it with dozens of other data sources

55pbx

ActiveCampaign

Google Ads

Amazon S3

api4com

Apple App Store

ASAAS

AWS CloudWatch Metrics

Azure Table Storage

BigQuery

Bing

Bitrix24 CRM

Bling!

Blip (take)

ClickUp

Clockify

ContaAzul

Criteo

E-goi

EADBOX

Exact Sales

Facebook Ads

Facebook

Fatura Simples

Freshdesk

FTP

Google Analytics GA4

Google Cloud Storage

Google Play Store

Google Search Console

Google Sheets

Granatum

Hi Platform

Hotmart

Hubspot

Huggy

InfluxDB v1

Infusionsoft (Keap)

Instagram Ads

Instagram

Jira

Linkedin

Loja Integrada

MailChimp

Mandrill

Mautic

Meetime

Mercado Libre

Meta Ads

Microsoft Ads

Microsoft Advertising

Mixpanel

monday.com

MongoDB

Movidesk

MySQL (& MariaDB)

NectarCRM

Notion

Nuvemshop (Tiendanube)

Olist Tiny

Omie

Oracle

Pagar.me

Pinterest Ads

Pipedrive

Pipefy

PipeRun