Join our Discord Server if you need Apache NiFi help - discord.gg/TcHK4AF7DA
@InsightByte
2 жыл бұрын
In this chapter we are going to learn How to connect Apache NiFi to different types of databases. *The entire series in a playlist:* kzitem.info/door/PLkp40uss1kSI66DA_aDCfx02gXipoRQHc **GitHub Repo** github.com/InsightByte/ApacheNifi/tree/main/Database-Connection **For Apache NiFi on AWS EC2 Setup go to** kzitem.info/news/bejne/0GhvyXmLZpmWnm0 **For Apache NiFi local Setup go to** kzitem.info/news/bejne/ommcvH6boYl4raA **Video Outline**: Timestamps: 00:00 Intro 1:07 Setup your Apache NiFi resources 2:19 Create the NiFi Process Group 3:30 Create NiFi Parameter Context used for DB connection 4:32 Create NiFi Database connection controller 6:25 How to query a database with ExecuteSQL **Quick Tips for better learning**: 1. Follow along as I explain to make sure you understand everything 2. Ideally, you should be able to replicate what I have done with success, if this is not the case reach-out - i will try to help/. 3. If you want to learn faster than I talk, I’d recommend 1.25x or 1.5x speed :) 4. Check the outline in the comment section below if you want to skip around. 5. Also keep an eye on the description and see if and links are available with reference docs or assets to download. 6. If anything is unclear, please let me know in a comment. 7. Make sure you Subscribe to my Channel and rate the Video with a LIKE nifi training | apache nifi template |apache nifi registry | expression language | apache nifi log setup | nifi expression language | nifi logging | apache nifi installation | apache nifi setup | apache nifi tutorial | apache nifi architecture |apache nifi course | apache nifi demo | apache nifi etl | apache nifi etl tutorial | apache nifi flow | apache nifi guide | apache nifi training | apache nifi commands | apache nifi examples | nifi import template | nifi create template
@oyeyemirafiuowolabi2347
2 жыл бұрын
Thanks for this. we have been on the lookout for more videos of yours.
@InsightByte
2 жыл бұрын
More to come!
@user-jp2qy4gk2u
7 ай бұрын
i dont get why but i get putdatabaserecord failed to put records to database ERROR permiso denegado even tho i used the db user and db password
@AshishKumar-jj5tv
2 жыл бұрын
Hi bro I'm able to connect my database with nifi and but able to load small data only in tables(PUTSQL processor) if i try with to insert data > 15,000 using a single file then this processor is not working properly means it's reading the data from the file but not writing it to table/database
@InsightByte
2 жыл бұрын
When you say not working?! Does it throw an error, it timesout ? Also try setting "Fragmented Transactions" to false
@InsightByte
2 жыл бұрын
Join me on discord discord.gg/ubb42qGj
@AshishKumar-jj5tv
2 жыл бұрын
@@InsightByte thanks it worked
@DerBarde2012
4 ай бұрын
not working for docker
@Naveen-hk3yh
Жыл бұрын
I am trying to connect to the oracle database but it's throwing an error. My connection URL is as follows jdbc:oracle:thin:@NGDORAL08.prodnet.dom:1521:CSJPN1.PRODNET.DOM It's throwing an error--ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Could you please help me on this how to resolve Thanks.
@zengzhen
Жыл бұрын
make sure you have input a correct service name ---- is the "CSJPN1.PRODNET.DOM" a correct Oracle Service name?
Пікірлер: 12