DatriseAI-first ETL

Visma e-conomic to Azure Data Lake Storage Integration

AI-first ETL from Visma e-conomic into Azure Data Lake Storage. Governed entities, incremental sync, typed landing tables.

How Datrise loads Visma e-conomic into Azure Data Lake Storage

Datrise syncs Visma e-conomic's invoices, customers, suppliers, journal entries, accounts, and products into Azure Data Lake Storage as partitioned Parquet in ADLS Gen2 per source entity. Flexible or custom fields land in nested struct/map fields in Parquet, and timestamps such as created, updated, and status changes are typed as ISO-8601 timestamp columns.

Sync is incremental: Datrise uses writes new date partitions to the container and compacts on a schedule, so re-runs update only what changed. Hive-style partitioning by load date, readable by Synapse and Databricks. ADLS hierarchical namespace makes folder layout matter, so Datrise keeps a predictable entity/date path your Azure engines mount directly.

Ideal for Azure lakehouse storage shared across Synapse and Databricks.

Endpoints

Visma e-conomic: Nordic accounting, invoicing, and ledger records.

Azure Data Lake Storage: ADLS Gen2 object storage for analytics workloads.

How Visma e-conomic entities map to Azure Data Lake Storage

Visma e-conomic entityAzure Data Lake Storage objectNotes
invoicesvisma_e_conomic_invoicesid PK · custom fields → nested struct/map fields in Parquet
customersvisma_e_conomic_customersid PK · linked to visma_e_conomic_invoices
suppliersvisma_e_conomic_suppliersid PK · linked to visma_e_conomic_invoices
journal entriesvisma_e_conomic_journal_entriesid PK · linked to visma_e_conomic_invoices

FAQ

How does Datrise handle Visma e-conomic's custom fields in Azure Data Lake Storage?

Flexible values are stored as nested struct/map fields in Parquet, so new fields don't require a migration; strongly-typed fields — dates, numbers, and references — are promoted to native Azure Data Lake Storage types.

How does the Visma e-conomic to Azure Data Lake Storage sync stay up to date?

It runs incrementally — Datrise uses writes new date partitions to the container and compacts on a schedule.

Related pipelines

Early access

Connect Visma e-conomic to Azure Data Lake Storage the easy way

Skip brittle scripts and manual exports. Join the waitlist to get a guided setup, AI-assisted mapping, and reliable incremental sync for this integration.