Home / Middleware / Oracle Data Integrator

7 Working with Unstructured Data and Complex Data

This chapters provides an overview of the Jagged component and the Flatten component. These components help you to process unstructured and complex data.

This chapter includes the following sections:

• Section 7.1, "Working with Unstructured Data"

• Section 7.2, "Working with Complex Data"

7.1 Working with Unstructured Data

Oracle Data Integrator provides a Jagged component that can process unstructured data. Source data from sources such as social media or e-commerce businesses is represented in a key-value free format. Using the jagged component, this data can be transformed into structured entities that can be loaded into database tables.

For more information using the Jagged component and KMs associated with it, see the following sections:

• Creating Jagged Components in Developing Integration Projects with Oracle Data Integrator

• Section D.3, "XKM Jagged".

7.2 Working with Complex Data

Oracle Data Integrator provides a Flatten component that can process input data with complex structure and produce flatten representation of the same data using standard data types. The input data may be in a database, in an XML, or any other source.

For more information using the Flatten component and the KMs associated with it, see the following sections:

• Creating Flatten Components in Developing Integration Projects with Oracle Data Integrator

• Section D.1, "XKM Oracle Flatten".

• Section D.3, "XKM Jagged".