Extractions

This section shows how to create and manage extractions in Xtract Universal. Extractions are the core components of Xtract Universal. They enable you to read and write data to and from SAP systems.

A list of all existing extractions is displayed in the main window of the Designer.

Extraction Types

The extraction type defines the SAP objects that an extraction can access. Xtract Universal supports the following extraction types:

Edit Extractions

To modify an existing extraction:

1. Go to the list of extractions in the main window of the Designer.
2. Double-click an extraction.
3. The window of the corresponding extraction type opens.
4. Make the necessary changes.
5. Click [OK]. The window of the extraction type closes.

The extraction is updated.

Change the SAP Source System

To change the source connection of multiple extractions at once:

1. Go to the list of extractions in the main window of the Designer.
2. Select a single extraction or use [Ctrl]+[left mouse button] to select multiple extractions. To change the destination of all extractions inside a folder, use [Ctrl]+[A] to select all extractions inside the currently open folder.
3. Click [Source]. The "Change source" window opens.
4. Select an SAP connection from the dropdown.
5. Click [OK]. The "Change source" window closes.

All selected extractions are updated.

Change the Destination

To change the source connection of multiple extractions at once:

1. Go to the list of extractions in the main window of the Designer.
2. Select a single extraction or use [Ctrl]+[left mouse button] to select multiple extractions. To change the destination of all extractions inside a folder, use [Ctrl]+[A] to select all extractions inside the currently open folder.
3. Click [Destination]. The "Destination Settings" window opens.
4. Select a destination from the Destination dropdown.
5. Click [OK]. The "Destination Settings" window closes.

All selected extractions are updated.

Delete Extractions

To delete an extraction:

1. Go to the list of extractions in the main window of the Designer.
2. Select a single extraction or use [Ctrl]+[left mouse button] to select multiple extractions.
3. Click [Delete]. A confirmation window opens.
4. Click [Yes] to confirm the deletion.

The extractions are removed from the list of extractions.

Organize Extractions in Folders

You can organize extractions in folders for better maintenance and mass editing. Folders are displayed in the left side tree view menu of the Designer. This menu reflects the local folder structure in the configuration directory of Xtract Universal, e.g., C:\Program Files\XtractUniversal\config\extractions

By default all new extractions are listed inside the folder extractions.

Create a new Folder

To create a new extraction folder:

1. Go to the tree view in the main window of the Designer and right-click the extractions folder. The context menu opens.
   
2. Click New subfolder. The window "Create new subdirectory" opens.
   
3. Enter a unique name for the extraction folder.
4. Click [OK].

The new subfolder is displayed in the tree view.

Add Extractions to a Folder

To add existing extractions to a folder:

1. Go to the list of extractions in the main window of the Designer and find the extractions you want to move.
2. Select the extraction or use [Ctrl]+[left mouse button] to select multiple extractions.
3. Drag and drop extractions from the list of extractions into a folder in the left side tree menu.
   

The selected extractions are now located inside the folder.

Rename a Folder

To rename an existing extraction folder:

1. Go to the tree view in the main window of the Designer and find the folder you want to rename.
2. Right-click the folder. The context menu opens.
3. In the context menu, click Rename. The context menu closes and the "Rename folder" window opens.
4. Enter a new name in the field Rename subdirectory.
5. Click [OK]. The "Rename folder" window closes.

The folder now uses the new name.

Delete a Folder

To delete an existing extraction folder:

1. Go to the tree view in the main window of the Designer and find the folder you want to delete.
2. Right-click the folder. The context menu opens.
3. In the context menu, click Delete. The context menu closes and a confirmation window opens.
4. Click [Yes] to confirm the deletion.

The folder and its content is deleted.

Look Up Extractions within a Folder

Use the search bar above the extraction list to filter the displayed extractions. Wildcards (*) are not supported.

Look Up Extractions in all Folders

To look up an extraction in all folders and subfolders:

1. Go to the main window of the Designer and click [Search]. The window "Search Extractions" opens.
   
2. Enter the name of a folder, extraction, extraction type, source system, destination or a keyword in the search bar.
   
3. Click . Search results are displayed.
4. Select an extraction from search results.
5. Click [Go].

The extraction is located and the corresponding folder opens.