Java utility for searching Databases, Legacy Apps and flat files
Post by:Kailas Lovlekar
, Ranch Hand
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?
Post by:Tim Moores
, Saloon Keeper
Maybe Apache Solr. I think it can index and search various kinds of data sources.