Hi,
I need to include a JSON File as a source in ODI 12c.
I got an (n)XSD file and the JSON file.
I tried to use the complex file driver which should be able to read JSON files in ODI12, but I can't get a connection.
JDBC Driver: oracle.odi.jdbc.driver.file.complex.ComplexFileDriver
jdbc URL:jdbc:snps:complexfile?f=<Filelocation>&d=<DescriptiveFileLocation>&tt=json&re=root
When I use the descriptive file as I got it (json format), i get the error:
oracle.xml.parser.schema.XSDException: start of root element expected
When I convert the descriptive File into an XML format I get the error:
oracle.xml.parser.schema.XSDException: Element 'root' not expected
I also tried both descriptive files with and without the tt=json parameter.
I think I have somesystematic error
Is there a howto documentation about including JSON Files as sources in ODI or anyone who has experience in doing this?
Thanks
Martin