17.6.1 Adding XML, CSV, JSON Data Load Definitions

Add Data Load Definitions for XML, CSV, and JSON files that all load into the same target table.

By running through the Create Data Load Definition wizard three more times, using the XML, CSV, and JSON files from Exploring External Data Examples, you can add the following additional shared components to your initial one for Excel spreadsheets:

• Load Employees from XML with Static ID load_employees_from_xml
• Load Employees from CSV with Static ID load_employees_from_csv
• Load Employees from JSON with Static ID load_employees_from_json

As shown below for the JSON file example, even though each file uses different nomenclature for the fields, they all target the EBA_DEMO_EMP table, so their Map To columns are the same.

Figure 17-21 Creating a Data Load Definition for an Example JSON File

Description of "Figure 17-21 Creating a Data Load Definition for an Example JSON File"