- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.5K On-Premises Infrastructure
- 137.7K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Reverse Engineer a JSON
I am executing a RESTful Service call for data and downloading a JSON file in the ATF8 character set in ODI 188.8.131.52
I have created a new complex file dataserver with physical and logical schema for this file, and have used ODI's native format builder to generate the required XSD file for this JSON file.
In the dataserver settings, I have filled in the value for dtd with the path to the xsd file (using the native formatter done this anyway), I have filled in the path to point to the JSON file. The compat mode is V3, the translator type is JSON, the root element and schema were defined during the format builder as root and xsdschema.
I've created a new model folder using the new logical schema, and attempted to reverse engineer the file but when I run either the reverse engineer, or the selective reverse engineer, nothing gets built in the model.
Can anyone suggest something I'm missing?
Note that I have 3 different JSON files, each configured with their own dataserver, and I'm having the same issue in all 3 instances.