Skip to content

Job - Definition

Admin

application database > ETL > Job >

The definition of standard jobs is locked. For these records, the icon is visible in the first column of the table.

The job can be executed:

Purpose of the page

This page allows you to configure custom ETL jobs and view standard ETL jobs

Buttons on the page

Element Description
This filters the data shown on the page.
Adds a row in order to insert a new element
This duplicates the selected row with all the information inserted, except for the code.
Deletes the element contained in the selected row.
Enables/Disables the grid modify function. This allows you to change the characteristics of the selected elements directly in the table, and to hide the configuration tabs.
Enables multi-row selection to allow mass changes.
Selects the columns to be shown/hidden in the table and those to be locked when scrolling the table.
Exports the data in Excel format so they can be edited and reimported into CCH Tagetik.
Imports data from a previously prepared Excel file.
If only one record is selected, the actions button enables the following utilities: Reset: deletes the job data related to one of these options: - all user restrictions - ETL execution plans for all processes Note: To run the operation, at least one element to be deleted must be selected. Copy from: copies (in overwrite mode) the data related to the following job uses onto the selected job, in addition to the entire active default configuration: - user rights, - the ETL execution plans of all processes To run the operation, it is necessary to indicate the source job from which to copy. Connectors: allows you to automatically generate a comprehensive setup of ETL domains and routines that allow data to be loaded onto CCH Tagetik from one of the relative sources: - SAP© Connector Wizard - AX 2012 Connector Wizard - AX 2012 R2 Connector Wizard - NAV 2013 R2/2015/2016 Connector Wizard

Attributes tab

Field/box Description
Code Identifies the job code
Description description of the job. Mandatory
Details allows you to define the job details via the following links: - Routines - Parameters - Extractions Note: Links only active if a single job is selected.
Endpoint/Tagetik Data Loader indicates a remote resource on which the files created by any loading task that uses a Data Target: Other must be saved. You can indicate either a Endpoint or a Tagetik Data Loader.
Directory indicates the directory in which the files created by any loading task that uses a Data Target: Other must be saved. If an Endpoint/Tagetik Data Loader is also specified, the specified directory will be shown as a sub-directory of the selected remote resource; however, if the user only defines the Directory field, then it will mean the absolute or relative path visible by the Application Server that must be indicated in the permitted directories To meet CCH Tagetik’s security requirements, the aforementioned directory must match or be a sub-folder of the one defined as the writable folder (set in system property “it.grupposervizi.easy.impexp.writableFolder”) or if that property is not defined, it must match the one defined in the java tmp path. If, in the knowledge that it will compromise the software’s security, you want to use different directories, you must activate the Allow ETL to read or write to directories other than the one that is configured as secure option present in the Advanced section of the data model’s general configuration.

Relationships tab

This tab allows you to view and edit the nodes of the grouping to which the selected job is related.

Field Description
Nodes Every new job inserted will be automatically associated with the grouping nodes identified as to be related by default.