India: +91 406677 1418

WhatsApp no. : +919100386313

USA: +1 909 233 6006

Telegram : +15168586242

jasper etl

Jasper Etl Course Content

Data integration and JasperETL
  • Data analytics
  • Operational integration
  • Execution monitoring
Getting started with JasperETL
  • Important concepts in JasperETL
  • Launching JasperETL
  • Accessing one or multiple Repositories
  • How to connect to a local repository
  • Setting up a Project in the Repository
  • Working with different workspace directories
  • Creating a new workspace directory
  • Connect  to a different workspace directory
  • Working with projects
  • How to create a project
  • How to import the Demo project
  • How to import a project
  • How to open a project
  • How to delete a project
  • How to export a project
  • Describing the GUI
  • Toolbar & Menus
  • Quick access toolbar
  • Menus
  • Repository tree view
  • Business Models
  • Job Design
  • Contexts
  • Codes
  • SQL Templates
  • Metadata
  • Documentation
  • Recycle bin
  • workspace Designing
  • Palette
  • personalizing the Palette layout
  • Using Palette
  • Configuration tab system
  • Job view
  • Components view
  • Run Job views
  • Error Log
  • Modules view
  • Open Scheduler view
  • Talend Exchange view
  • Problems view
  • Job Hierarchy view
  • Properties view
  • Outline & Code Summary panel
  • Outline
  • Code viewer
  • Setting JasperETL preferences
  • Perl OR Java Interpreter path
  • External or User components
  • Language preferences
  • Debug and job execution preferences
  • Designer preferences
  • Adding the code by default
  • Performance preference
  • Documentation preference
  • SQL Builder preference
  • Schema preference
  • Libraries preference
  • Type conversion
  • Customizing project settings
  • Palette Settings
  • Version management
  • Job Settings
  • Stats & Logs
  • Context settings
  • Project Settings use
  • Status settings
  • Security settings
  • Migration tasks
Designing a Business Model
  • Objectives
  • Opening or creating a business model
  • Opening a business model
  • Creating a business model
  • Modelling a Business Model
  • Shapes
  • Connecting shapes
  • Commenting & arranging a model
  • Adding a note or free text
  • Arranging the model view
  • Business Models
  • Appearance tab
  • Rulers & Grid tab
  • Assignment tab
  • Assigning Repository elements to a Business Model
  • Editing a business model
  • Renaming a business model
  • Copying & pasting a business model
  • Moving a business model
  • Deleting a business model
  • Saving a Business Model
Designing a Job
  • Objectives
  • Opening or Creating a Job
  • Opening a Job
  • Creating a Job
  • Getting started with a Job Design
  • Showing, hiding and moving the Palette
  • Click & drop components from the Palette
  • Drop components from the Metadata node
  • Adding Notes to a Job design
  • Changing panels position
  • Warnings and errors on components
  • Managing Job versions
  • Connecting components together
  • Connection types
  • Row connections
  • Iterate connections
  • Trigger connections
  • Link connection
  • Multiple Input/Output
  • Error icons on Jobs
  • Subjob colored highlight
  • Formatting subjobs
  • Collapsing the subjobs
  • Removing the subjob background color
  • Prejob & postjob parts
Defining the component properties
  • Basic Settings tab
  • Setting a built-in schema
  • Setting a Repository schema
  • Setting a field dynamically (Ctrl+Space bar)
  • Advanced settings tab
  • Measuring data flows
  • Dynamic settings tab
  • View tab
  • Documentation tab
Defining the Start component
Using SQL Templates
Defining Metadata items
Mapping data flows
  • tMap operation overview
  • tMap interface
  • Setting the input flow in the Map Editor
  • Filling in Input tables with a schema
  • Explicit Join
  • Inner join
  • All rows (java)
  • Filtering an input flow (java)
  • Removing input entries from table
  • Mapping variables
  • Accessing global or context variables
  • Removing variables
  • Mapping the Output setting
  • Building complex expressions
  • Filters
  • Rejections
  • Inner Join Rejection
  • Removing Output entries
  • Expression editor
  • Schema editor
  • Solving memory limitation issues in tMap use
  • Handling lookups
Writing code using the Expression Builder
Sharing a database connection
Creating queries using SQLBuilder
  • Database structure comparison
  • Building a query
  • Storing a query in the Repository
Defining Contexts & variables
  • Using variables in a Job
  • Defining variables on the Contexts view
  • Variables tab
  • Values as tree tab
  • Values as table tab
  • Configuring contexts
  • Creating a context
  • Renaming or editing a context
  • Defining variables from the Component view
  • Short creation of context variables
  • StoreSQLQuery
  • Storing contexts in the Repository
  • Creating a context group
  • Creating a context from a Metadata
  • Running a Job in selected context
Running a Job
  • Running in normal mode
  • Displaying Statistics
  • Displaying Traces
  • Displaying the execution time & other options
  • Running in debug mode
Managing Metadata & Context updates
  • Updating all Jobs automatically
  • Managing dependencies
Activating/Disabling a Job or sub-job
  • Disabling a Start component
  • Disabling a non-Start component
Saving or exporting your jobs
  • Saving a Job
  • Exporting Job scripts
Documenting a Job
  • Generating HTML documentation
  • Updating the documentation on the spot
Searching a Job in the Repository
Defining options on the Job view
  • Automating statistics & logs use
  • Extra features
Customizing the Palette
Shortcuts and aliases