Extract data from E-conomic

Start moving your E-conomic data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the E-conomic connector in the Weld documentation

journals

name

string

settings_voucherNumbers_m...

int

settings_voucherNumbers_m...

int

settings_entryTypeRestric...

enum

settings_contraAccounts_c...

int

... 4 more fields

journal_entries

account_accountNumber

int

journal_journalNumber

double

customer_customerNumber

int

customerInvoice

int

supplier_supplierNumber

int

... 28 more fields

13 more economic tables

Explore available E-conomic data

Browse all the data tables available for the E-conomic connector, in our interactive ERD data viewer.

View the E-conomic Data Schema

Transform and model E-conomic data

Get clean data models from your E-conomic data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

E-conomic

raw.e-conomic.table1

raw.e-conomic.table2

Get started with E-conomic SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for E-conomic.

Invoice line items

Retrieves invoice line items from the economic integration. It combines data from the "booked_invoices" table and the "products" and "customers" tables to provide information such as the customer name, invoice details, product details, and order by date in descending order.

Order items

Retrieves order items from the "economic" integration. It combines data from the "orders" table and the "customers" table, joining them based on the customer ID. The result is sorted in descending order by date.