• Post Reply Bookmark Topic Watch Topic
  • New Topic

Java utility for searching Databases, Legacy Apps and flat files  RSS feed

 
Kailas Lovlekar
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

 
Tim Moores
Saloon Keeper
Posts: 3960
94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maybe Apache Solr. I think it can index and search various kinds of data sources.
 
Kailas Lovlekar
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Tim. Will give it a go :-)
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!