that thing

we do

frends has more features than any other integration software out there. Explore, ideate, and if anything is unclear - hit us up at any time. This library is bound to grow over time.

Extract, Transform and Load

frends has excellent ready-made capabilities for ETL integration scenarios and can process data in almost any format, including JSON, XML, CSV, Flat File, Fixed Width, EDI and so on.

ETL integration scenarios are implemented by orchestrating the steps of ETL using the Orchestration capabilities of frends so that the initial activity in the sequence is the extraction or parsing of the incoming data, adding in logic or activites to transform the data and finally loading or sending the data to the target system or interface:

Green = Extract Phase

Blue = Transform Phase

Purple = Load Phase

Organe = Error Handling

frends ETL EDI Process Example

Supported Extract Formats

FRENDS implements the extract functionality utilizing the standard frends Tasks and has out-of-the-box support for:

  • XML
  • JSON
  • CSV
  • Fixed Width
  • Flat File
  • Custom text format
  • EDIFACT

Supported Transform Functionality

To transfrom the parsed or extracted data you can utilize the native frends low-code approach to programmatically map and apply the transformations or choose from other well known and standardized approaches such as XSLT or JSONMap.

frends Low-Code Approach

Using this approach the source data or Extract phase always generates JSON which can then be accessed using the low-code approach:

FRENDS ETL Low-Code Example

Example of the low-code transformation in the above process. FRENDS Low-Code Transformation Example

Usually utilizing the low-code approach requires you to loop through the dataset using loops in the process orchestration. The main benefits of utilizing the low-code approach are:

  • Combine transform and load phases into a single step
  • Complete visibility into the processing and every step taken
  • Complete control over data manipulation using C#
  • Blazing fast executions through compiled code

XSLT or JSONMap

Alternative approach to utilizing the low-code approach is to utilize Standard frends tasks for XSLT or JSONMap transformations where the input for the data is the extracted data and the output of the task is the transformed data ready to be loaded:

frends Example XSLT ETL Process

Extract, Transform and Load

frends has excellent ready-made capabilities for ETL integration scenarios and can process data in almost any format, including JSON, XML, CSV, Flat File, Fixed Width, EDI and so on.

ETL integration scenarios are implemented by orchestrating the steps of ETL using the Orchestration capabilities of frends so that the initial activity in the sequence is the extraction or parsing of the incoming data, adding in logic or activites to transform the data and finally loading or sending the data to the target system or interface:

Green = Extract Phase

Blue = Transform Phase

Purple = Load Phase

Organe = Error Handling

frends ETL EDI Process Example

Supported Extract Formats

FRENDS implements the extract functionality utilizing the standard frends Tasks and has out-of-the-box support for:

  • XML
  • JSON
  • CSV
  • Fixed Width
  • Flat File
  • Custom text format
  • EDIFACT

Supported Transform Functionality

To transfrom the parsed or extracted data you can utilize the native frends low-code approach to programmatically map and apply the transformations or choose from other well known and standardized approaches such as XSLT or JSONMap.

frends Low-Code Approach

Using this approach the source data or Extract phase always generates JSON which can then be accessed using the low-code approach:

FRENDS ETL Low-Code Example

Example of the low-code transformation in the above process. FRENDS Low-Code Transformation Example

Usually utilizing the low-code approach requires you to loop through the dataset using loops in the process orchestration. The main benefits of utilizing the low-code approach are:

  • Combine transform and load phases into a single step
  • Complete visibility into the processing and every step taken
  • Complete control over data manipulation using C#
  • Blazing fast executions through compiled code

XSLT or JSONMap

Alternative approach to utilizing the low-code approach is to utilize Standard frends tasks for XSLT or JSONMap transformations where the input for the data is the extracted data and the output of the task is the transformed data ready to be loaded:

frends Example XSLT ETL Process