Cosmos DB to Readable SQL

abhish

Hello,

Has anyone yet used Cosmos db in Experian? We are trying to denormalize cosmos db into SQL; Is there a way in Experian we can transform the cosmos data to readable sql?

Henry Simms

Hi @abhish

It sounds like you've got JSON documents in a Cosmos DB for NoSQL instance and you want to get them into a flattened / normalized structure?

I've mentioned in an earlier post that I've used the 3rd party CData JDBC driver in Aperture to load json docs from Cosmos.

Another option I've not tested myself would be to use Aperture's built-in Autonomous REST connector to talk to the Cosmos DB API, for example to list documents.