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.
- To get to the Database connections page, click Navigate > Administration > Configure > Databases
- Click Add
- The page will display the following options as discussed in the ‘Lookup Connection Properties’ table
Figure 1: Adding a lookup connectionLookup 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 - 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.