Data Discovery Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.2
- 10.5.1
- 10.5

Back Next

Creating a Data Object from a JSON or XML Data Source

You can create a flat file data object or complex file data object from a JSON or XML data source.

In the

Object Explorer

view in the Developer tool, select the project where you want to create the data object and column profile.

Click

File

New

Data Object

The

New

dialog box appears.

You can choose to create a flat file data object or complex file data object.

To create a flat file data object, perform the following tasks:

Select

Physical Data Objects

Flat File Data Object

, and click

The

New Flat File Data Object

dialog box appears.

Select

Create from an Existing Flat File

, and click

Browse

to choose the text file. Click

Verify that the code page is

MS Windows Latin 1 (ANSI), superset of Latin 1

, and the format is delimited. Click

Verify that the delimiter is set to

comma

. Click

Finish

To create a complex file data object, perform the following tasks:

Select

Physical Data Objects

Complex File Data Object

, and click

The

New Complex File Data Object

dialog box appears.

Enter a name for the data object. Select the access type as

File

Click

Browse

to choose a JSON or XML file. Click

Finish

When the Developer server is in Linux, you must update the file path of the data source to the location in the server. To update the file path, select the complex file data object, click

Read

in the

Data Object Operations

tab, and add the file path in the

Advanced

tab in the

Data Object Operation Details

pane.

The data object appears in the project folder.

JSON and XML Data Objects

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Data Discovery Guide

Data Discovery Guide

Creating a Data Object from a JSON or XML Data Source

Creating a Data Object from a JSON or XML Data Source