What specific Granatum data can I extract using Kondado?

You can replicate 6 pipelines comprising 83 fields total. This includes Bank Accounts with balance information, Transactions with values and due dates, Categories with color coding, Cost and Profit Centers with hierarchical parent relationships, Payment Methods, and complete Client records with contact details and addresses.

How do I connect Granatum to Power BI or Google Sheets?

Start by adding Granatum as a data source in your Kondado account, then select which pipelines to extract. Send your data to Power BI for advanced visualization, Google Sheets for collaborative analysis, or BigQuery for data warehousing without writing code.

How often does Kondado update my Granatum data?

Kondado updates data on a configurable schedule that you control, ranging from every 5 minutes to daily intervals. This ensures your financial reports reflect recent transaction entries and account balance changes without manual intervention.

What financial analyses can I run with Granatum pipelines?

You can calculate cash runway by combining Bank Accounts balances with Transactions due dates, analyze departmental profitability using Cost and Profit Centers against transaction Categories, and track customer payment patterns by joining Clients data with transaction histories. These combinations enable working capital optimization and expense allocation insights.

Can I send Granatum data to a database like PostgreSQL or MySQL?

Yes, Kondado supports database destinations including PostgreSQL , MySQL, and BigQuery . This allows you to store historical Granatum data in structured tables for SQL-based analysis and connection to business intelligence tools.

Do I need technical skills or API knowledge to connect Granatum?

No coding or API expertise is required. Kondado provides a direct connection to Granatum where you simply authenticate your account, select the desired pipelines such as Transactions or Clients, and choose your destination. The platform handles the data replication automatically.

Can I combine Granatum data with other sources in Looker Studio?

Absolutely. Send your Granatum pipelines to Looker Studio alongside data from other sources to create unified dashboards. For example, blend Granatum Transactions with marketing spend data to calculate true customer acquisition costs and lifetime value ratios.

Send Granatum data to reports, spreadsheets and ETL

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

Granatum Data Pipelines for Analytics and Reporting

Kondado enables you to extract granular financial data from Granatum and replicate it to your preferred analytics environment. Access detailed information from your Bank Accounts, Transactions, Categories, Cost and Profit Centers, Payment Methods, and Clients pipelines. Pull specific fields including account balances, transaction values with due dates, client contact details, and hierarchical cost center structures. This Granatum data replication supports comprehensive financial analysis without manual exports, delivering fresh data on a configurable schedule.

Kondado’s Granatum data source offers 6 distinct pipelines covering 83 fields, enabling complete extraction of your financial management data including banking information, transaction records, client databases, and organizational categorization systems.

Finance teams can monitor cash flow trends by analyzing Bank Accounts balances alongside Transactions due dates to predict liquidity needs and optimize working capital. Operations managers benefit from combining Cost and Profit Centers data with Categories to track departmental spending against revenue streams and identify cost allocation patterns. Marketing and sales teams leverage the Clients pipeline to segment customer bases by payment history and geographic address data for targeted retention campaigns. Data analysts can build unified Granatum analytics environments that connect financial operations with customer relationship metrics, enabling profitability analysis by client segment and payment method.

The Kondado platform takes care of refreshing Granatum data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Granatum data in your report, spreadsheet, data warehouse, data lake, or database

The following pipelines capture every dimension of your Granatum financial ecosystem. Analyze the Bank Accounts pipeline to track current balances and identify liquidity patterns across multiple institutions. The Transactions pipeline reveals cash flow timing through value and due date fields, helping you forecast payables and receivables with precision. Use the Categories pipeline to group spending by color-coded organizational tags, while Cost and Profit Centers enable hierarchical analysis of departmental performance against budget targets. The Clients pipeline enriches financial data with customer contact information and addresses for geographic revenue analysis.

Merge Transactions with Payment Methods to identify which channels drive the highest transaction volumes, or combine Clients with Bank Accounts to analyze customer payment behaviors by region. Cross-referencing Categories with Cost and Profit Centers reveals which business units generate specific expense types, enabling granular profitability tracking. With automated updates on a configurable schedule ranging from every 5 minutes to daily, your KPIs for cash runway, days sales outstanding, and expense ratios stay current without manual refresh cycles.

Try out all the features for free for 14 days

Available Granatum data

available pipelines

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.

How to visualize Granatum data in 3 steps

Connect Granatum to dashboards, spreadsheets, or databases — no code required.

Add Granatum Data Source

Connect your Granatum account to Kondado by selecting it from the data source catalog and entering your authentication credentials.

Select Pipelines and Destination

Choose which pipelines to replicate, such as Bank Accounts, Transactions, or Clients, then select where to send your data. Options include Power BI, Google Sheets, BigQuery, PostgreSQL, MySQL, or Excel.

Visualize and Analyze Data

Build custom dashboards in Power BI or Looker Studio, perform ad-hoc analysis in Google Sheets or Excel, and query structured tables in BigQuery, PostgreSQL, or MySQL to derive financial insights.

Try out all the features for free for 14 days