 |
|
|
Intellicus 19.0 lets you to search entities (like tables, views etc.) under SQL Designer of Query Object. You can start typing text under the 'Entities' text box to search for specific entities under Table / View / Procedure / Synonym.
A new step named 'Lookup' is introduced on Query Object designer screen. With this step, you can perform external field level lookup operations (like geo coding, reverse geocoding, currency conversion etc.) before proceeding to the format step.
Intellicus provides a mechanism to perform lookup for geographical coordinates (i.e. latitude and longitude) and geospatial information (i.e. Country, State, City, Zip Code, IP Address).
To enable this step on Query Object screen, you need to create a GIS Lookup connection (viz. MaxMind). The REST URI, username, password etc. is to be provided if lookup provider is a REST web service.
Based on the lookup type and platform specified at connection level, you can now specify parameters, and properties required to successfully achieve field lookup.
Once you have geographic fields, you can select corresponding geographical roles that are automatically populated (from a configuration file) on the Format step.
If the field list has latitude or longitude or both already available, then Intellicus provides a provision to set Latitude-Longitude format for such fields.
After you have looked up the geographic fields and assigned roles corresponding to them on the Query Object screen, you can then render maps in Intellicus.