Intellicus Enterprise Reporting and Business Insights 19.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
   
   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.