The April 2025 release of Data Integration includes the following new features and enhancements.
Field name length
Mappings, mapplets, and mapping tasks now accommodate longer columns and field names to support up to 255 characters.
For more information, see Mappings.
Field selection
You can use multiple criteria when you search for fields in a transformation.
Hierarchical mappers
You can use the following new features and enhancements for hierarchical mappers:
•Use an intelligent structure model as the source schema.
•Create a simplified target schema using the source schema.
•Search for elements in the source and target schemas.
•Reference elements from the source or target schema in the expression editor.
•Run hierarchical mappers on the Hosted Agent.
For more information, see Components.
Intelligent structure models
This release includes the following enhancements for intelligent structure models:
•You can configure a Large Language Model connection to connect to Azure OpenAI and use the chat model to process and interpret unstructured data within an intelligent structure model.
•You can combine multiple output groups into a single group when you generate normalized hierarchy relationships. This allows the data to be written to a single target resulting in streamlined data processing.
•You can use an intelligent structure model to parse scanned PDF files.
•You can use a custom AI engine to determine the underlying patterns and structures of the input file and create a model that you can use to transform, parse, and generate output groups.
For more information, see Components.
Source control
This release includes the following source control enhancements:
•You can compare additional source-controlled assets in your Git repository. When you commit the following Data Integration assets to your Git repository, Data Integration generates a JSON file with a vc.json extension that you can use to compare the versions:
- Data transfer task
- Dynamic mapping task
- Linear taskflow
- Replication task
- Synchronization task
- Mapping task
- Mapping
- Mapplet
- User-defined function
- Fixed-width component
- Saved query
- Shared sequence
•You can use a cloud-hosted GitLab repository for source control.
For more information, see Asset Management.
String functions
Use the string function UUID_String to create globally-unique IDs for vectors that you write to a vector database.
For more information, see Functions.
Taskflows
You can now use the following types of Data Ingestion and Replication tasks to invoke a taskflow:
•Application Ingestion and Replication tasks
•Database Ingestion and Replication tasks
When you publish a taskflow using the above tasks as the event source, the taskflow subscribes to the task that is defined in it. After you deploy the task, when an event occurs, the task invokes the taskflow.
For more information, see Taskflows.
Transformations
The following transformations have enhancements this release:
•When you configure a Hierarchy Builder transformation in a mapping, you can assign the decimal data type field as a primary key or foreign key.
•When you configure a Normalizer transformation in a mapping, you can create group-level fields with nested levels to normalize multiple-occuring groups of fields in each source row.