As of Xtract Universal Version 4.26.1, the command line tool xu-config.exe is available to customers for creating extractions outside of the Xtract Universal Designer: C:\Program Files\XtractUniversal\xu-config.exe.

Note: This tool is EXPERIMENTAL and still in development. Beware of bugs and breaking changes! It’s currently limited to the extraction types Table and DeltaQ.

Creating a single Table extraction using Command Prompt #

  1. Start the Command Prompt application (1) with admin-user rights (2). cmd-prompt
  2. Navigation and selection of the xu-config.exe command line tool. administrator-command-prompt-xu-config
  3. Input of a defined SAP Connection, Destination & SAP table object for the parameter <source>, <destination>, <table>. The names of the parameters are not case sensitive.
    C:\Program Files\XtractUniversal>xu-config.exe --extraction ec5 sqlserver2019 --table TCURR
  4. Execution of the xu-config by confirming the input.
  5. Checking the generated table extraction in the Xtract Universal Designer or in the following directory:
    C:\Program Files\XtractUniversal\config\extractions xu-config-xu-designer-gui
  6. Use of all known functionalities e.g., filters, runtime parameters, execution, scheduling of extraction.

Note: The following table settings are set by default after creation: Package Size (50000), Extract data in background job (enabled), Selecting all related fields.

Creating multiple Table extractions using PowerShell-Script #

Using suitable scripts, a large number of extractions can be generated almost automatically and consequently contribute for the generation of an SAP data warehouse.

# read table list
$tableList = "KNA1","LFA1","MARA","CSKT","SKA1"
# set the path to the installation folder
$XUConfig = 'C:\Program Files\XtractUniversal\xu-config.exe'
# source sytem
$source = "ec5"
# destination
$destination = "sqlserver2019"

# loop the tables
foreach ($tableName in $tableList) {
    # create the extraction e.g.
    # xu-config.exe --extraction ec5 sqlserver2019 --table KNA1 
	Try {	    	        
		write-host -f Green "$tableName : Creation of Extraction is starting "  (Get-Date)            			
	    &$XUConfig --extraction $source $destination --table $tableName    
	    
	    # check the last exit code
	    # 0: successful
	    # else unsuccessful
	    if($LASTEXITCODE -eq 0) {                           
			write-host -f Green "$tableName : Creation of Extraction  is successful"  (Get-Date)            
	    } else {           
	        write-host -f Red "$tableName : Creation of Extraction failed with error code $LASTEXITCODE!"  (Get-Date)
	        #Write-Host $errorMessage
	    }                
	}
	Catch {
		write-host -f Red "$tableName : Creation of Extraction failed with Exception ! " + (Get-Date)  $_.Exception.Message
	}    	  
}