I have around 400 tables in a SQL server database, out of which i want to list 10 tables from ListDatabaseTables processor in Apache NiFi in HDF. These 10 tables doesn't have a fix naming pattern.
When i am trying to add multiple tables with semicolon as separation in value of TableNamePattern property, the processor is not able to detect the tables.
While the same works absolutely fine with single TableNamePattern value.
Refer to screen shots:
1st processors works fine whereas 2nd processor is not able to search the tables.
Any other suggestion to import data from 10 tables(not having a fix naming pattern) out of 400-500 tables through NiFi will be highly appreciated.