ETL+ Objects

ETL+ uses the term Objects in the Source Objects and Target Objects panels to refer to connections to data sources and data warehouses, databases, tables or files, columns/fields, and data warehouses.


References in Training Pages

https://dataself.atlassian.net/wiki/spaces/DS/pages/1772552197 (Blue Belt Training)

These are the data tables in the DataSelf SQL Data Warehouse. The data is loaded from the Source to the Data Warehouse when the ETL+ refresh process runs.

The first Data Warehouse group is the ERP data loaded into the SQL Data Warehouse tables.


Contrast: Database Objects in MS SQL Server

https://support.microsoft.com/en-us/office/video-get-to-know-database-objects-020bfb91-394e-4555-84a4-5b0fd673e6d6

create database and schemas where all our tables and other objects will reside.

What are the 5 important objects of database?

Database objects

  • Tables.

  • Constraints.

  • Indexes.

  • Triggers.

  • Sequences.

  • Views.

  • Usage lists.