I am bit rusty with Java and looking for any advice to meet following requirement -
We need a utility which can connect to several databases or network file system locations, then search for a text in all locations. Example - Look for a phone number or name in DB2, Oracle, Some log files, Excel file and so no. Then present results back to the requester.
Beyond establishing JDBC collections, the utility should workout schema structures, table names and formulate dynamic queries to interrogate data. Any thoughts please?