Kondado makes it simple to turn your Exact Sales information into clear visual reports inside Pentaho. You choose Exact Sales as your data source, pick the pipelines you want to work with, and replicate that data directly into Pentaho without any intermediate databases or complex configuration. In minutes, your sales managers can explore lead funnels, opportunity values, and team activities through intuitive charts and graphs that support daily decision making.
Kondado connects Exact Sales to Pentaho through a Via Kondado connection that replicates 17 pipelines and 194 fields, keeping your sales reports updated on a configurable schedule without requiring code, spreadsheets, or intermediate databases.
This means marketing and operations teams at small and medium businesses can finally monitor lead progression, measure campaign results, and identify bottlenecks in the sales process using visual reports that stay current automatically. Instead of switching between platforms, you get a unified view of your Exact Sales metrics right where you analyze them.
Each item below is automatically replicated by Kondado from Exact Sales into Pentaho — no schema setup, no manual mapping.
17
available pipelines
194
extractable fields
∞
Auto-refresh
Available integrations
Appointments
Includes fields such as id, lead_id, and salesrep_email, enabling tracking of scheduled meetings and their notes.
Activities
Contains information about scheduled activities, including id, leadid, and status, facilitating the management of tasks related to leads.
Boxes
Presents data such as id, leadid, and status, allowing management of meetings and their respective notes.
Lead Lifecycle
Includes fields such as lead_id, origin_stage, and destination_stage, tracking the evolution of leads through the funnel.
Lead Stages
Presents information such as id, active, and funnel_id, detailing the different stages a lead can go through.
Leads
Contains data such as id, closing_forecast_date, and cnpj, providing a detailed profile of leads and their status in the funnel.
Discarded Leads
Includes information about leads that have been discarded, with fields such as lead_id and discard_date, allowing analysis of losses.
Leads: Custom Fields
Presents custom fields associated with leads, allowing for more detailed analysis tailored to specific needs.
Leads: Contacts
Includes information about contacts associated with leads, with fields such as contacts_id and email, facilitating communication.
Leads: Pain Points
Presents the main pain points identified in leads, allowing for a more effective approach in sales strategies.
Lead Qualifications
Includes information about the lead such as id, description, and status, allowing for detailed analysis of qualifications and conversion potential.
Calls
Records details of calls made, including id, lead_id, status, and date, facilitating tracking of interactions with leads.
Markets
Provides information about different markets, including id and name, allowing segmentation and analysis of leads by sector.
Sales Opportunities
Contains data on opportunities, including id, lead_id, and value, essential for assessing sales potential and prioritizing leads.
Sources and Sub-sources
Presents information about lead sources, including id and name, helping to understand where leads come from and their effectiveness.
Sales Development Representatives (SDRs)
Includes data on sales development representatives, such as id, name, and email, allowing for management and analysis of sales team performance.
Sales Representatives
Contains information about sales representatives, including id, name, and email, essential for managing the sales team and their interactions with leads.
By combining Exact Sales with Pentaho, you can build reports that reveal how leads move through your funnel and where opportunities stand. For example, the Lead Lifecycle pipeline shows exactly how prospects advance between stages, while the Sales Opportunities pipeline displays deal values and priorities so managers know where to focus their attention. You can also use the Calls pipeline to measure interaction frequency and identify which sales activities actually drive conversions. When these datasets come together in Pentaho, leadership gains a complete picture of pipeline health, sales team effectiveness, and revenue potential without relying on manual spreadsheets or scattered notes.
Try out all the features for free for 14 days
How to create Exact Sales dashboards in Pentaho
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
Add Exact Sales as Your Data Source
In Kondado, choose Exact Sales from the data source library and enter your account credentials to establish the connection. You will immediately see all 17 available pipelines with 194 fields ready to replicate.
2
Choose Pentaho as Your Destination
Select Pentaho as the destination for your Exact Sales data and define which pipelines you want to send, such as Leads, Sales Opportunities, or Lead Lifecycle. Kondado handles the data delivery directly so your information flows straight into Pentaho without any middleman databases.
3
Create Reports and Set Refresh Schedule
Open Pentaho to build your visual reports using the replicated Exact Sales data, then return to Kondado to set your preferred update frequency. You can choose automated updates as often as every 5 minutes to keep your reports updated automatically without manual intervention.
Try out all the features for free for 14 days
Access Exact Sales 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!
Answers about visualizing Exact Sales data in Pentaho automatically
How do I set up Exact Sales as a data source in Kondado?▼
Start by adding Exact Sales as a new data source in your Kondado account and enter your credentials. Once connected, you can browse the available pipelines and select the Exact Sales data you want to replicate into Pentaho. The setup requires no code and typically takes just a few minutes to complete.
What dashboards can I build in Pentaho with Exact Sales data?▼
You can create custom Pentaho reports that track lead funnel progression, sales opportunity values, and team activity metrics. Many teams build dashboards that combine Lead Lifecycle data with Calls and Sales Opportunities to visualize conversion paths and identify which stages need attention. These visualizations help managers allocate resources and forecast revenue with confidence.
How often does Exact Sales data update in Pentaho?▼
Kondado lets you choose a configurable schedule that fits your business rhythm, whether that means every 5 minutes, hourly, or daily. Once set, your Pentaho reports receive automated updates so your team always works with current information. You can adjust this frequency anytime as your reporting needs evolve.
Which KPIs should I track when visualizing Exact Sales in Pentaho?▼
Focus on metrics like lead stage advancement, opportunity win rates, call activity volume, and discarded lead reasons to understand funnel health. Comparing Lead Lifecycle trends against Sales Opportunities helps you spot delays in conversion and prioritize high-value deals. These indicators give operations and sales leaders actionable insights for daily management.
Do I need to start from scratch when building Exact Sales dashboards in Pentaho?▼
Kondado gives you access to 17 Exact Sales pipelines and 194 fields so you can design Pentaho dashboards around your specific sales workflow. You decide which data to include, from Lead Lifecycle to Sales Opportunities, and arrange visualizations that answer your exact business questions. This custom approach ensures every chart and metric reflects your unique process rather than a generic layout.
Can I share Exact Sales dashboards with my team in Pentaho?▼
Yes, once you build your dashboards in Pentaho, you can share them with colleagues across marketing, operations, and executive teams. Your teammates can view the same replicated Exact Sales data and collaborate on decisions using a single source of visual truth. This keeps everyone aligned on sales performance without exporting files or sending manual updates.
Can I send Exact Sales data to other tools besides Pentaho?▼
Absolutely, Kondado allows you to replicate Exact Sales data to multiple destinations beyond Pentaho. You can send your data to Power BI, Looker Studio, Google Sheets, BigQuery, or PostgreSQL depending on where your team prefers to analyze information. This flexibility lets you maintain the same Exact Sales pipelines across different reporting environments.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)