E-conomic to Azure SQL Database integration

Connect E-conomic to Azure SQL Database and automatically sync your finance & accounting data.

Get started free E-conomic connector

E-conomic

Data source

Authenticating...

Ready to connect

CONNECTOR SOURCE

E-conomic to Azure SQL Database

Connect E-conomic to Azure SQL Database and automatically sync your finance & accounting data. Weld extracts Invoices, Payments, Accounts, and Transactions from E-conomic, loads them into Azure SQL Database, and lets you transform the data using SQL or dbt, no custom scripts required.

E-conomic data schema

Open full-page schema explorer

20tables

408fields

contraAccount_accountNumber

netAmountInBaseCurrency

corporateIdentificationNumber

dimension_booked_entries

dimension_draft_entries

netAmountInBaseCurrency

account_accountNumber

int

amount

double

supplierInvoiceNumber

departmentalDistribution_departmentalDistributionNumber

settings_voucherNumbers_minimumVoucherNumber

int

settings_voucherNumbers_maximumVoucherNumber

int

settings_entryTypeRestrictedTo

enum

settings_contraAccounts_customerPayments_accountNumber

int

settings_contraAccounts_supplierPayments_accountNumber

int

settings_contraAccounts_financeVouchers_accountNumber

account_accountNumber

int

journal_journalNumber

double

customer_customerNumber

int

customerInvoice

int

supplier_supplierNumber

int

supplierInvoiceNumber

string

paymentDetails_paymentType_paymentTypeNumber

netAmountInBaseCurrency

accrual_accountNumber

attention_supplierContactNumber

corporateIdentificationNumber

string

costAccount_accountNumber

account_accountNumber

int

contraAccount_accountNumber

int

vatType_vatTypeNumber

Open full-page schema explorer

Everything you need to get started

E-conomic

Setup guide Data schema20 tables Connector page

Azure SQL Database

Setup guide Connector page

Weld Connect API

Set up programmatically

Use the Weld Connect REST API to create E-conomic connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a E-conomic ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "economic",
    "destination_schema_name": "economic_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQs

How do I sync E-conomic data to Azure SQL Database?

Sign up for Weld, connect E-conomic as a source and Azure SQL Database as a destination. Weld handles the extraction, loading, and lets you transform data using SQL or dbt.

What E-conomic data can I sync to Azure SQL Database?

You can sync Invoices, Payments, Accounts, Transactions, and Customers. The available objects depend on your E-conomic account permissions and configuration.

How often does Weld sync data from E-conomic?

Sync frequency depends on your Weld plan. Schedules range from every 5 minutes to daily intervals. Each sync processes only new and changed data.

Can I transform E-conomic data before it lands in Azure SQL Database?

Yes. Weld supports SQL-based transformations in the platform and integrates with dbt Cloud. You can clean, join, and model your data before analysis.

Is the E-conomic to Azure SQL Database integration secure?

Yes. Weld encrypts all data in transit and at rest, is SOC 2 Type II certified, and supports IP whitelisting. Credentials are stored encrypted and never logged.