Why not use Apache Solr to do the job for you? If you use Solr, combine it with the freely downloadable JDBC drivers from Microsoft and you can index data in the underlying database at will. The indexing process can be controlled and it can do delta updates so your performance is not negatively impacted. With a little time spent customizing the Velocity templating, you can present a pretty usable, google-style, search interface out of the box. Similarly, Solr supports web services, so if had a developer team handy, they could create a custom web interface for you.
Solr can also be configured into single installation, multi-core configuration, or a multiple node installation on a private solr cloud (using Apache Zookeeper for communications) with multiple collections (think of them as being collections of books) so that each database or application can have it's own search engine. The appliation is entirely written with Java, and I can speak from personal experience (I've built installations in both configurations to search databases, sharepoint, office documents, network shares, rss feeds, etc.) that the software runs like a mint on both Windows, or *nix platforms. Take the combination one step further and use Apache ManifoldCF, and not only can you index the web, but also file shares, office documents, sharepoint installations, other database, imap servers, etc. Add the replacement search handler that ManifoldCF has, and it can authenticate users against your internal domain before they search. Add Banana and get near real time dashboards of your server with clickable charts. And if you add logstash and lumberjack, you can also add log data from your servers into the search index. Just asking... I mean, all of these applications are open source and cost nothing, not to mention that they routinely get used in many major companies. Solr: http://lucene.apache.org/solr/ Zookeeper: http://zookeeper.apache.org/ ManifoldCF: https://manifoldcf.apache.org/ MS JDBC for SQL Server: https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx Banana: https://github.com/LucidWorks/banana Logstash: https://github.com/LucidWorks/solrlogmanager On Wed, Jul 1, 2015 at 11:39 AM, Brock, Anne <anne_br...@bmc.com> wrote: > ** > > Hi, all – > > > I remember at WWRUG one of our partners had a very robust search > engine/tool that could be used to go though Remedy data and, I think, data > external to Remedy. I can’t remember the partner, of course; anyone know > who it is? > > > > Apologize for vagueness, but it’s been a few years… > > > > Anne Brock > > Principal SC > > BMC Software > > 209-417-0481 > > anne_br...@bmc.com > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
