...
Schemas refer to how Target Objects and data warehouses are named.
The Multi-Tenant section below and the Source Driver used for the Source Object determines how schema’s are named.
...
Data Warehouse List
Only available for super users.
From the ETL+ main page, click Settings -> Data Warehouse.
To select an existing data warehouse, select the line from the list below and click Save.
Important:
When you change the data warehouse of an Entity, close and reopen ETL+ to re-load all its settings.
ETL+ needs the following MS SQL database roles to the data warehouse: db_datareader & db_datawriter.
...
Modify or Add New Data Warehouse
| Panel | ||
|---|---|---|
| ||
Modify Data Warehouse and New Data Warehouse pages are only available for super users. |
Select a data warehouse from the list → Modify.
Or click Add New to create a new one.
The page below appears.
...
Server name: IP, URL or MS SQL Server instance name. Ex.: (local).
Authentication: Windows or MS SQL Server.
Login and Password.
Multi-Tenant. Determines how SQL schema’s in the data warehouse and Target Objects are named.
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+ Source Types.
Multi-Tenant data warehouses: All tables will be loaded to a MS SQL schema = <ETL+ EntityID>.
Database name: Name of the SQL database.
Multi-Tenant: Defines if the data warehouse will host an organization’s specific data, or if for a multi-tenant platform.
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+ Source 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.
...
Data Warehouse Tables in SSMS
ETL+ data warehouse tables and databases stored in MS SQL Server which can be accessed via SQL Server Management Studio (SSMS).
...
Data Warehouse List
Only available for super users.
From the ETL+ main page, click Settings -> Data Warehouse.
To select an existing data warehouse, select the line from the list below and click Save.
Important:
When you change the data warehouse of an Entity, close and reopen ETL+ to re-load all its settings.
ETL+ needs the following MS SQL database roles to the data warehouse: db_datareader & db_datawriter.
...
Modify or Add New Data Warehouse
| Panel | ||
|---|---|---|
| ||
Modify Data Warehouse and New Data Warehouse pages are only available for super users. |
Select a data warehouse from the list → Modify.
Or click Add New to create a new one.
The page below appears.
...
Server name: IP, URL or MS SQL Server instance name. Ex.: (local).
Authentication: Windows or MS SQL Server.
...
Multi-Tenant. Determines how SQL schema’s in the data warehouse and Target Objects are named.
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+ Source Types.
Multi-Tenant data warehouses: All tables will be loaded to a MS SQL schema = <ETL+ EntityID>.
Database name: Name of the SQL database.
Multi-Tenant: Defines if the data warehouse will host an organization’s specific data, or if for a multi-tenant platform.
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+ Source 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.
v2022.08 ✅