Skip to content
Book a demoStart free
Connectors

e-conomic connector

Set up the e-conomic connector in Kaivo: authentication, configuration, the 33 BigQuery tables it syncs, and answers to common questions.

e-conomic connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your e-conomic data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

Sync your e-conomic accounting data into BigQuery with Kaivo to analyse invoices, customers, and the ledger in one place.

CategoryFinance & Payments, ERP
AuthenticationAPI key
SetupSelf-service

Getting started with the e-conomic connector

Section titled “Getting started with the e-conomic connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your e-conomic account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your e-conomic credentials. You provide:

Field Description
App Secret Token
Your private token that identifies your app. Find it in your e-conomic account settings.

| | Agreement Grant Token |

Token that identifies the grant issued by an agreement, allowing your app to access data. Obtain it from your e-conomic account settings.

|

Kaivo syncs 33 tables from e-conomic into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

accounting_years (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
entries STRING
from_date STRING
periods STRING
self STRING
to_date STRING
totals STRING
vouchers STRING
year STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
accounts (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_number FLOAT64
account_type STRING
accounting_years STRING
balance FLOAT64
block_direct_entries BOOL
debit_credit STRING
department__department_number FLOAT64
department__name STRING
department__self STRING
departmental_distribution__departmental_distribution_number FLOAT64
departmental_distribution__distribution_type STRING
departmental_distribution__self STRING
name STRING
self STRING
total_from_account__account_number FLOAT64
total_from_account__self STRING
vat_account__self STRING
vat_account__vat_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
app_roles (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
role_number FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • app_roles__required_modules (5 columns)
archived_orders (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment STRING
cost_price_in_base_currency FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
last_updated STRING
layout__layout_number FLOAT64
layout__self STRING
margin_in_base_currency FLOAT64
margin_percentage FLOAT64
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
order_number FLOAT64
… and 33 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • archived_orders__lines (4 columns)
archived_quotes (61 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment STRING
cost_price_in_base_currency FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
last_updated STRING
layout__layout_number FLOAT64
layout__self STRING
margin_in_base_currency FLOAT64
margin_percentage FLOAT64
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
order_number_db FLOAT64
… and 36 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • archived_quotes__lines (4 columns)
booked_invoices (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
booked_invoice_number FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
layout__layout_number FLOAT64
layout__self STRING
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
notes__heading STRING
notes__text_line1 STRING
notes__text_line2 STRING
order_number FLOAT64
payment_terms__description STRING
… and 32 more columns
currencies (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING
iso_number STRING
name STRING
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer_groups (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account__account_number FLOAT64
account__account_type STRING
account__accounting_years STRING
account__balance FLOAT64
account__block_direct_entries BOOL
account__debit_credit STRING
account__name STRING
account__opening_account__account_number FLOAT64
account__opening_account__self STRING
account__self STRING
customer_group_number FLOAT64
customers STRING
name STRING
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (49 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
attention__customer__customer_number FLOAT64
attention__customer__self STRING
attention__customer_contact_number FLOAT64
attention__self STRING
balance FLOAT64
barred BOOL
city STRING
contacts STRING
corporate_identification_number STRING
country STRING
currency STRING
customer_contact__customer__customer_number FLOAT64
customer_contact__customer__self STRING
customer_contact__customer_contact_number FLOAT64
customer_contact__self STRING
customer_group__customer_group_number FLOAT64
customer_group__self STRING
customer_number FLOAT64
default_delivery_location__delivery_location_number FLOAT64
default_delivery_location__self STRING
delivery_locations STRING
due_amount FLOAT64
e_invoicing_disabled_by_default BOOL
… and 24 more columns
departmental_distributions (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
barred BOOL
departmental_distribution_number FLOAT64
distribution_type STRING
name STRING
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • departmental_distributions__distributions (6 columns)
departments (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
barred BOOL
department_number FLOAT64
name STRING
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
draft_invoices (70 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment STRING
cost_price_in_base_currency FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
draft_invoice_number FLOAT64
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
last_updated STRING
layout__layout_number FLOAT64
layout__self STRING
margin_in_base_currency FLOAT64
margin_percentage FLOAT64
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
… and 45 more columns
draft_orders (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment STRING
cost_price_in_base_currency FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
last_updated STRING
layout__layout_number FLOAT64
layout__self STRING
margin_in_base_currency FLOAT64
margin_percentage FLOAT64
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
order_number FLOAT64
… and 33 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • draft_orders__lines (4 columns)
draft_quotes (61 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment STRING
cost_price_in_base_currency FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
last_updated STRING
layout__layout_number FLOAT64
layout__self STRING
margin_in_base_currency FLOAT64
margin_percentage FLOAT64
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
order_number_db FLOAT64
… and 36 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • draft_quotes__lines (4 columns)
employees (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
barred BOOL
booked_invoices STRING
customers STRING
draft_invoices STRING
email STRING
employee_group__employee_group_number FLOAT64
employee_group__self STRING
employee_number FLOAT64
name STRING
phone STRING
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
journals (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
entries STRING
journal_number FLOAT64
name STRING
self STRING
settings__contra_accounts__customer_payments__account_number FLOAT64
settings__contra_accounts__customer_payments__self STRING
settings__entry_type_restricted_to STRING
settings__voucher_numbers__minimum_voucher_number FLOAT64
templates__finance_voucher STRING
templates__manual_customer_invoice STRING
templates__self STRING
vouchers STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
not_due_invoices (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
booked_invoice_number FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
layout__layout_number FLOAT64
layout__self STRING
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
notes__heading STRING
notes__text_line1 STRING
notes__text_line2 STRING
order_number FLOAT64
payment_terms__description STRING
… and 32 more columns
overdue_invoices (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
booked_invoice_number FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
layout__layout_number FLOAT64
layout__self STRING
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
notes__heading STRING
notes__text_line1 STRING
notes__text_line2 STRING
order_number FLOAT64
payment_terms__description STRING
… and 32 more columns
paid_invoices (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
booked_invoice_number FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
layout__layout_number FLOAT64
layout__self STRING
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
notes__heading STRING
order_number FLOAT64
payment_terms__description STRING
payment_terms__days_of_credit FLOAT64
payment_terms__name STRING
… and 30 more columns
payment_terms (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
contra_account_for_prepaid_amount__account_number FLOAT64
contra_account_for_prepaid_amount__self STRING
credit_card_company__customer_number FLOAT64
credit_card_company__self STRING
days_of_credit FLOAT64
name STRING
payment_terms_number FLOAT64
payment_terms_type STRING
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payment_types (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
payment_type_number FLOAT64
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_groups (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accrual__account_number FLOAT64
accrual__account_type STRING
accrual__accounting_years STRING
accrual__balance FLOAT64
accrual__block_direct_entries BOOL
accrual__debit_credit STRING
accrual__name STRING
accrual__self STRING
accrual__vat_account__self STRING
accrual__vat_account__vat_code STRING
name STRING
product_group_number FLOAT64
products STRING
sales_accounts STRING
self STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
bar_code STRING
barred BOOL
cost_price FLOAT64
invoices__booked STRING
invoices__drafts STRING
invoices__self STRING
last_updated STRING
minimum_stock FLOAT64
name STRING
pricing__currency_specific_sales_prices STRING
product_group__accrual__account_number FLOAT64
product_group__accrual__account_type STRING
product_group__accrual__accounting_years STRING
product_group__accrual__balance FLOAT64
product_group__accrual__block_direct_entries BOOL
product_group__accrual__debit_credit STRING
product_group__accrual__name STRING
product_group__accrual__self STRING
product_group__accrual__vat_account__self STRING
product_group__accrual__vat_account__vat_code STRING
product_group__name STRING
product_group__product_group_number FLOAT64
product_group__products STRING
… and 11 more columns
sent_invoices (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_by STRING
creation_date STRING
id FLOAT64
invoice__booked_invoice_number FLOAT64
invoice__self STRING
recipient__ean STRING
self STRING
sent_by STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sent_orders (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment STRING
cost_price_in_base_currency FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
last_updated STRING
layout__layout_number FLOAT64
layout__self STRING
margin_in_base_currency FLOAT64
margin_percentage FLOAT64
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
order_number FLOAT64
… and 33 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • sent_orders__lines (4 columns)
sent_quotes (61 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment STRING
cost_price_in_base_currency FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
last_updated STRING
layout__layout_number FLOAT64
layout__self STRING
margin_in_base_currency FLOAT64
margin_percentage FLOAT64
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
order_number_db FLOAT64
… and 36 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • sent_quotes__lines (4 columns)
suppliers (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
attention__number FLOAT64
attention__self STRING
bank_account STRING
city STRING
contacts STRING
cost_account__account_number FLOAT64
cost_account__self STRING
country STRING
currency STRING
default_invoice_text STRING
email STRING
layout__layout_number FLOAT64
layout__self STRING
meta_data__delete__description STRING
meta_data__delete__href STRING
meta_data__delete__http_method STRING
name STRING
payment_terms__payment_terms_number FLOAT64
payment_terms__self STRING
phone STRING
remittance_advice__creditor_id STRING
remittance_advice__payment_type__payment_type_number FLOAT64
remittance_advice__payment_type__self STRING
… and 12 more columns
total_invoices (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
booked__description STRING
booked__invoice_count FLOAT64
booked__net_amount_in_base_currency FLOAT64
booked__paid__description STRING
booked__paid__gross_remainder_in_base_currency FLOAT64
booked__paid__invoice_count FLOAT64
booked__paid__net_amount_in_base_currency FLOAT64
booked__paid__self STRING
booked__self STRING
booked__unpaid__description STRING
booked__unpaid__gross_remainder_in_base_currency FLOAT64
booked__unpaid__invoice_count FLOAT64
booked__unpaid__net_amount_in_base_currency FLOAT64
booked__unpaid__not_overdue__description STRING
booked__unpaid__not_overdue__invoice_count FLOAT64
booked__unpaid__not_overdue__net_amount_in_base_currency FLOAT64
booked__unpaid__not_overdue__self STRING
booked__unpaid__overdue__description STRING
booked__unpaid__overdue__gross_remainder_in_base_currency FLOAT64
booked__unpaid__overdue__invoice_count FLOAT64
booked__unpaid__overdue__net_amount_in_base_currency FLOAT64
booked__unpaid__overdue__self STRING
booked__unpaid__self STRING
drafts__description STRING
… and 23 more columns
units (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
products STRING
self STRING
unit_number FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
unpaid_invoices (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
booked_invoice_number FLOAT64
currency STRING
customer__customer_number FLOAT64
customer__self STRING
date STRING
delivery__address STRING
delivery__city STRING
delivery__country STRING
delivery__zip STRING
delivery_location__delivery_location_number FLOAT64
delivery_location__self STRING
due_date STRING
exchange_rate FLOAT64
gross_amount FLOAT64
gross_amount_in_base_currency FLOAT64
layout__layout_number FLOAT64
layout__self STRING
net_amount FLOAT64
net_amount_in_base_currency FLOAT64
notes__heading STRING
notes__text_line1 STRING
notes__text_line2 STRING
order_number FLOAT64
payment_terms__description STRING
… and 32 more columns
vat_accounts (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account__account_number FLOAT64
account__self STRING
contra_account__account_number FLOAT64
contra_account__self STRING
name STRING
rate_percentage FLOAT64
self STRING
vat_code STRING
vat_type__name STRING
vat_type__self STRING
vat_type__vat_type_number FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vat_types (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
self STRING
vat_type_number FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vat_zones (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
enabled_for_customer BOOL
enabled_for_supplier BOOL
name STRING
self STRING
vat_zone_number FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where e-conomic supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for e-conomic?

Section titled “How long does the initial sync take for e-conomic?”

It depends on how much history is in your e-conomic account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when e-conomic’s schema changes?

Section titled “What happens when e-conomic’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in e-conomic, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in e-conomic instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the e-conomic connector in Kaivo and all of its synced data is deleted with it.

Use accounts and accounting_years to build reports across your ledger.

Join customers with their invoices to track revenue and outstanding balances.

Use products and product_groups to see what drives revenue.

Use e-conomic data in your AI and BI tools

Section titled “Use e-conomic data in your AI and BI tools”

Once e-conomic data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with e-conomic data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for e-conomic connector pricing and plan details.