Connection - a way to connect to external data sources. In order to perform data integration operations, you first need to create a connection.
Listener - a special type of connection which is "listening" for a specific event, for example, an inbound HTTP request, which then triggers the execution of data integration flows. Listeners allow the user to create event-driven flows.
Format - a data exchange format, such as CSV, JSON, Excel, etc. When data objects are involved, for example when working with web services or files, you need to describe all the formats required for the data exchange.
Flow - a data integration flow, which combines one or more transformations.
Event-driven flow - flow executed when a certain event occurs and the listener receives an event.
Schedule - a way to automatically execute flows, based on pre-configured time intervals.
Transformation - a source-to-destination transformation.
Source - the FROM part of a source-to-destination transformation.
Destination - the TO part of a source-to-destination transformation.
Mapping - the mapping between fields in the source and fields in the destination.
High-level transformation - a transformation of the entire dataset, which is performed as a single operation, for example, deduplication.
Dimension - the inner dataset in a complex data object.
Well-known API - the API for which Etlworks has a built-in connector, for example, Marketo, Salesforce, etc.
Parametrization - a way to dynamically configure connections and transformations based on input parameters. The input parameters can be Global variables or Flow variables.
Flow variables - key-value pairs that are passed as URL parameters in the user-created API endpoints or added by the user as parameters in the nested flow.