question Re: How to load data from Azure CosmosDB using Apache NiFi? in Support Questions

How to load data from Azure CosmosDB using Apache NiFi?

Sivaluxan — Fri, 14 Jul 2023 08:52:56 GMT

I need to load the data from Azure Cosmos DB.

I am using Nifi 1.21.0 Version.

what is the way to do that?

Re: How to load data from Azure CosmosDB using Apache NiFi?

cotopaul — Wed, 26 Jul 2023 11:21:51 GMT

@Sivaluxan,

You need to connect to Azure Cosmos DB and extract data from there? If so, you can use an ExecuteSQLRecord processor and configure the DBCPConnectionPool to connect to your AzureCosmosDB, using the appropriate Class Path, the appropriate JDBC and the appropriate security (keys, users, password, whatever you are using)

Re: How to load data from Azure CosmosDB using Apache NiFi?

Sivaluxan — Thu, 27 Jul 2023 02:34:32 GMT

@cotopaul can you share the link to download azure cosmos db JDBC driver?

Re: How to load data from Azure CosmosDB using Apache NiFi?

cotopaul — Thu, 27 Jul 2023 10:02:54 GMT

@Sivaluxanif I am not mistaken, you need to download the JDBC of the database you are using in azure cosmos db.

I am no expert in Azure, but as far as I know you have NoSQL, MongoDb, Cassandra, Gremlin and PostgreSQL. You first need to identify the DB you are connecting to, download the JDBC to that specific database and proceed next from there.