Transformation techniques

Effective data transformation is crucial for preparing your data to meet specific business requirements. Workato provides various methods to transform data efficiently and accurately. This section introduces you to the different transformation techniques available, ensuring you can choose the best approach for your needs.

Built-in formulas for simple transformations

Workato offers a wide range of built-in formulas suitable for performing simple data transformations. These formulas simplify common data manipulation tasks, allowing you to quickly prepare your data for further processing or analysis.

The following data types are supported:

• String

• Integer or number

• Date or datetime

• Array/hash (list)

• Complex data types.

Custom code transformations

For more complex transformation needs, Workato supports custom code transformations. This feature allows you to write custom scripts to handle specific data manipulation tasks that are not covered by built-in formulas. You can use the following languages:

• Ruby
• Python
• JavaScript

SQL-based transformation

Workato enables you to perform SQL-based transformations on your data. This method is powerful for integrating with database connectors and leveraging the full capabilities of SQL. For more information, refer to our SQL-based transformations section.