Connect PipeRun to Pentaho: Dashboards in Minutes

Get started for free

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

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

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

PipeRun
Pentaho

Visualize PipeRun Data in Pentaho

Want to turn your sales data into actionable insights? Kondado connects your PipeRun CRM directly to Pentaho, allowing you to create comprehensive visualizations without technical complexity. Simply select PipeRun as your data source and Pentaho as your destination, then choose which pipelines you need for analysis, and you will be ready to visualize your funnel metrics within minutes.

Kondado replicates your PipeRun opportunities and custom fields into Pentaho on a configurable schedule, enabling automated sales reports that update every 5 minutes, hourly, or daily based on your business needs.

With this direct connection, marketing and operations teams can track funnel performance, monitor deal progression, and identify revenue trends using fresh CRM data. No manual exports or complex setup required: just connect, configure, and start building dashboards that drive smarter sales decisions. Your team gains immediate visibility into sales activities without waiting for IT support or manual data preparation.

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

Combine your PipeRun sales records with Pentaho’s visualization capabilities to unlock deep insights into your revenue operations. By accessing the Opportunities pipeline, you can analyze deal values, track closure dates, and measure conversion rates across different sales stages. The Opportunities: Custom Fields pipeline lets you incorporate your unique CRM configurations into reports, ensuring your dashboards reflect the specific metrics that matter to your business process.

This combination helps sales managers identify bottlenecks in the funnel, forecast revenue more accurately, and understand which custom attributes drive successful deals. Whether you are tracking lead sources, deal sizes, or sales cycle duration, these pipelines provide the structured data needed for actionable Pentaho visualizations that improve team performance.

Try out all the features for free for 14 days

PipeRun data available in Pentaho

2
available pipelines
134
extractable fields

Available integrations

Integration Description
Opportunities Table provides information on opportunities, including fields such as id, status, value, and closed_at date.
Opportunities: Custom Fields Table contains custom fields for opportunities, such as deal_id, customfield_name, and value.
Opportunities
Table provides information on opportunities, including fields such as id, status, value, and closed_at date.
Opportunities: Custom Fields
Table contains custom fields for opportunities, such as deal_id, customfield_name, and value.

Try out all the features for free for 14 days

How to create PipeRun dashboards in Pentaho

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect PipeRun as data source

Authenticate your PipeRun account in Kondado to establish the initial data source connection. Select the specific pipelines you need, such as Opportunities and Opportunities: Custom Fields, to determine which sales records will be available for visualization.

2
Select Pentaho as your destination

Choose Pentaho from Kondado's destination options to establish where your PipeRun data will be delivered. This creates a direct Via Kondado pathway that streams your selected CRM information into Pentaho without intermediate storage requirements.

3
Build dashboards and set refresh schedule

Create your sales visualizations in Pentaho using the replicated opportunity data, then configure your preferred update frequency, choosing from intervals like every 5 minutes, hourly, or daily. This ensures your reports stay current automatically while you focus on analyzing funnel performance and conversion trends.

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

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize PipeRun data in other BI tools

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

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing PipeRun data in Pentaho automatically

How do I set up the connection between PipeRun and Pentaho?
Start by selecting PipeRun as your data source in Kondado and choose Pentaho as your destination. You will authenticate your PipeRun account and select the specific pipelines you want to replicate, such as Opportunities and Opportunities: Custom Fields. Kondado establishes a direct Via Kondado connection, so your data flows straight into Pentaho without requiring intermediate databases or complex technical configuration.
What sales KPIs should I track in Pentaho using PipeRun data?
You can monitor conversion rates by comparing open versus closed opportunities, analyze deal velocity using the closed_at dates, and track total pipeline value across different stages. The Opportunities: Custom Fields pipeline allows you to segment reports by specific attributes like lead source or deal size, giving you tailored insights into which factors drive your sales success.
How frequently does PipeRun data refresh in my Pentaho dashboards?
Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This automated refresh ensures your sales reports always reflect the latest opportunity statuses and values without manual intervention, keeping your team aligned with current performance metrics.
Can I share PipeRun dashboards with team members who do not have Kondado access?
Yes, once your data is in Pentaho, you can distribute reports and dashboards to any colleague through Pentaho's native sharing features. Your sales team, managers, and executives can view updated funnel metrics and opportunity analyses without needing direct access to Kondado or the original PipeRun CRM.
Do I need technical expertise to build PipeRun reports in Pentaho?
No coding is required to get started, as Kondado handles the data replication process automatically. Business users can select their desired pipelines through an intuitive interface, and Pentaho's visualization tools allow you to create charts and graphs using familiar drag-and-drop functionality, making sales analytics accessible to marketing and operations teams.
What types of custom fields can I visualize from PipeRun?
The Opportunities: Custom Fields pipeline captures all your personalized CRM configurations, including customfield_name and value data associated with each deal_id. This means any custom attributes you have configured in PipeRun, such as industry segments, referral sources, or priority flags, become available as structured dimensions in your Pentaho reports.
Can I combine PipeRun data with other business sources in Pentaho?
Absolutely, you can replicate data from additional Kondado sources into the same Pentaho environment to create unified business views. Many users blend PipeRun sales information with marketing data from Google Sheets or financial records from PostgreSQL to analyze the complete customer journey and ROI across departments.
How do I ensure my opportunity data stays current in Pentaho?
After the initial setup, Kondado maintains automated updates based on your chosen frequency, continuously replicating new deals, status changes, and closed opportunities into Pentaho. You can adjust the refresh schedule anytime to match your reporting needs, whether you need near-real-time visibility for active campaigns or daily summaries for executive reviews.

Try out all the features for free for 14 days