/* Style the new user link */ .new_user_link { justify-content:flex-end; margin-left:10px; margin-right:0; margin-top:auto; margin-bottom:auto; #CD1CEE } /* START CSS to ensure page is fully loaded before displaying body. JS in Global Code toggles it on */ body {​​​​​​​ visibility: hidden; }​​​​​​​ body.show {​​​​​​​ visibility: visible; }​​​​​​​ /* END CSS to ensure page is fully loaded before displaying body. JS in Global Code toggles it on */
Connect ETL: The Basics

Connect ETL: The Basics

This hands-on workshop introduces participants to Connect ETL features including how to build and run data integration jobs that read and write data to/from a variety of data stores

About this course

This 6 hour, online, hands-on workshop introduces participants to the basic features of Connect ETL (Formerly known as DMX) and is intended for customers that have purchased Connect ETL. Participants are presented with the key benefits and will learn how to handle various data sources such as fixed length and delimited files.

Participants will learn how to create jobs as well as tasks using transformations such as copy, sort, join, merge, aggregate, reformat, filter and partition. Participants will also learn how to deploy the jobs that they have developed.

Curriculum02:28:21

  • Before you begin: rebranding information
  • Virtual Lab
  • How to Access a Remote Lab Environment.pdf
  • Videos and Lessons

    DMX and DMX-h have been rebranded to be part of the new Connect family of products.

    DMX is now known as Connect ETL and DMX-h is now Connect for Big Data.

  • Jobs and tasks 00:12:13
  • How to handle sources and targets 00:07:14
  • Data delimited files 00:20:30
  • LESSON_1_SETUP_JOBS_AND_TASKS.pdf
  • Transformation overview
  • How to define a copy 00:08:01
  • How to define a sort 00:07:32
  • How to define a reformat 00:16:51
  • How to define a filter 00:07:21
  • LESSON_2_REFORMAT_AND_FILTER.pdf
  • How to define a merge 00:04:49
  • How to define a partition 00:08:40
  • LESSON_3_SPLITTING_DATA_FOR_MAILINGS.pdf
  • How to define a join 00:09:01
  • Join task vs lookup function 00:02:41
  • How to define a lookup 00:12:00
  • LESSON_4_HOW_TO_DEFINE_A_JOIN.pdf
  • How to define an aggregate 00:13:28
  • LESSON_5_HOW_TO_DEFINE_AN_AGGREGATE.pdf
  • How to run jobs 00:18:00
  • LESSON_6_HOW_TO_DEFINE_MAINFRAME_DATA_AS_SOURCE.pdf

About this course

This 6 hour, online, hands-on workshop introduces participants to the basic features of Connect ETL (Formerly known as DMX) and is intended for customers that have purchased Connect ETL. Participants are presented with the key benefits and will learn how to handle various data sources such as fixed length and delimited files.

Participants will learn how to create jobs as well as tasks using transformations such as copy, sort, join, merge, aggregate, reformat, filter and partition. Participants will also learn how to deploy the jobs that they have developed.

Curriculum02:28:21

  • Before you begin: rebranding information
  • Virtual Lab
  • How to Access a Remote Lab Environment.pdf
  • Videos and Lessons

    DMX and DMX-h have been rebranded to be part of the new Connect family of products.

    DMX is now known as Connect ETL and DMX-h is now Connect for Big Data.

  • Jobs and tasks 00:12:13
  • How to handle sources and targets 00:07:14
  • Data delimited files 00:20:30
  • LESSON_1_SETUP_JOBS_AND_TASKS.pdf
  • Transformation overview
  • How to define a copy 00:08:01
  • How to define a sort 00:07:32
  • How to define a reformat 00:16:51
  • How to define a filter 00:07:21
  • LESSON_2_REFORMAT_AND_FILTER.pdf
  • How to define a merge 00:04:49
  • How to define a partition 00:08:40
  • LESSON_3_SPLITTING_DATA_FOR_MAILINGS.pdf
  • How to define a join 00:09:01
  • Join task vs lookup function 00:02:41
  • How to define a lookup 00:12:00
  • LESSON_4_HOW_TO_DEFINE_A_JOIN.pdf
  • How to define an aggregate 00:13:28
  • LESSON_5_HOW_TO_DEFINE_AN_AGGREGATE.pdf
  • How to run jobs 00:18:00
  • LESSON_6_HOW_TO_DEFINE_MAINFRAME_DATA_AS_SOURCE.pdf