Granatum

Granatum is financial management software for small and medium-sized companies. Granatum's data pipeline for the Data Warehouse created by Kondado makes it possible for you to have access to your financial data in your analytical cloud.

Adding the data source

To automate Granatum ETL with Kondado for your database, follow the steps below:

1) Log in to your Granatum account, go to Settings -> My Company -> Sidebar (API) and get the “Access Token”

2) On the Kondado plataform, go to the add data sources page and select the Granatum data source;

3) Give your data source a name and, in “API Token” paste the key generated in step (1)

Now just save the data source and start integrating your Granatum data into the Data Lake or Data Warehouse.

Pipelines

Relationship Chart

Gráfico de relacionamento entre tabelas

Contas Bancárias

Field	Type
id	text
descricao	text
saldo	float

Lançamentos

Main Object

Field	Type
id	text
grupo_id	text
lancamento_transferencia_id	text
categoria_id	text
centro_custo_lucro_id	text
tipo_custo_nivel_producao_id	text
tipo_custo_apropriacao_produto_id	text
conta_id	text
forma_pagamento_id	text
pessoa_id	text
tipo_lancamento_id	text
descricao	text
tipo_documento_id	text
documento	text
data_vencimento	date
valor	float
data_pagamento	date
data_competencia	date
observacao	text
pagamento_automatico	boolean
numero_repeticao	float
total_repeticoes	float
periodicidade	text
pedido_id	text
lancamento_composto_id	text

Field	Type
lancamento_id	text
tags__id	text

Categorias

Field	Type
id	text
descricao	text
cor	text
wgi_usuario_id	text
parent_id	text

Centros de custo e lucros

Field	Type
id	text
descricao	text
parent_id	text

Formas de pagamento

Field	Type
id	text
descricao	text

Clientes

Field	Type
estado_id	text
cidade_id	text
nome	text
nome_fantasia	text
bairro	text
cidade__nome	text
observacao	text
endereco_complemento	text
email	text
endereco_numero	text
telefone	text
cep	text
endereco	text
estado__sigla	text
estado__nome	text
id	text
documento	text

Fornecedores

Field	Type
estado_id	text
cidade_id	text
nome	text
nome_fantasia	text
bairro	text
cidade__nome	text
observacao	text
endereco_complemento	text
email	text
endereco_numero	text
telefone	text
cep	text
endereco	text
estado__sigla	text
estado__nome	text
id	text
documento	text

Tipos custo nível de produção

Field	Type
id	text
descricao	text

Tipos custo apropriação de produto

Field	Type
id	text
descricao	text

Tipos documento fiscal

Field	Type
id	text
descricao	text

Add Granatum as a Data Source on Kondado

Connect your Granatum financial data to Kondado's data warehouse or data lake in three simple steps.

Retrieve your Granatum API Access Token

Log in to your Granatum account, navigate to Settings → My Company → Sidebar (API), and copy the "Access Token". This token is required to authenticate Kondado's access to your financial data.

Select Granatum on the Kondado platform

Go to the data integration page on the Kondado platform and choose the Granatum data source from the available connectors.

Configure and save the data source

Give your data source a recognizable name, paste the API Token from step 1 into the "API Token" field, and save. You can then start integrating Granatum data into your destination of choice, such as a Data Lake or Data Warehouse.

Schedule pipeline frequency

Define an appropriate pipeline frequency to avoid multiple pipelines executing simultaneously, ensuring optimal performance and data consistency.

Frequently asked questions

What is Granatum and why would I connect it to Kondado?▼

Granatum is financial management software for small and medium-sized companies. Connecting it to Kondado allows you to automate ETL and access your financial data in your analytical cloud or data destination.

Where do I find the API Access Token in Granatum?▼

Log in to your Granatum account, go to Settings → My Company → Sidebar (API). The "Access Token" field contains the key you need to paste into Kondado when adding the data source.

What Granatum data tables are available through the Kondado pipeline?▼

The pipeline includes tables such as Contas Bancárias, Lançamentos (the main object), tags, Categorias, Centros de custo e lucros, Formas de pagamento, Clientes, Fornecedores, and several reference tables for production cost types, document types, and Tags.

Can I send Granatum data to a BI tool or spreadsheet?▼

Yes. Once the data source is configured, you can integrate Granatum data into a Data Warehouse, Data Lake, or other destinations for dashboards and analysis.

How should I schedule my Granatum pipelines?▼

We recommend defining pipeline frequencies so that multiple pipelines do not execute at the same time. This prevents resource contention and ensures reliable data extraction.

Written by

Thassyo Pereira·Published 2023-07-07·Updated 2026-04-25