Extraction through interactive utility

Note: Ensure that execute permission is granted to the aq folder.
  1. Log in with admin rights or as a root user.
  2. Change the directory to the location <BDQ_Installation>/SDK/utilities/dbloader/aq/scripts/server.
  3. Run the script installdb_unc using the command:
    sh installdb_unc.sh <BDQ_Installation/SDK> <Acushare runtime path>
    This command also verifies whether the Acushare service is running and starts the service if it is not already running. It also displays these options:
    • US Subscription: Press 1 to list the available types of data loading.
    • Exit: Press 99 to exit.
  4. Enter the specific number for the type of data you want to load.


  5. Fetch reference data from the e-Store, unzip it, and place it in a folder. Path up to this folder is your input path. For example, /home/hadoop/hduser/UAM_DEC_2017_DB/databases.
  6. Specify the input path.
    The utility displays a default output path.
  7. Enter c to continue, m to modify the default path or q to quit.


    The input data is extracted at your designated output file location.
  8. The system prompts to verify whether or not your new RDI file location is correct. Enter y or n.


The system starts loading the data. The data is extracted in the specified output directory.
Note: Repeat these steps for the type of data that you want to load.