Skip to main content
Sivaluxan
Silver ⭐️⭐️⭐️
Jul 14, 2023 8:52 AM UTC
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
Platinum ⭐️
Jul 26, 2023 11:21 AM UTC

@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 ⭐️⭐️⭐️
Jul 27, 2023 2:34 AM UTC

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

 

Translate
cotopaul
Platinum ⭐️
Jul 27, 2023 10:02 AM UTC

@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