Connect Granatum 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

Granatum
Pentaho

Visualize Granatum Data in Pentaho

Visualizing your financial data from Granatum in Pentaho helps you track cash flow and business performance without manual spreadsheet work. Kondado creates a direct connection between your financial management software and Pentaho, letting you build interactive reports that update automatically so you always know your current financial position and can spot trends immediately.

With Kondado, you replicate Granatum data on a configurable schedule, choosing updates every 5 minutes, hourly, or daily based on your business needs. This means your Pentaho dashboards always reflect current bank balances, transaction histories, and client information without anyone copying and pasting data between systems. Business teams can monitor payment trends, analyze spending by category, and share financial insights across departments without waiting for IT support or manual exports. Whether you manage one company or multiple clients as an agency, automated data replication ensures everyone works with the same accurate numbers to drive better financial decisions.

Kondado connects Granatum to Pentaho using a direct “Via Kondado” connection that requires no intermediate databases or complex technical setup, allowing business teams to visualize financial data and make informed decisions within minutes.

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

Combining Granatum financial data with Pentaho visualization capabilities gives SMBs and agencies powerful insights into their money management. By bringing together your Bank Accounts, Transactions, and Categories pipelines, you can create comprehensive cash flow reports that show exactly where money enters and leaves your business across different accounts and expense types.

Operations teams can track which Payment Methods drive the most revenue while monitoring Cost and Profit Centers to understand which business units contribute most to your bottom line. Marketing agencies managing multiple Granatum accounts can consolidate financial data from all clients into unified Pentaho reports, comparing performance metrics and identifying opportunities to optimize spending without switching between different software interfaces.

Try out all the features for free for 14 days

Granatum data available in Pentaho

6
available pipelines
83
extractable fields

Available integrations

Integration Description
Bank Accounts Table contains information about bank accounts, including fields such as id, description, and balance.
Transactions Table records financial transactions with fields such as id, description, value, and due date.
Categories Table lists categories with fields such as id, description, and color, allowing for the organization of transactions.
Cost and Profit Centers Table presents cost and profit centers with fields such as id, description, and parent_id for hierarchy.
Payment Methods Table details payment methods with fields such as id and description, facilitating transaction management.
Clients Table contains client data, including fields such as name, email, phone, and address.
Bank Accounts
Table contains information about bank accounts, including fields such as id, description, and balance.
Transactions
Table records financial transactions with fields such as id, description, value, and due date.
Categories
Table lists categories with fields such as id, description, and color, allowing for the organization of transactions.
Cost and Profit Centers
Table presents cost and profit centers with fields such as id, description, and parent_id for hierarchy.
Payment Methods
Table details payment methods with fields such as id and description, facilitating transaction management.
Clients
Table contains client data, including fields such as name, email, phone, and address.

Try out all the features for free for 14 days

How to create Granatum dashboards in Pentaho

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

1
Connect Granatum as data source

Log into Kondado and add Granatum as a new data source by entering your API credentials. Select the financial pipelines you want to replicate, such as Bank Accounts and Transactions, to start syncing your data.

2
Select Pentaho as destination

Choose Pentaho as your destination and configure the connection settings to establish the data flow. You can also send data to Power BI or Google Sheets if you need reports in multiple platforms.

3
Build dashboards and configure refresh

Access your replicated Granatum data in Pentaho to create custom financial reports and visualizations. Set your preferred update frequency, choosing from every 5 minutes to daily, to keep your dashboards current without manual intervention.

Access Granatum 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 Granatum 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 Granatum data in Pentaho automatically

How do I connect Granatum to Pentaho using Kondado?
Start by adding Granatum as a data source in your Kondado account and authenticating with your credentials. Then select Pentaho as your destination and choose which pipelines like Bank Accounts and Transactions you want to replicate. Kondado handles the connection automatically without requiring database configuration or complex technical setup.
What Granatum data can I visualize in Pentaho?
You can replicate six different pipelines including Bank Accounts, Transactions, Categories, Cost and Profit Centers, Payment Methods, and Clients. This lets you build custom dashboards showing cash balances, expense breakdowns, revenue by payment method, and client profitability analysis directly in Pentaho.
How often does Granatum data update in Pentaho dashboards?
Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily or weekly. You choose the frequency based on how quickly you need financial insights, ensuring your Pentaho reports reflect recent transactions without manual refreshes.
Can I track cash flow across multiple bank accounts in Pentaho?
Yes, by using the Bank Accounts and Transactions pipelines together, you can create unified cash flow visualizations showing balances and movements across all your accounts. This helps finance teams monitor liquidity positions and identify funding needs without logging into Granatum directly.
What financial KPIs should I monitor in Pentaho with Granatum data?
Focus on metrics like burn rate using Cost and Profit Centers, accounts receivable aging from Clients data, and expense distribution by Categories. You can also track which Payment Methods generate the most revenue and compare planned versus actual spending across different business units.
Can I combine Granatum data with other business data in Pentaho?
Yes, you can use Kondado to replicate data from additional sources into Pentaho alongside your Granatum information. This allows you to create comprehensive dashboards that correlate financial metrics from Granatum with operational data from other business systems for complete performance visibility.

Try out all the features for free for 14 days