How to: |
Loqate is used to enable address cleansing operations in Data Quality Workbench, which is accessible through Omni Governance Console (OGC). Loqate must be installed on the system where Omni-Gen is currently running. Loqate must be installed with an associated license key based on your purchase of Omni-Gen MDM Edition or DQ Edition. If you do not have a license key for Loqate, then contact iWay Customer Support.
To install Loqate on Linux platforms:
# ./loqate_installer_x86_64
This will install Loqate on your computer. Continue? [n/Y] y
1.0 U.S. GOVERNMENT LICENSING RIGHTS; NOTIFICATION OF EXPORT RESTRICTION.
........
........
........
Spain "Información geográfica propiedad del CNIG"
Sweden "Based upon electronic data National Land Survey Sweden."
Switzerland "Topografische Grundlage: Bundesamt für Landestopographie."
Do you agree to the license? [y/n] y
Where do you want to install Loqate? [/opt/loqate] /software/loqate
A prompt appears, asking you to select the components to install, as shown below.
Please select the components to install. Items to install marked with asterisk
* 1. Install Manager
* 2. Sample US Data
* 3. Java API
* 4. Node Collector
* 5. C++ API (required)
* 6. Batch Processor
* 7. Java Samples
* 8. Central Collector
* 9. C++ Samples
10. Done
Select a component: 10
The Loqate installation is started and a notification appears when the installation is complete, as shown below.
Installing Loqate...
Installing C++...
Installing C++ Samples...
Installing Java...
Installing Java Samples...
Installing Batch...
Installing Batch Samples...
Installing SAMPLEDATA_LIN...
Installing IM_LINUX64...
Installing NC_LINUX64...
Installing CC_LINUX64...
To install data, cd /software/loqate then run ./InstallManager.sh. The Install Manager requires a java runtime version of at least Java 7. A
dedicated JRE has been installed in /software/loqate/jre. To use a locally installed JRE instead please edit the InstallManager.sh file.
Please note that you may need to change the permissions of both the InstallManager.sh file and jre directories to allow your user to run these
applications.
Installation complete.
To download and install the country data packs for Loqate:
# cd /software/loqate/
# ./InstallManager.sh
Native library STLPort failed to load, ignore this if not using solaris OS.
java.lang.UnsatisfiedLinkError: no stlport in java.library.path
Welcome to the Installation Manager - version 10.0.0
Running using local API version 2.25.1.9411
A prompt appears, asking if your network communication passes through a proxy server, as shown below.
Does your network communication pass through a proxy server (y/n)?
Please enter the path to the data installation folder
/software/loqate/data
Valid folder found. Proceeding with a data installation.
A prompt appears, asking you for a license key, as shown below.
Please select from below:
Enter 1 if you have a license key
Enter 2 if you have a license pack
Enter 3 to exit
1
Please enter the license key: <enter_your_license_key_here>
Contacting license server to validate the license key.
++++
Details of your current license
--------------------------------------------
-------------------------------------------------------
Product Expiry Date
-------------------------------------------------------
Knowledge Base Common 2018-12-31
Worldwide Geocode Dataset 2018-12-31
Worldwide Verify Dataset(O) 2018-12-31
USA Verify Dataset CASS 2018-12-31
USA Enhance CENSUS Dataset 2018-12-31
CASS Library 2018-12-31
-------------------------------------------------------
A prompt appears, asking you to select how you want to download and install the data packs, as shown below.
Please select from below: Enter 1 if you want to download the data packs but not install Enter 2 if you want to download and install the data packs Enter 3 if you want to install using your locally available data packs Enter 4 to exit 2
Please enter a valid download folder path
/software/loqate/download
Processing.
Fetching information from server about the available data packs.
Contacting license server for information on available updates.
+++
Done fetching information from server regarding available data packs.
------------------------------------------------------
S.No Product Date of Release
------------------------------------------------------
1 Africa and Middle East Other Geocode Dataset 2017-10-18
2 Africa and Middle East Other Verify Dataset 2017-10-18
.....
.....
.....
139 Kenya Geocode Dataset 2017-10-18
140 Kenya Verify Dataset 2017-10-18
141 Knowledge Base Common 2017-11-27
142 Kuwait Geocode Dataset 2017-10-18
143 Kuwait Verify Dataset 2017-10-18
.....
.....
.....
270 Turkey Geocode Dataset 2017-10-18
271 Turkey Verify Dataset 2017-10-18
272 USA Enhance CENSUS Dataset 2016-01-07
273 USA Geocode Dataset 2017-10-18
274 USA Geocode1 Dataset 2017-10-18
275 USA Geocode2 Dataset 2017-10-18
276 USA Geocode3 Dataset 2017-10-18
277 USA Verify Dataset 2017-11-27
278 Uganda Geocode Dataset 2017-10-18
279 Uganda Verify Dataset 2017-10-18
.....
.....
.....
Note: The available data packs may vary based on your licensing.
------------------------------------------------------
Enter : 1 to install the first Product, 2 to install the second Product and so on
Enter : all if all products are to be installed
Enter : done to complete the selection of products
Enter your selection:
141
Enter your selection:
273
Enter your selection:
274
Enter your selection:
275
Enter your selection:
276
Enter your selection:
277
Enter your selection:
Done
------------------------------------------------------ S.No Certification Product Date of Release ------------------------------------------------------ 1 CASS Library (Linux 64) 2017-07-11 2 CASS Library (Windows 32) 2017-07-11 3 USA Verify Dataset CASS 2017-10-30 ------------------------------------------------------ Enter : 1 to install the first Product, 2 to install the second Product and so on Enter : none to skip certification products Enter : all if all products are to be installed Enter : done to complete the selection of products *** Note : You are running Install Manager on Linux 64 You may extract the other platform packs as well.However only the compatible library / data will be placed in the API installation / data installation folders respectively Enter your selection: none Skipping Certification products Enter your selection: done LICENSE AGREEMENT --------------------------------------------- 1.0 U.S. GOVERNMENT LICENSING RIGHTS; NOTIFICATION OF EXPORT RESTRICTION. ...... ...... ...... Switzerland "Topografische Grundlage: Bundesamt für Landestopographie."
Have you read the license agreement and agree to its contents (y/n)? y ---------------------------------------- Space available : 53.4 GB Space required for download : 6.0 GB ---------------------------------------- Downloading data packs. +++++++++++ Completed downloading KBCOMMON_9100_20171127_115.lfz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++ Completed downloading DSGUSA2_5985_20171018_901.lfz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++ Completed downloading DSGUSA_5985_20171018_2642.lfz ++++++++++++++++++++++++++++++++++++++++++ Completed downloading DSGUSA1_5985_20171018_2970.lfz +++++ Completed downloading DSVUSA_5985_20171127_3953.lfz ++ Completed downloading data packs. ---------------------------------------- Space available : 47.3 GB Space required for install : 10.3 GB ---------------------------------------- Beginning installing of data packs. Unzipping DSGUSA_5985_20171018_2642.lfz and installing ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Unzipping DSGUSA3_5985_20171018_1.lfz and installing + Unzipping DSGUSA1_5985_20171018_2970.lfz and installing ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Unzipping DSGUSA2_5985_20171018_901.lfz and installing +++++++++++++++++++++ Unzipping KBCOMMON_9100_20171127_115.lfz and installing +++ Unzipping DSVUSA_5985_20171127_3953.lfz and installing ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ Completed installing the data packs. Successfully installed the data packs.
When you receive a message indicating Successfully installed the data packs, then the download and installation process for the Loqate data packs is complete.
After you have finished downloading and installing the country data packs for Loqate, you must install the address cleansing metadata for Omni-Gen to enable address cleansing operations within Data Quality Workbench.
Note: If Omni-Gen Server was running during the Loqate installation, then Omni-Gen Server must be restarted and you must restart all Omni-Gen services.
The address cleansing metadata consists of the following two files:
<OmniHome>/OmniGenData/OmniDesigner/.repositoryservice/Operations/cleansecomplex
Depending on your operating system, you must first modify the .profile and bash_profile files that are called when opening a shell.
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/software/loqate export LIBPATH=$LIBPATH:/software/loqate
To verify Loqate functionality:
# vi runbatch.sh
# ./runbatch.sh
# vi sample.txt*Output.txt
To set the DQ cleanse JVM arguments:
The JVM Process Arguments dialog opens, as shown in the following image.
-Djava.library.path=/software/loqate
The new value is now displayed for the JVM Process Arguments parameter, as shown in the following image.
To modify the Data Quality Server (DQS) components for the correct Loqate installation location:
# cd /software/omnigen/OmniServer/mastering/services/cleansing/components/sub
# vi generic_address_cleanse.comp
To restart Omni-Gen: