Extracting data from the oracle database

  1. Place the ExtractORCLAI.SQL and ExtractORCLAI.cmd in the same folder on the machine where SQL Plus utility is available. SQLPlus should be accessible from the path where ExtractORCLAI.SQL and ExtractORCLAI.cmd are placed.
  2. To start extraction, execute ExtractORCLAI.cmd from the command prompt with these parameters:
    • Username – This is the user name for the Oracle ERP backend Oracle database.
    • Password – This is the password for the Oracle ERP backend Oracle database.
    • HostString – This is SID for the Oracle ERP backend Oracle database.
    • ExtractedDataFilesPath - This is the path where the output files will be created. Do not enter spaces in the data file path.
    • For Example, ExtractORCLAI "apps" "apps" "vis" "D:\ORCLAI" "US"
    • Connection Language - This is the language in which data extraction should take place. For example, if French is the connection language, extracted data will be in French. The language codes in the Language drop-down lists are as follows:
      • US for ENGLISH US
      • GB for ENGLISH UK
      • F for FRENCH
      • D for GERMAN
      • E for SPANISH
      • PT for PORTUGESE
      • ESA for LATIN AMERICAN SPANISH
      • PTB for BRAZILIAN PORTUGESE
      • FRC for CANADIAN FRENCH
      • IW for HEBREW
    Note: 
    • The username must have read access to the objects listed in List of Objects.
    • The path for creating the output files should be a valid path on the same machine, from where you are extracting the data, and not a mapped drive. Also, there should be sufficient space for creating the files.