ETL+ Objects

Owned by Cortlandt _
Jun 24, 2023
1 min read

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.

Related Concepts

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

Video: Get to know database objects - Microsoft Support

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.