Using Solr to search website and external Oracle ServiceCloud

[jclaros <jc...@sagaftra.org>]

Hello,
I have a drupal website that uses SOLR.
When a user searches our website, I would like to now return results from 2
sources:
(1) our website
(2) our external Oracle ServiceCloud knowledge base

Does anyone have any suggestions on how to do this?




--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Using Solr to search website and external Oracle ServiceCloud

[Emir Arnautović <em...@sematext.com>]

Hi,
You have several options:
1. keep date as is and implement federated search logic with two queries - one to Solr and other to Oracle. PRO: no need to change data flow. CON: Results are not comparable when it comes to scores and you will probably need to present it as separate groups
2. import data from Oracle to Solr and align it so it has the same structure. PRO: ability to run a single query and have mixed results based on relevancy. With mixing content, you can have better stats and have more relevant results.  CON: need to change data flow or sync Oracle-Solr
3. import data from Oracle to Solr but keep FAQ as a separate collection. PRO:  a single search engine and no need to align knowledge base content with site content. CON: the same issues as with 1. and 2.

HTH,
Emir
--
Monitoring - Log Management - Alerting - Anomaly Detection
Solr & Elasticsearch Consulting Support Training - http://sematext.com/



> On 10 Apr 2018, at 21:00, jclaros <jc...@sagaftra.org> wrote:
> 
> Hello,
> I have a drupal website that uses SOLR.
> When a user searches our website, I would like to now return results from 2
> sources:
> (1) our website
> (2) our external Oracle ServiceCloud knowledge base
> 
> Does anyone have any suggestions on how to do this?
> 
> 
> 
> 
> --
> Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html