ETL Pre Actions

There are certain actions that you may want to perform before the execution of source components. A Pre Action tab is available at the source.

These actions could be performed on the Source:

SQL #

Option to execute SQL at source level during runtime. The source will fetch results based on the query and connection details provided in the Pre Action tab.

Stored Procedure #

Option to invoke a stored procedure or function stored in a database. To do so, an appropriate JDBC connection should be provided.

Further, as per the established connection the relevant Stored Procedure or Function that needs to be invoked should be selected from the drop-down menu.

Ignore Action Error #

The Ignore Action Error option is available so that even if for some reason the action configured fails to execute, the pipeline runs without getting impacted.

Ignore While Execution #

The Ignore While Execution option is available to keep only the configuration intact in the pipeline, but the configured action will not get executed.