Hello, I have MsSql DB and Oracle DB. I am gonna try to explain what I want to do. I am fetching data from MsSQL DB than I am inserting that rows to Oracle DB but this structure not dynamic. Because I created TEST table on both side. So I am writing to table name of processor configuration. I want to create dynamic structure so when I start to flow, I need to migrate all database tables with all rows. But at the same time all tables need to create by processor automatically and when new rows came to MsSQL DB, the flow need to insert only new rows. Any one knows how to do that on Nifi 2.0.0-M3 ? ... View more

Hello, I want to migrate data from MsSQL Server to Oracle Database. I added ConnectionPools for both of. I am trying to export data andimport data ,but i cant. Which processor i need to use and how ? I tried to fecth data with ExecuteSQL but it is fetching as Avro. Than i wanted to convert it to json but i didn't. Because i cant configure the ConvertRecord processor. ... View more