I need to transfer On premises file (in hdfs) to AWS3 using Nifi, what are the processors you're using to complete the task? ... View more

@Kasun, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

Hi @Shu_ashu  I have the neir input and i want to extract all attributes but i can't got the attributes in the arrays. i have try the jolttransformation processor but no ok Please can you help me [{ "Num_client__c": "3456", "Code_etablissement__c": "4562", "Mode_de_retrait__c": "xx", "OrderNumber": "000001", "Commande_en_stock__c": "y", "Commande_payee__c": "y", "Montant_Commande_TTC__c":"3000", "Status":"En cours", "OrderedDate": "2021-02-20", "Date__c": "2021-02-21", "Heure_de_debut__c":"10:24", "Heure_de_fin__c": "11:15", "shipping_address": [ { "ShippingStreet": "4 Allé du bois", "ShippingPostalCode": "75008", "ShippingCity": "Paris" } ], "orderItems_request": [ { "Code_Base_Produit__c": "AG45", "Quantity": "75", "UnitPrice": "30" }, { "Code_Base_Produit__c": "FF34", "Quantity": "75", "UnitPrice": "20" } ] }, { "Num_client__c": "3456", "Code_etablissement__c": "4562", "Mode_de_retrait__c": "xx", "OrderNumber": "000002", "Commande_en_stock__c": "y", "Commande_payee__c": "y", "Montant_Commande_TTC__c":"3000", "Status":"En cours", "OrderedDate": "2021-02-20", "Date__c": "2021-02-21", "Heure_de_debut__c":"10:24", "Heure_de_fin__c": "11:15", "shipping_address": [ { "ShippingStreet": "4 Allé du bois", "ShippingPostalCode": "75008", "ShippingCity": "Paris" } ], "orderItems_request": [ { "Code_Base_Produit__c": "AG45", "Quantity": "75", "UnitPrice": "30" } ] } ] ... View more

If you don't care about Avro format and want to go directly to JSON you can use the ExecuteSQLRecord processor where you can specify the output format.  ... View more

You connect to H2 database like any other database using JDB connection. Here is the link where you can find H2 driver and documentation. www.h2database.com/html/download.html   By the way, I have also uploaded a video explaining step by step process on connecting to NiFi H2 database. You may check it out here.  https://www.youtube.com/watch?v=tsAR2f4uGK4 ... View more

@Adrian Oprea Thanks for your answer. I fixed the issue already. My post above was using the same naming of xx.jks file in the share drive and not suppose in this way. I just placed each of the host's jks on local drive (node1.jks, node2.jks, node3.jks) and set 'StandardRestrictedSSLContextService' with one of them. So I used node1.jks. Worry about other nodes not recognize? No worried, nifi site to site will handle this and it worked fine for me. ... View more

yeah i know is not very intuitive 🙂 ... View more

That works perfectly! Thanks! ... View more

Thanks Adrian Oprea ... View more

Hi @Vikas Singh , SplitJson Processor is used to split Json Array and EvaluateJsonPath is used to extract Json fields as attribute or content. In your case: Step 1:Use EvaluateJsonPath Processor to extract info fields of Json. For example: is you want to extarct info fileds: .$info.seed,.$info.page,.$info.version,.$info.results and save it as Flowfile Attribute. Step 2:Use SplitJson Processor :$.results Step 3:USe EvaluateJsonPath Processor to extract Json Array fields. ... View more