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 :-)

This thread has been viewed 432 times.

All times above are in ranch (not your local) time.
The current ranch time is
Oct 19, 2018 03:32:16.