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. Login to the Scheduler Administration Tool and then connect to the Scheduler Server, both of these will accept default admin / admin login details. Scheduler Login Scheduler Server Login Scheduler Server Login Details
  2. In the Denodo Scheduler we need to create a new job to create and maintain the Index. Click New 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
    • View: tutorial.client
    • Indexing process name: tutorial.client
    Scheduler
  5. Choose the following settings Under the Exporters section, while leaving the rest to default/blank:
    • Data Source: arnIndex
    • Index name: ix_client
    Scheduler
  6. Save the Scheduler Job. Once the job is saved, you can execute the job by clicking the blue Execute icon. 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: menu_content_search
  2. Click the + icon under Configure Index Servers. add_index_server
  3. Add the details as follows to the Add New Index Server screen.
    • Type: Scheduler Index
    • Host: localhost
    • Port: 9000
    • Login: admin
    • Password: admin
    • Description: Tutorial Index
    • Name: TutorialIndex

  4. Click Save. add_index_server_details
  5. Under Configure the Search Index for each VDP Server, Click the Pencil Icon. add_index
  6. In the Search Index Path screen, add the following details:
    • Index Type: Scheduler Index
    • Index Server: TutorialIndex
    • Index Name: ix_client

  7. Click Save add_index_details
  8. 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!