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.
