Adding files to the catalog
Dataedo allows you to automatically scan, extract, and add to the catalog structure of JSON, XML, and other file formats.
First, you need to add a JSON document to the catalog. Click on the database in the repository navigator, choose Add Object, and Add/Import Structure.
There are 3 ways to add a file:
- Pasting content manually
- Choosing a file from the disk
- Designing structure manually
Paste manually
Let's have a look at the Paste Document option:
When a new window appears, paste any JSON document from the column. It should be representative, i.e., have all (or the majority) of the fields. If it's a correct document, then you will notice that Dataedo detects the format as JSON. Click Import to add the structure of the document.
Dataedo will open a window with the structure of the parsed document. This is where you can modify it (it will also be available after you add it to the repository) - add, rename, or remove fields or change types. Provide a name for the structure - it is a good practice to include the format, e.g., event_type.json.
Now you can save the new structure to the repository.
This will create a new folder named Structures with the newly added structure. You can browse their fields just as you do for any other objects. You can also document the fields using description, title, or custom fields.
Import from file
The second option, Import from File, allows you to select a file from the disk.
Simply point to the file and wait for Dataedo to determine the format. You can also enforce it manually by selecting it from one of the options at the bottom of the screen. When ready, click Import to scan the file.
If the file was successfully scanned, it will show the schema in the designer. You can now save it in the repository.
