Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

ETL+ Data Warehousing, MS SQL Server based, architecture.

Table of Contents

Schemas

See Schemas + Multi-Tenant sections below.

...

Load type = Load All: If you have a table set for Load All in ETL+, the Create Date displayed by SSMS displays the date from the last refresh because ETL+'s Load All refresh process drops the existing table and creates a new one in it’s place.

...

Database naming convention: Dw_<company-name>_<main-source> (example: Dw_AbcInc_NSuite)

ETL+

Default recommended SQL Server properties:

...

Modify or Add New Data Warehouse

Only available for super users.

  1. Select a data warehouse from the list → Modify.

  2. Or click Add New to create a new one

...

  1. .

...

Server name: IP, URL or MS SQL Server instance name. Ex.: (local).

...

  • Non Multi-Tenant data warehouses: This is the default data warehouse’s MS SQL schema for this ETL+ entity. For instance, all tables will be loaded to the dbo SQL schema. You can configure Sources to have their own SQL schemas. Learn more at ETL+ Data SourcesSource Types.

  • Multi-Tenant data warehouses: All tables will be loaded to a MS SQL schema = <ETL+ EntityID>.

...

  • Multi-Tenant checkbox not checked:

    • Users will have access to all SQL schemas in the data warehouse.

    • Users can configure Sources to have their own SQL schemas. Learn more at ETL+ Data SourcesSource Types.

  • Multi-Tenant checkbox checked: User will only have access to the data warehouse schemas:

    • dbo: read only

    • <ETL+ EntityID>: read and write. All tables are loaded into this SQL schema.

Related Pages

v2022.08 ✅