Forums Register Login
Java utility for searching Databases, Legacy Apps and flat files
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?

Maybe Apache Solr. I think it can index and search various kinds of data sources.
Thank you Tim. Will give it a go :-)
Wink, wink, nudge, nudge, say no more ... https://richsoil.com/cards

All times above are in ranch (not your local) time.
The current ranch time is
Dec 15, 2017 14:57:50.