eOne.FabricWarehouse

1.0.0

Deploys the eOne Integration for Business Central warehouse schema into Microsoft Fabric: the bcRaw
landing tables the SmartConnect maps insert into, the bc current-state views that resolve them to
one row per record, and the bcModel reporting, lifecycle and data-quality views over those.

Install-eOneWarehouse builds a warehouse. Update-eOneWarehouse brings an existing one up to date
without discarding what it holds.

Requires the SqlServer module, version 21.1 or newer:

Install-Module SqlServer -Scope CurrentUser -AllowClobber

-AllowClobber is not optional on a machine with SSMS installed: its SQLPS module already exports
Invoke-Sqlcmd and the install fails without it. Creating the warehouse item (-CreateWarehouse) also
needs Az.Accounts.

Minimum PowerShell version

5.1

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name eOne.FabricWarehouse

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name eOne.FabricWarehouse

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

EthanSorenson

Copyright

Package Details

Author(s)

eOne Solutions

Functions

Install-eOneWarehouse Update-eOneWarehouse

Dependencies

This module has no dependencies.

Release Notes

1.0.0
First release.

- Install-eOneWarehouse deploys the schema: the bcRaw landing tables the SmartConnect maps
   insert into, the bc current-state views that resolve them to one row per record, and the
   bcModel reporting, lifecycle and data-quality views over those.
- Update-eOneWarehouse recreates every view and adds any missing landing table, leaving existing
   tables and their rows untouched. A first install refuses to run over an existing deployment
   and says so; Install-eOneWarehouse -Rebuild is the deliberate, confirmed way to start again.
- -CreateWarehouse creates the Fabric warehouse item first, and signs in a second time by itself
   when the second audience needs it.
- Sign-in checks the session before asking for credentials. A window where another module has
   already bound the assemblies MSAL needs cannot authenticate at all, and now says which module
   and what to do instead of failing on a missing type.

FileList

eOne.FabricWarehouse.nuspec
Deploy-EOneWarehouse.ps1
sql\01_schemas.sql
sql\20_views_current.sql
sql\31_views_lifecycle.sql
sql\10_tables_core.sql
sql\21_views_dimensions.sql
sql\32_views_reporting.sql
eOne.FabricWarehouse.psd1
sql\11_table_date.sql
sql\30_view_documenthistory.sql
sql\33_view_loadhealth.sql
eOne.FabricWarehouse.psm1
sql\12_view_documentexit.sql
sql\30_view_ledgerdocuments.sql
sql\34_views_dataquality.sql

Version History

Version	Downloads	Last updated
1.0.0 (current version)	5	9/21/2026