Additional Features of ETL

The inherent flexibilities within ETL functionalities not only contribute to heightened adaptability but also serve as a key catalyst in capturing comprehensive insights into the usage dynamics of each execution, amplifying its utility and effectiveness.

The additional functionalities includes.

Run With Data

The Run With Data helps to pass additional data to the ETL before the execution starts. It consists of different parts which includes.

SObject

This helps to send a Record Id for a particular SObject.

Type

There are various types based on which the execution can happen. The types are

ETL

This is where the execution takes place starting from the Extract, Transform and Load. This is set as the default one.

Extract

The execution takes place only on the Extract Part.

Transform

The execution takes place only on the Transform. The data which needs to be transformed can be sent from the Custom JSON part of the Run with Data.

Load

The Load can take place independently by taking the data from custom json.

Extract and Transform

The user can extract the data from the selected data sources and transform the data based on the requirement. This excludes the Load part for ETL.

Transform and Load

Transform the Custom JSON data from run with data and use the same transformed data on the Load excluding extracting data from the ETL.

Custom JSON

This section holds on the add-on JSON for the ETL execution which can be used on ETL’s various types.

Advanced Setting

The advanced setting for ETL provides two functionalities which includes.

Logging Level

The logging level provides the functionality to get the execution log for the ETL and it also helps to get the stack trace of the transaction.

Email

Here the user needs to enter the email where they will get the notifications from the ETL execution.

With these final insights, we gracefully conclude the ETL process, having navigated through its intricacies and harnessed its transformative capabilities to empower informed decision-making and unlock the full potential of our data ecosystem.