Warehouse Manager

Data integration and synchronization dashboard

Imports

Azure / SharePoint Import

Import SharePoint lists via Microsoft Graph API

Hourly, 8:00–18:00

BSS Import

Import transaction entries from BSS real estate accounting

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

Directo Import

Import invoices, payments, and receipts from Directo

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

Erply Import

Import accounts and entries from Erply Books

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

Odoo Import

Import chart of accounts and journal entries from Odoo

Daily at 03:00

QuickBooks Import

Import accounts, transactions, customers, and vendors

Daily at 02:00

Exports

Bloomberg Export

Export daily balance data to Bloomberg SFTP

Weekdays at 14:05

Background Jobs (No UI)

JPM (JP Morgan)

Import holdings and transactions via SFTP

Weekdays at 14:00

Goldman Sachs

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.