How do I connect Tiny ERP to Pentaho using Kondado?

Start by adding Tiny ERP as a data source in your Kondado account using your API credentials, then select Pentaho as your destination and choose which pipelines to replicate. The Via Kondado connection establishes directly between systems without requiring database configuration or coding knowledge.

What dashboards can I build with Tiny ERP data in Pentaho?

You can build financial dashboards combining Accounts Payable and Accounts Receivable data to monitor cash flow, or create sales performance reports using Order Details and Product Inventory pipelines to analyze best-selling items and stock turnover rates.

How often does Tiny ERP data update in Pentaho?

Kondado updates your Tiny ERP data in Pentaho on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals depending on your business needs and reporting urgency.

Which KPIs should I track when visualizing Tiny ERP data?

Track essential metrics including days sales outstanding from Accounts Receivable Details, inventory turnover from Product Inventory, and customer issue resolution times from CRM Issues to optimize working capital and service quality.

Are there pre-built report templates available for Tiny ERP?

Yes, ready-made dashboards are available including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report templates, which you can also adapt for Pentaho or customize further to match your specific business requirements.

Can I share Pentaho dashboards with my team using Kondado data?

Once your data flows into Pentaho, you can distribute reports to stakeholders across your organization using Pentaho's native sharing features, ensuring everyone accesses the same current information from your Tiny ERP system.

Do I need technical skills to visualize Tiny ERP data in Pentaho?

No coding is required to visualize Tiny ERP data in Pentaho through Kondado, as the platform handles the technical replication process while you focus on selecting relevant pipelines and designing reports that answer your business questions.

Can I send Tiny ERP data to other visualization tools besides Pentaho?

Yes, you can also send your data to Power BI , Looker Studio , Google Sheets , or BigQuery using the same simple setup process.

Connect Tiny ERP 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 Tiny ERP Data in Pentaho with Kondado

Visualizing your Tiny ERP data in Pentaho starts with connecting your ERP account to Kondado and selecting Pentaho as your destination. You can replicate data from your ecommerce operations, financial records, and customer management modules directly into Pentaho reports without writing any code. This direct integration allows business teams to transform raw operational data into actionable visual insights for smarter decision making.

Kondado provides a Via Kondado connection that links Tiny ERP to Pentaho directly, eliminating the need for intermediate databases or complex technical setup while keeping your reports updated on a configurable schedule.

With 15 available pipelines covering 792 fields across sales, inventory, and financial management, you gain complete visibility into your business performance. Marketing teams can track campaign ROI using order data, operations managers can monitor inventory levels, and finance teams can analyze cash flow trends, all within familiar Pentaho dashboards that update automatically.

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

Combine your Accounts Receivable and Accounts Payable pipelines in Pentaho to create comprehensive cash flow dashboards that show exactly when money enters and leaves your business. Track your Order Details alongside Product Inventory data to identify which items drive revenue and which stock levels need attention before they impact sales.

By visualizing CRM Issues data in Pentaho, customer service managers can spot recurring support patterns and prioritize high-value client relationships. These combined insights help retail, ecommerce, and service businesses using Tiny ERP make faster decisions about inventory purchases, credit policies, and customer retention strategies without waiting for IT teams to prepare manual reports.

Try out all the features for free for 14 days

Tiny ERP data available in Pentaho

available pipelines

792

extractable fields

Available integrations

Integration	Description
CRM Issues	Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.
CRM Issues Details	Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.
Accounts Payable	Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.
Accounts Receivable	Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.
Contacts	Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.
Accounts Payable Details	Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.
Accounts Receivable Details	Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.
Invoice Details	Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.
Invoice Details: XML	Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.
Order Details	Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.
Product Inventory	Table provides information about inventory, including fields such as id, product name, and available quantity.
Invoices	Table contains details of invoices, featuring fields such as id, issue date, and customer name.
Orders	Table lists the orders placed, including fields such as order id, order date, and status.
Products	Table presents information about products, with fields such as id, name, and price.
Product Grid	Table provides a detailed grid of products, including fields such as id, description, and category.

CRM Issues

Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.

CRM Issues Details

Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.

Accounts Payable

Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.

Accounts Receivable

Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.

Contacts

Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.

Accounts Payable Details

Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.

Accounts Receivable Details

Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.

Invoice Details

Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.

Invoice Details: XML

Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.

Order Details

Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.

Product Inventory

Table provides information about inventory, including fields such as id, product name, and available quantity.

Invoices

Table contains details of invoices, featuring fields such as id, issue date, and customer name.

Orders

Table lists the orders placed, including fields such as order id, order date, and status.

Products

Table presents information about products, with fields such as id, name, and price.

Product Grid

Table provides a detailed grid of products, including fields such as id, description, and category.

See all available data →

Try out all the features for free for 14 days

How to create Tiny ERP dashboards in Pentaho

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

Connect Tiny ERP to Kondado

Add Tiny ERP as a data source by entering your API credentials and selecting the specific pipelines you want to replicate from your ecommerce and financial modules.

Select Pentaho as Destination

Choose Pentaho as your destination to establish a direct Via Kondado connection that sends your operational data straight into Pentaho without intermediate databases or complex setup.

Build Dashboards and Set Refresh

Create your reports in Pentaho using the replicated data and configure your preferred update frequency to keep dashboards current, whether you need near-real-time updates or daily summaries.