Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI 12c - Complex File Type - JSON data server issues

3595094Nov 13 2018 — edited Nov 14 2018

I am using ODI v12.2.1.3.0 and my db version is 12.1.0.2.0 with the compatible parameter set to 12.1.0.

I am trying to create a data server from a complex file technology in ODI which is backed by a json file. I have the translate_type set to json.

When I try to generate the xsd (using the Native Format Builder) I get the error 'Schema generation failed. Failed to generate a schema from the sample JSON. cannot normalize!'

I've done quite a lot of reading and have the following questions:

1. I read that the json should be a single line - my json is a single line but is about 85000 chars long. Is this (part of) my problem?

2. I've also read that the json is a 12.1.0.2 feature and that the compatible parameter also needs to be set to 12.1.0.2 - is this my problem?

3. There also seem to be a few known issues ... if it's not my compatible parameter, I'm happy to raise an issue with Oracle.

I've tried using third party tools to generate the xsd (convert json to xml, and then generate xsd) which kind of works but it seems I can only test the connection once and subsequent attempts to test it result in SQLExceptions that the object name already exists. It also seems to negate the point of using the json (I'm using OdiInvokeRESTfulService successfully to get the json from my end point).

Any advice or links to trouble shooting documentation would be welcome!

Thanks

Alex

This post has been answered by Adrian_Popescu-Oracle on Nov 14 2018
Jump to Answer
Comments
Post Details