topic Re: Incorta against No SQL database in Data & Schema Discussions

Incorta against No SQL database

prabhak — Fri, 04 Nov 2022 14:27:31 GMT

Hi - Has anyone tried Incorta schemas on NO SQL database like Mongo DB? can we use Incorta to pull JSON format data ?

Re: Incorta against No SQL database

KailaT — Mon, 07 Nov 2022 20:44:09 GMT

Hey @prabhak, I am still looking for the answer to this question but I will follow up shortly.

Re: Incorta against No SQL database

LukeG — Tue, 08 Nov 2022 03:02:58 GMT

Hi @prabhak ,

There are a few different ways to connect to data in a NoSQL database. The nature of the data source would determine the best approach.

For MongoDB specifically, we have a connector that leverages the MongoDB Connector for BI. Collections of documents are transformed into structured schemas to be stored in Incorta.

Please let us know if you have any other questions. Happy to help

Re: Incorta against No SQL database

ZachBreimayer — Tue, 08 Nov 2022 18:59:31 GMT

We do have a JSON connector available, I have used it personally several times. I would recommend reaching out to your Account Executive.

Re: Incorta against No SQL database

prabhak — Tue, 08 Nov 2022 20:50:18 GMT

Hello - can you please guide me a little more here?

Re: Incorta against No SQL database

amit_kothari — Thu, 10 Nov 2022 08:43:12 GMT

Hi -

Incorta supports CData JDBC driver for json as:

A pre-configured connector, e.g.: Jira, Smart Sheets, Oracle Sales Cloud, Cosmosdb, XML and JSON
- In this case, user only needs to enable the connector from the CMC (no restart needed).
  login in to cmc , go to clusters and then to the connector s tab and enable the json connector.
- Now create a json data connection in Incorta

Re: Incorta against No SQL database

prabhak — Thu, 10 Nov 2022 15:30:24 GMT

Hi - I don't find the connectors tab in CMC. Can you point me to the exact option name? Thank you