Get Started with Data Workbench

The Data Workbench has a visual editor that enables you to join data objects, apply filters and conditional logic, and create calculated and derived attributes. You can also define transformation sequences to prepare and enrich data before they run as part of the Data Warehouse job.

It provides the following benefits:

• Low-code, visual transformation design experience.
• Centralized management of transformation logic.
• Improved data quality through reusable business rules

Access Requirements

To create and manage Data Warehouse transformations, you must have one of the following roles:

Customer Data Platform Administrator	ORA_FMK_CUSTOMER_DATA_PLATFORM_ADMINISTRATOR
Customer Data Platform Manager	ORA_FMK_CUSTOMER_DATA_PLATFORM_MANAGER
Customer Data Platform Specialist	ORA_FMK_CUSTOMER_DATA_PLATFORM_SPECIALIST

Supported Functions

The transformation engine supports common SQL-style functions, including:

SQL-style	Function
String	CONCAT, LOWER, UPPER, TRIM, SUBSTR, REPLACE, LPAD, RPAD
Conversion:	TO_CHAR, TO_DATE
Mathematical	ABS, ROUND, CEIL, FLOOR, POWER, SQRT, MOD
Date/Time:	CURRENT_DATE, CURRENT_TIMESTAMP, ADD_MONTHS, EXTRACT, TRUNC
Conditional	CASE, COALESCE, NULLIF, IFNULL, GREATEST, LEAST

Supported Operators

Supported operators include:

• Arithmetic (+, -, *, /, %)
• Comparison (=, !=, >, >=, <, <=)
• Logical (AND, OR, NOT)
• SQL operators such as LIKE, IN, BETWEEN, IS NULL, and their negations.