Breadcrumbs

ETL+ Target Object

To add target objects, click here.

Target Objects

To explore and change target objects:

  • Click a source connector header to view its target objects.

  • Click the v icon on the right of a target object to view its columns and data types.

image-20260525-015221.png
Expanded a source connector’s target objects

  • Mouse over the ? icon of a target object to view its metadata.

  • Click the Load Now icon on a target object to load its data now.

  • Click the More icon (…) on a target object to access additional features:

    • Delete Object

    • Design

    • Duplicate Objects

    • Preview Object

    • Rename Object

    • SQL Statement

    • Tags

    • Target Schema

    • Freeze

  • Click a target object name to access its control panel as a tab on the right area.

    • Clicking on target objects will replace the content of the control panel on the right area.

    • Use the tab pin to leave multiple target objects open. You can also drag pinned tabs to view multiple ones side by side, and/or one on top of each other.

image-20260525-024007.png

Target Object Metadata

  • The top section shows name, schema, and other variables.

  • The next section controls the Load Type:

    • Load All: Mirrors all source rows each run.

    • Replace: Mirrors source rows based on the Replace criteria.

    • Upsert: Updates changed source rows and inserts new ones.

    • Append: Append source rows.

  • The bottom section shows columns and their data types.

  • Click the Design button (top right) to edit the Column Metadata. More details below.

image-20260525-030133.png
Example of target object metadata.

Target Object Extract SQL

  • The right side provides the Extract SQL panel.

  • When adding a target object, ETL+ will automatically write the Extract SQL mapping all available source columns.

  • The SQL follows the source SQL syntax. For instance, T-SQL for MS SQL, and MySQL dialect for MySQL. Keep in mind that some sources provide little to no SQL transformations during the extraction.

  • One can edit the SQL Extract as needed.

image-20260525-030044.png

Design Target Object

image-20260525-164558.png
Example of a Design page

The Design button on the top right of the tab allows users to review and change several features of a target object:

  • SPK (Source Primary Key, if available): Shows the source columns and their order in the source’s PK.

  • Key+: the list and order of columns to define the index for sort data extractions, if applicable.

  • Source column name.

  • Source Data Type.

  • Force: This forces the load of a source data column into a varchar(max) column. This is helpful in some SQL failures when loading data. For instance, a SQL datetime column only accepts certain date ranges, loading the source into a varchar(max) will import all values.

  • Dw Data Type: Allows users to change the data warehouse target data type. When the user changes the target dw data type, ETL+ will write/suggest a T-SQL Expression when needed.

  • Metadata: Users can write a description for each column for documentation purposes.

  • T-SQL Expression: Users can customize the T-SQL to apply transformations at the column level during the extraction process.