Table 3. ETLCL specification of an ODI ETL process.

TEST_CONFIGURATION1.CREATE_CONFIGURATION(

ETL_TOOL:ODI,

ETL_TOOL_V:"12c",

ETL_SERVER_ADDRESS: "localhost",

ETL_SERVER_OS: LINUX,

DWH_DB: ORACLE,

DWH_DB_V: "19.1.0",

DWH_DB_ADDRESS: "localhost",

DWH_DB_OS: LINUX,

DWH_DB_AUTH: "username:***,pass:**",

ENVIRONMENT: "TEST Architecture",

ENVIRONMENT_DESC: "Test architecture for ETLCL language"

);

….

Grupa1.CREATE_TASK(

TASK_UNIQUE_ID: T1,

TASK_NAME: "TABLESPACE_CHECK 001",

AGENT_NAME: ORACLE_PROCEDURE,

PARAMETERS: INSTANCE: "agent_jco_npc",

);

….