DataConnect Core Exercises (self-paced)

DataConnect Core Exercises (self-paced)

The DataConnect Core Exercises course will supply the user with detailed examples that use core components and mapping techniques of the Map Editor, Process Workflow Editor, and Integration Manager. The exercises are task-based which illustrate a variety of techniques applicable to the majority of integration scenarios you may encounter.

About this course

At the end of this course you will be able to:

Build maps, schemas, complex workflow processes and be able to package and deploy your projects via command line .bat files using your in-house scheduler or via the Actian Integration Manager.

You will have the knowledge to build maps using lookups, aggregation, constants, scripting, validation, multimode connectors, hierarchical mapping techniques, reject targets, conditional outputs, intermediate targets, script libraries, calling methods from external libraries, joined sources, and much more.

Build complex workflow processes that use parallel processing, loops, queues, Invokers, error handling, code modules, sub-processes, dynamic techniques, and more. You will be able to make web service requests and use the responses in a map, send email notifications, and  use other message components included with the Process Editor.

Parse unstructured or semi-structured data like reports, log files, print image files using the Extract Editor and be able to feed the resulting schema into a transformation map.

Automate your jobs using command line bat files or using Integration Manager. Use the Integration Manager File Folder Listener or API to configure jobs to run in real time.

 

Course Style and Content:

This course covers the following topics:

Constants, Scripting, Validation, Reject Target – A look at how and when to use Constants, an introduction to the EZscript Editor, validating records, writing invalid records to a separate reject target.

Aggregation_and_Sorting – How to sort the source records before processing. How to use the built-in aggregation functions to find metrics such as Count, Average, Min, Max, and Sum.

Multimode_and_IncoreLookup – Multimode connectors allow you to write the source data to multiple database objects with different target modes or operations (insert, update, or delete) within the same map. Using a lookup intermediate target.

XML Source Mapping – Hierarchical mapping techniques with XML as a source. Lookup using a file.

XML Target, Query File Update and Schema - Hierarchical mapping techniques with XML as a target. Using a Query File and updating it. Updating a schema.

Intermediate Targets – How and when to use Intermediate Targets demo. Explanation of how multiple record type schemas work.

Web Service API Invoker – Demo of using the DataConnect WebService API Invoker for REST and SOAP calls. Send the SOAP response message to a map.

Join Sources – a walkthrough of creating a single joined source in a map from two dissimilar source connections.

Dynamic Techniques – Demo of using various techniques to make a transformation map dynamic. Includes the DJX function to make a query dynamic and DefineMacro() function to define a target. Also uses an EZscript Library (code module).

FTP Queue, Send Email, Looping Workflow – Build a process workflow that loops through files on an FTP site using the FTP Queue component and uses the SMTP Invoker to send an email.

Package, Deploy, and Command Line Usage – Create a package and Deploy it. Command Line usage for automating the running of maps, processes, and djar packages.

Extract Editor – a walkthrough of the Extract Editor to extract data from a semi-structured report and feed to a map.

Integration Manager and File Folder Listener – Creating a Template and Configuration from a package using Integration Manager (IM). A demo of using the IM’s File Folder Listener to kick off a job when a file shows up in a folder.

Calling External Code Libraries – Build a process that uses methods from a Java class jar file.

 

Prerequisites:

Completion of the Actian DataConnect Platform Overview course

Curriculum306 min

  • Exercise_1 – Constants, Scripting, Validation, Reject Targets 22 min
  • Exercise_2 – Aggregation and Sorting 8 min
  • Exercise_3 – MultiMode Targets and Lookups 32 min
  • Exercise_4 – XML Source Mapping 27 min
  • Exercise_5 – XML Target Mapping, Query File, Updating Query, and Schemas 18 min
  • Exercise_6 – Intermediate Targets 21 min
  • Exercise_7 – Web Service API Invoker 29 min
  • Exercise_8 – Join Multiple Sources 7 min
  • Exercise_9 – Dynamic Techniques 26 min
  • Exercise_10 – FTP Queue, Send Email, Looping Workflow 26 min
  • Exercise_11 – Package, Deploy, and Command Line Usage 20 min
  • Exercise_12 – Extract Editor 28 min
  • Exercise_13 – Integration Manager and File Folder Listener 28 min
  • Exercise_14 – Calling External Code Libraries 8 min
  • Feedback
  • Take Course Survey

