Skip to main content
Sivaluxan
Sivaluxan
Silver ⭐️⭐️⭐️
July 14, 2023
Question

How to load data from Azure CosmosDB using Apache NiFi?

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?

3 replies

cotopaul
cotopaul
Platinum ⭐️
July 26, 2023

@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)

Translate
Sivaluxan
SivaluxanAuthor
Silver ⭐️⭐️⭐️
July 27, 2023

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

 

Translate
cotopaul
cotopaul
Platinum ⭐️
July 27, 2023

@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.

Translate
Terms & ConditionsAccessibility statement