Here are the main principles of ETL solution:
ETL supports multiple data formats as input. Text, logs, images, videos, sounds—all your data can be processed and extracted.
ETL can also connect to any source to retrieve data. Database connectors, ERP/CRM connectors, support for numerous file extensions, and other unusual source readers are included in the solution.
Data collection is performed through a catalog of various input actions. Please refer to the catalog in the input actions list.
ETL provides more than 400 actions to perform all types of transformations. Data cleaning, text normalization, video extraction, web service consumption, and ML/AI inferences are just a few examples of the capabilities offered by the solution.
ETL also offers actions scripting capabilities. Based on Bash, Python or R language templates, users can create custom transformations to meet their specific processing needs. Custom actions are added to the action catalog and belong to their creator.
All these transformation are designed to format heteregoneous data into a comprehensive format exploitable by third-party applications. Please refer to Transformation and Cloud actions catalogue for more inforamtion.
ETL pipeline can load transformed into multiple data location. Store it into relational or non relational databases, generate output file, send mail or call web services are few example of the possibilities offered by the solution. Please refer to Output Actions list for more information.