I want to consume data from InterSystems Caché using nifi any ideas
Have you looked at the processors designed for working with databases?
Thanks for your comment, I checked data base processors but I didn't find built in processor for this database.
You're correct, there are no built in processors for this database.
You'll could try and use the Generic Database Type in the GenerateTableFetch processor to see if it can communicate with the database.