0 / 0
Schema management (JSON) in DataStage

Schema management

Before you can use the Hierarchical Data stage to parse or compose JSON data, you must import a JSON data instance that describes the data into the metadata repository. Use the Schema Library Manager to import JSON files into the metadata repository and to organize them into libraries that can be shared across all DataStage projects.

After you import a JSON data instance, the schema library manager automatically validates the instance to determine whether the data contains any errors. If the data instance is valid, the schema library manager creates a schema in the metadata repository to describe the data types and structures in the instance. Click Browse to open the library to view the imported schema and to browse the type structure of the schema. You use these types to define the JSON processing in the Hierarchical Data stage.

When you create a library, you specify a unique name for the library and an optional folder name. Library names must be unique across all categories. Organizing libraries into categories ensures that you can later locate a specific library.

Within a library, you cannot repeat the same global type definition; however, two different libraries can have the same type definition. Each library can be used to import only one JSON data instance.

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more