ETL+ Source Objects Panel

ETL+ connects, reads, and extracts from a wide variety of data sources / source systems. Connections to these data sources are managed on the Source Objects panel.
Where to find this panel in ETL+.

………………………….Source Objects panel button toolbar. …(Part of the ETL page.)

Add Table: Select a table under a data source and click Add Table.
Add Source: Click to add a new data source object.
More at https://dataself.atlassian.net/wiki/spaces/DS/pages/1570963898,
https://dataself.atlassian.net/wiki/spaces/DS/pages/1818853383
Delete Source.
Select a Source Object and click to delete.
Refresh. Select a source object and click to update it’s metadata. (F5)
Metadata is saved.
Properties. Select a source object and click to change the settings.
Similar to Add Data Source above.

Source Objects, Source Drivers, and Metadata.

Data sources are source systems (data sources) available to extract data.
Source Objects encapsulate data sources and https://dataself.atlassian.net/wiki/spaces/DS/pages/1818853383 in order to connect to and extract data from source systems.
See also , Source Drivers available on ETL+,
,
Metadata about data sources includes names of source tables/files, columns, data types, Unique/Primary keys and/or indexes, credentials, source system names, connection strings, Extract SQL Statement.
- Metadata is saved but will need to be refreshed when the source system changes.

For more see

zData Warehouse is the default, destination data warehouse. Read and write-back data to transform data already in the data ware. See also zData Warehouse (Reimports) in the Target Objects panel.

Used to created calculated fields, apply formulas, run SQL functions and make other data manipulations to the data warehouse.

– tutorials on how to extract data from a variety of source systems and load them into a data warehouse.
Use cases focusing on particular ERP, CRM and other data source systems.
– The Source Objects panel is one of three main panels of ETL+ Extract, Transform and Load (ETL) page

v2023.07