ETL+ Source Objects Panel

Names and maintains connections to data sources. The Source Objects panel is one of three main panels of the ETL+ Extract, Transform and Load (ETL) page.

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 ETL+ Source Types, ETL+ Source Drivers 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. Expand or collapse Source Objects with + or - next to the data source name.

Source Objects, Source Drivers, and Metadata.

• Data sources are source systems (data sources) available to extract data.

• Source Objects encapsulate data sources and ETL+ Source Drivers in order to connect to and extract data from source systems.
  See also Source Driver Defined, Source Drivers available on ETL+,
  ETL+ Source Types, Source Systems and IT

• 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 ETL+ Metadata

zData Warehouse ( Default Data Warehouse )

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.

Related Pages:

• ETL+ Source Drivers – tutorials on how to extract data from a variety of source systems and load them into a data warehouse.

• ETL+ Source Types Use cases focusing on particular ERP, CRM and other data source systems.

• Adding a new data source to ETL+

• ETL+ Extract, Transform and Load (ETL) Page – The Source Objects panel is one of three main panels of ETL+ Extract, Transform and Load (ETL) page

Where is this Page in ETL+?

v2023.07 ✅