About this course

At the end of this course you will be able to:

Build maps, schemas, complex workflow processes and be able to package and deploy your projects via command line .bat files using your in-house scheduler or via the Actian Integration Manager.

You will have the knowledge to build maps using lookups, aggregation, constants, scripting, validation, multimode connectors, hierarchical mapping techniques, reject targets, conditional outputs, intermediate targets, script libraries, calling methods from external libraries, joined sources, and much more.

Build complex workflow processes that use parallel processing, loops, queues, Invokers, error handling, code modules, sub-processes, dynamic techniques, and more. You will be able to make web service requests and use the responses in a map, send email notifications, and  use other message components included with the Process Editor.

Parse unstructured or semi-structured data like reports, log files, print image files using the Extract Editor and be able to feed the resulting schema into a transformation map.

Automate your jobs using command line bat files or using Integration Manager. Use the Integration Manager File Folder Listener or API to configure jobs to run in real time.

 

Course Style and Content:

This course covers the following topics:

Constants, Scripting, Validation, Reject Target – A look at how and when to use Constants, an introduction to the EZscript Editor, validating records, writing invalid records to a separate reject target.

Aggregation_and_Sorting – How to sort the source records before processing. How to use the built-in aggregation functions to find metrics such as Count, Average, Min, Max, and Sum.

Multimode_and_IncoreLookup – Multimode connectors allow you to write the source data to multiple database objects with different target modes or operations (insert, update, or delete) within the same map. Using a lookup intermediate target.

XML Source Mapping – Hierarchical mapping techniques with XML as a source. Lookup using a file.

XML Target, Query File Update and Schema - Hierarchical mapping techniques with XML as a target. Using a Query File and updating it. Updating a schema.

Intermediate Targets – How and when to use Intermediate Targets demo. Explanation of how multiple record type schemas work.

Web Service API Invoker – Demo of using the DataConnect WebService API Invoker for REST and SOAP calls. Send the SOAP response message to a map.

Join Sources – a walkthrough of creating a single joined source in a map from two dissimilar source connections.

Dynamic Techniques – Demo of using various techniques to make a transformation map dynamic. Includes the DJX function to make a query dynamic and DefineMacro() function to define a target. Also uses an EZscript Library (code module).

FTP Queue, Send Email, Looping Workflow – Build a process workflow that loops through files on an FTP site using the FTP Queue component and uses the SMTP Invoker to send an email.

Package, Deploy, and Command Line Usage – Create a package and Deploy it. Command Line usage for automating the running of maps, processes, and djar packages.

Extract Editor – a walkthrough of the Extract Editor to extract data from a semi-structured report and feed to a map.

Integration Manager and File Folder Listener – Creating a Template and Configuration from a package using Integration Manager (IM). A demo of using the IM’s File Folder Listener to kick off a job when a file shows up in a folder.

Calling External Code Libraries – Build a process that uses methods from a Java class jar file.

 

Prerequisites:

Completion of the Actian DataConnect Platform Overview course

Curriculum306 min

  • Exercise_1 – Constants, Scripting, Validation, Reject Targets 22 min
  • Exercise_2 – Aggregation and Sorting 8 min
  • Exercise_3 – MultiMode Targets and Lookups 32 min
  • Exercise_4 – XML Source Mapping 27 min
  • Exercise_5 – XML Target Mapping, Query File, Updating Query, and Schemas 18 min
  • Exercise_6 – Intermediate Targets 21 min
  • Exercise_7 – Web Service API Invoker 29 min
  • Exercise_8 – Join Multiple Sources 7 min
  • Exercise_9 – Dynamic Techniques 26 min
  • Exercise_10 – FTP Queue, Send Email, Looping Workflow 26 min
  • Exercise_11 – Package, Deploy, and Command Line Usage 20 min
  • Exercise_12 – Extract Editor 28 min
  • Exercise_13 – Integration Manager and File Folder Listener 28 min
  • Exercise_14 – Calling External Code Libraries 8 min
  • Feedback
  • Take Course Survey