Warehouse Manager

Data integration and synchronization dashboard

Imports

Azure / SharePoint Import Not configured

Import SharePoint lists via Microsoft Graph API

Hourly, 8:00–18:00

BSS Import Not configured

Import transaction entries from BSS real estate accounting

Hourly at :30, 8:00–18:00

Directo Import Active

Import invoices, payments, and receipts from Directo

Every 15min–2h, weekdays 8:00–18:00

Erply Import No companies

Import accounts and entries from Erply Books

Hourly at :15, 8:00–18:00

Odoo Import Active

Import chart of accounts and journal entries from Odoo

Daily at 03:00

QuickBooks Import No companies

Import accounts, transactions, customers, and vendors

Daily at 02:00

Exports

Bloomberg Export Not configured

Export daily balance data to Bloomberg SFTP

Weekdays at 14:05

Background Jobs (No UI)

JPM (JP Morgan) Not configured

Import holdings and transactions via SFTP

Weekdays at 14:00

Goldman Sachs Not configured

Import holdings and activity via SFTP

Weekdays at 14:10

Database Operations

Full Migration

Typically takes ~10 minutes to complete

1. Migrate master data: companies, projects, and accounts from Azure

2. Load transactions: Directo, BSS, and Erply staging tables into normalized ODS layer

3. Transform: build core transaction model with project/object allocations and counterparty mappings

4. Consolidate: build ownership hierarchies

Data Impact Details

Drops & Recreates (structure lost)

  • Dimension tables (dim_date, dim_currency, dim_project, dim_object, dim_coa_taxonomy)
  • Staging tables (stg_directo_*, stg_bss_*, stg_erply_*, stg_qb_*)
  • ODS tables (ods_transaction_*)
  • Consolidation table (fct_ownership)
  • Mapping tables (dim_company_object_mapping, dim_account_object_mapping)

Deletes All Data (structure preserved)

  • core_transaction and core_transaction_line
  • Allocation tables (core_transaction_line_project, core_transaction_line_object)
  • Counterparty mappings (core_transaction_line_counterparty)
  • Reference dimensions (dim_currency, dim_date)
Output: What Gets Built

Core Data Model

  • core_transaction + core_transaction_line — Unified general ledger from Directo, BSS, Erply
  • core_transaction_line_project/object — Multi-dimensional allocations
  • core_transaction_line_counterparty — Line-level counterparty tracking

Dimensions

  • dim_company — Legal entities with ownership relationships
  • dim_project — Investments (ISIN, brokers, lifecycle)
  • dim_object — 3-level categorization hierarchy
  • core_account + dim_coa_taxonomy — Chart of accounts

Consolidation

  • fct_ownership — Parent-subsidiary relationships with ownership % and effective dates

Reporting Views

  • vw_pearaamat — General ledger with full dimensions
  • vw_jane_tr_consolidated — Consolidated with Intragroup/External
  • vw_account_hierarchy — Standardized account hierarchy

After running, you can:

Query unified financial data across all source systems, generate consolidated/unconsolidated IFRS reports, analyze by investment position, and identify intragroup transactions for elimination.

Task History

Status Source Type Message Started Duration
completed scheduled directo full Directo full import (3 companies)
  • 77101 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 17:45:02 1m 45s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-04-15 17:31:48 0s
completed scheduled directo full Directo full import (3 companies)
  • 77089 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 17:30:02 1m 45s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-04-15 17:16:47 0s
completed scheduled directo full Directo full import (3 companies)
  • 77081 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 17:15:02 1m 43s
completed scheduled directo full Directo full import (3 companies)
  • 77081 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 17:00:01 1m 46s
completed scheduled directo full Directo full import (3 companies)
  • 77078 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 16:45:01 1m 46s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-04-15 16:31:48 0s
completed scheduled directo full Directo full import (3 companies)
  • 77075 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 16:30:01 1m 46s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-04-15 16:16:47 0s
completed scheduled directo full Directo full import (3 companies)
  • 77072 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 16:15:01 1m 45s
completed scheduled directo full Directo full import (3 companies)
  • 77063 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 16:00:01 1m 45s
completed scheduled directo full Directo full import (3 companies)
  • 77037 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 15:45:01 1m 45s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-04-15 15:31:48 0s
completed scheduled directo full Directo full import (3 companies)
  • 77041 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 15:30:02 1m 45s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-04-15 15:16:47 0s
completed scheduled directo full Directo full import (3 companies)
  • 77041 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 15:15:02 1m 44s
completed scheduled directo full Directo full import (3 companies)
  • 77041 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 15:00:01 1m 48s
completed scheduled directo full Directo full import (3 companies)
  • 77041 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 14:45:02 1m 44s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-04-15 14:31:48 0s
completed scheduled directo full Directo full import (3 companies)
  • 77041 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 14:30:02 1m 45s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-04-15 14:16:47 0s
completed scheduled directo full Directo full import (3 companies)
  • 77041 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-04-15 14:15:01 1m 45s
failed scheduled bloomberg Bloomberg scheduled export failed
  • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'andmeladu.bbg_sftp_daily_balance' doesn't exist (Connection: mysql
  • SQL: select count(*) as aggregate from `bbg_sftp_daily_balance`)
 2026-04-15 14:05:05 0s
failed scheduled jpm JPM scheduled import failed Unable to connect to host: 2026-04-15 14:01:49 0s

Source Table Statistics

Directo

transaction_row 77,101
payment 0
payment_row 0
receipt 0
receipt_row 0
invoice 0
invoice_row 0
Total 77,101

Odoo

odoo_account 2,622
odoo_journal_entry 1,474
odoo_journal_entry_line 16,231
Total 20,327

QuickBooks

qb_account 0
qb_transaction 0
qb_transaction_line 0
qb_customer 0
qb_vendor 0
qb_class 0
Total 0

Erply

erply_account 0
erply_account_entry 0
Total 0

BSS

bss_transaction_entry 0
bss_transaction_entry_detalization 0
Total 0

JPM

jpm_client 0
jpm_holding 0
jpm_instrument 0
jpm_transaction 0
jpm_fx_position 0
Total 0

Goldman Sachs

gs_account 0
gs_activity 0
gs_holding 0
Total 0

Azure

azure_bs_konto_objekt 0
azure_entity_relationships 68
azure_epra_formulas 0
azure_indi_account_mapping_sp 745
azure_kontserni_kontoplaan 535
azure_objects 0
azure_project_repository 0
azure_sp_accounts_taxonomy 135
Total 1,483