search cancel

How to upload Quovadata using arrfupload tool

book

Article ID: 42508

calendar_today

Updated On:

Products

CA Advanced Authentication CA Risk Authentication CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)

Issue/Introduction

How can I upload Quova Data using arrfupload tool command line utility? The instructions provided below are for the old Quova data  in V6 format which we used to get from the Neustar team, now they are shipping v7 format data and that information can be found in documentation of how to do the upload.

Environment

CA Risk Authentication(RiskMinder or Riskfort)

Version - 9.x

Resolution

Uploading Quovadata is two step process:

[Step-1]Upload the data to Risk Authentication database tables using arrfupload tool [Step-2]Refresh cache.

[Step-1] Upload the data to Risk Authentication database tables using arrfupload tool

The Arcot RiskMinder Data Upload Tool(arrfupload) is a command-line utility that enables you to upload the Geolocation and Anonymizer Data from Quova files to the RiskMinder database.

This tools is available in below location:

For Windows: %ARCOT_HOME%\bin\arrfupload

For Linux: $ARCOT_HOME/sbin/arrfupload

The tool is run from command line. For Windows, run it as "arrfupload" and for Linux, run it as "./arrfupload". The parameters can be passed either through configuration file or as arguments in command line utility. Below are the different options to upload the data.
 

Option 1: Upload using configuration file



The riskfortdataupload.ini file controls the behavior of the CA Risk Authentication Data Upload tool. It is available in <ARCOT_HOME>/conf/ folder. Before running the tool you need to configure below parameters in this file



Tables - The tables that the user can work with. Possible values are: GeoPoint and Anonymizer.



Load - The indicator whether to upload the data to the table or not. Possible values are: 0 (Do not load) and 1 (Load).  Default value is Do Not Load

Swap - The indicator whether to switch CA Risk Authentication configuration to start using the table where GeoPoint or GeoAnonymizer data has only been uploaded. Possible values are: 0 (Do not swap) and 1 (Swap)

Filename - The name of the file from which the Quova data has to be loaded. Mention the absolute path to the file, with the file name.

Then run this tool from command line as below.

 

arrfupload -config


Option 2: Command to upload Quova data

Below command can be used for uploading Quova data using script. This will not ask for any input(not interactive mode). Logs will be written in %ARCOT_HOME%\logs folder.

[1] Single table upload

arrfupload -prompt <<Table name> <Load> <Swap> <Absolute path of the file>>

Example:



=> Upload only GeoPoint data

arrfupload -prompt GeoPoint 1 1 C:\quova\Corrected_EDITION_Media_2014-05-08_with_v682.dat

=> Upload only Anonymizer data

arrfupload -prompt Anonymizer 1 1 C:\quova\anonymizers_2014-05-06.dat

[2] Upload both GeoPoint  and Anonymizer data

 

arrfupload -prompt <<Table name> <Load> <Swap> <Absolute path of the file>>  <<Table name> <Load> <Swap> <Absolute path of the file>>

Example:



arrfupload -prompt GeoPoint 1 1 C:\quova\Corrected_EDITION_Media_2014-05-08_with_v682.dat Anonymizer 1 1 C:\quova\anonymizers_2014-05-06.dat

[Step-2] Refresh cache

The CA Risk Authentication Server cache must be refreshed after uploading the data. Command to refresh cache is:

 

arrfclient cr <ipaddress of riskfort server> <port>

Example:

arrfclient cr localhost 7980

arrfclient cr 127.0.0.1 7980

arrfclient cr 10.131.56.78 7980

Additional Information:

[A] Uploading Quova data and cache refresh using batch script
Add these commands in a batch script(Windows) or cronjob(Linux).

arrfupload -prompt <<Table name> <Load> <Swap> <Absolute path of the file>> <<Table name> <Load> <Swap> <Absolute path of the file>>
arrfclient cr <ipaddress of riskfort server> <port>

[B] Complete product guide is available at - arrfupload