Intellicus Enterprise Reporting and Business Insights 19.0

Creating Lookup Connection

0 views June 28, 2020 0

The first step will be to create a Lookup provider connection. This connection will further be used by the Query Object.

Creating connection for Lookup provider

To create this, you need to follow the below mentioned steps.

  1. To get to the Database connections page, click Navigate > Administration > Configure > Databases
  2. Click Add
  3. The page will display the following options as discussed in the ‘Lookup Connection Properties’ table
    Adding a lookup connection
    Figure 1: Adding a lookup connection

    Lookup Connection Properties

    Property Values Comments
    Connection Name Type Yourself Name of the lookup connection
    Provider Select LOOKUP from the Provider list Lookup provider used for the connection
    Look Up Type Select GEO-LOCATION from the list Type of lookup operations (like geo coding, reverse geocoding, currency conversion etc.)
    Platform Select MaxMind from the list External platform/lookup service provider for the selected Lookup Type
    Authentication Mode None

    Basic Authentication

    No authentication is required

    The application directly uses the username and password to authenticate the lookup service

    REST_URI Type Yourself The URI path of your REST web service
    Max Rows Type Yourself Specify the maximum number of rows to be fetched from dataset
    Username Type Yourself Username used to open the connection
    Password Type Yourself Password for the connection

    Blank= If user name and password is not required to connect to the platform

    Runtime= To provide username and password when user tries to access platform

    Connection String Auto generated Connection String to connect to platform
    Mask Connection String Check/Uncheck If checked connection string is masked
    Charset Encoding Select from list Select UTF-8 if the database is created or started with UTF-8 encoding. Otherwise, it is blank
  4. Once you have given the required details, you can test your connection if it has been successfully created. Save it once you get the message ‘Connection Test Succeeded.’ Cancel if you want to start afresh.
    You can choose to delete a saved connection, if required. Clicking Refresh Schema lets Intellicus refresh the data from the connected platform.