I have various apps that store data in XML or JSON format. It also seems that XML or JSON files can be used as ODBC data sources. Can the data from such files be brought into IQ through the "synchronization with remote databases" procedure described in http://infoqubeim.com/drupal5/node/140 ??
How do I ?
Comments
I haven't tried but it…
I haven't tried but it should work, provided you find the proper 32-bit ODBC driver
Get back to us if you get it to work !
Do you want to import the…
Do you want to import the data once, or sync to it continuously? For a single import, perhaps you can convert it to CSV or Excel, for example using VS Code https://github.com/petli-full/json-to-yaml-and-more-vscode or Easy Data Transform https://www.easydatatransform.com/convert_xml_to_excel.html ?