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 ODP and DeltaQ.

Note: Since Xtract Universal 5.0.0, xu-config.exe needs to be executed under the same Windows AD account as the Xtract Universal service is running. In this case, you need to run the Windows command prompt as that respective user or use the runascommand.

Creating a single Table extraction using Windows Command Prompt #

  1. Start the Command Prompt application (1) with admin-user rights (2). cmd-prompt
  2. Navigate and select 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. Execute the xu-config by confirming the input. The xu-config and the XU service must run under the same account.
  5. Check 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
	}    	  
}