Parameterizing the nifi flow

2017-08-11 Thread More, Vikram (CONT)
Hi, I have a nifi flow which pulls/extracts from source database table and loads into target database table. This flow will run several times in a day to get delta records from source table (more like batch process running every 3-4 hrs). Now I need to replicate this same process for 100+

RE: ExecuteSQL question: how do I stop long running queries

2017-09-29 Thread More, Vikram (CONT)
highly recommend upgrading your NiFi version if possible, as there have been many improvements to all the RDBMS processors in order to help handle use cases like yours. Regards, Matt On Sep 29, 2017, at 6:31 PM, More, Vikram (CONT) <vikram.m...@capitalone.com<mailto:vikram.m...@capitalo

ExecuteSQL question: how do I stop long running queries

2017-09-29 Thread More, Vikram (CONT)
Hi , I am using ExecuteSQL processor to pull from operational database and for some of the tables it keeps running for more than 24 hrs, 1] During a long-running query from a database (e.g. Oracle) being execute by an 'ExecuteSql' process, is there a way to check the progress - say by seeing