Breadcrumbs

Access Data Source's Metadata from ETL+

Accessing metadata of data sources from ETL+.

Open ETL+

  1. Open a ETL+ entity in ETL+.

image-20250131-204500.png

  1. Select the data source from the .

image-20250131-204556.png
with data sources
AcumaticaDB_2022R2, Sage100_ABX
image-20250131-195621.png
Toolbar of Source Objects panel


Source Driver Pages

  1. Click Properties image-20250131-200409.png to show the ETL+ source driver linked to the data source.

Example Source Driver pages

image-20250131-202239.png
ODBC Databases /
ODBC source driver page
image-20230819-001143.png
image-20230803-042705.png

Tables from Data Source

  1. Click Refresh image-20250131-205118.png to extract fresh metadata from the data source.

  2. Expand image-20250131-210049.png the data source to show the tables available.

image-20250131-210259.png

Show Tables & Columns Extracted from the Data Source

Perform the steps from Open ETL+ and Tables from Data Source above (steps 1-2 and 4-5).

image-20250131-211912.png
image-20250131-211935.png
Expand AcurmaticaDB_2022R2, Select Account

Columns Loaded into the Data Warehouse

The ETL+ Design Page shows the columns and transformations that are loaded into the data warehouse.

  • Select a table on the Target Objects panel.

  • Select Design image-20250131-213435.png to open the Design page

image-20220903-032621.png
Target Objects panel Toolbar


by Source Systems / Data Sources