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.
Select a data warehouse from the list → Modify.
Or click Add New to create a new one
...
.
...
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 ✅