Source Extractors - SQL PLSQL - Information - How to run Oracle DB Extractor outside of the DMT

Purpose

The page details out the process to run Oracle DB Extractor outside of the DMT

Applicable in CAST Version
Release
Yes/No
8.3x (tick)
8.2.x (tick)
8.1.x (tick)
8.0.x (tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(error)
Details

The following are the ways to run DB extractor from Command Line

  1. To have the GUI for the extractor:

    set JAVA_EXE="C:\Program Files (x86)\Java\jre6\bin\java.exe"

    set JAR_PATH="C:\Program Files (x86)\CAST\7.2\DeliveryManagerTool\standardPlugins\dmtdevsqlcastextractor-1.0\CAST-DatabaseExtractor.jar"


    %JAVA_EXE% -Xmx1200M -cp %JAR_PATH% com.castsoftware.extractor.cli.GUIDBExtractor

  2. Use the same “CAST-DatabaseExtractor.jar” to generate the UAX files:

    set JAVA_EXE="C:\Program Files (x86)\Java\jre6\bin\java.exe"

    set JAR_PATH="C:\Program Files (x86)\CAST\7.2\DeliveryManagerTool\standardPlugins\dmtdevsqlcastextractor-1.0\CAST-DatabaseExtractor.jar"

    %JAVA_EXE% -Xmx1200M -cp %JAR_PATH% com.castsoftware.extractor.cli.GUIImporter

Notes/comments