For Administrators only - Index data to enable Google-like user search queries

Data Catalog

In this section We will explore the features of the Data Catalog Content Search. With this feature you can use Denodo Scheduler to index the content of your views using either ElasticSearch or the Denodo Scheduler Index Server. You can then allow your users to perform Google-like searches on them, and to customize how they see the search results.

In our example we are going to index the fields of the client view, to allow more rapid discovery of client details.

This page is aimed at a Denodo Administrator, and not our Business user. Business users would only be concerned with the use described in the next section, Index Search.

NOTE

Index Creation & Configuration

Our first Step is to configure an Index. Let's see how to do that using Denodo Scheduler

Creating an Index in the Denodo Scheduler

Start the Scheduler Server, the Scheduler Index Server and the Scheduler Administration tool from the Denodo Control Center. Once these are all running, open the Scheduler Administration Tool by clicking on the link (by default: http://127.0.0.1:9090/webadmin/denodo-scheduler-admin).

scheduler_control_centre

The Scheduler Index Server needs to be running all the time in order for this feature to work.

NOTE

 

Create the Index following these steps

  1. In the login screen of the Scheduler Administration Tool, provide the login details admin / admin and URI of the Scheduler Server. The URI of the server has the format //<host>:<port>. Scheduler Login
  2. In the Denodo Scheduler we need to create a new job to create and maintain the Index. Click Add Job > VDPIndexer Scheduler
  3. Give the Job a suitable name, in this case index_clients. Scheduler
  4. Choose the following settings Under the Extraction section, while leaving the rest to default/blank:
    • Data Source: vdp
    • Database: tutorial
    • View: tutorial.client
    • Indexing process name: tutorial.client
    Scheduler
  5. Under the Exporters section, click Add Exporter > Scheduler-Index and choose the following settings while leaving the rest to default/blank:
    • Data Source: Scheduler-Index
    • Index name: ix_client
    Scheduler
  6. Save the Scheduler Job. Once the job is saved, you can execute the job by clicking three dots under the Processed (Tuples/Errors) column and then the start option . Scheduler
  7. The job will execute and once successfully complete, the Result status will change to COMPLETE, indicating that the Index has been populated. Scheduler

 

Configuring the Index in the Data Catalog

We now need to configure the newly created Index in the Data Catalog, in order to ensure that the Data Catalog includes the Index as part of the searchable content.

  1. Open the Data Catalog and navigate to Administration > Set-Up > Content Search.
  2. In the Administration window, click on Content Search option menu_content_search
  3. Click on + Add server option under Index Servers tab. add_index_server
  4. Add the details as follows to the Add New Index Server screen.
    • Name: TutorialIndex
    • Type: Scheduler Index
    • Description: Tutorial Index
    • Host: localhost
    • Port: 9000
    • Login: admin
    • Password: admin

  5. Click Ok. add_index_server_details
  6. Go to the Configuration tab, Click the Pencil Icon. add_index
  7. In the Search Index Path screen, add the following details:
    • Index Type: Scheduler Index
    • Index Server: TutorialIndex
    • Index Name: ix_client

  8. Click Ok. add_index_details
  9. The Index will display a green checkmark under the Configured column to indicate that the Index was added successfully. add_index_saved

 

DONE! In the next section we will see our new Index in action!