Xtract Universal supports integration of your SAP data in the most different target systems.

After creating an extraction (Refer to the online help), you can run an extraction by just calling the command tool with the right parameters.

As an alternative you can just call the correspondent URL that can be found in the Run Dialog (e.g. http://nbelzein:8065/?name=plants). We recommend to use the command line.

In this blog I will show you how to schedule an Xtract Universal extraction that is as easy as calling the command line with the right parameters.

Xtract Universal delivers the command tool xu.exe (to be found in the installation folder, e.g. C:\Program Files\XtractUniversal\xu.exe) to run an extraction using the command line. We will use this approach to schedule an extraction with the windows Task Scheduler and the SQL Server Agent.

1. To open the Task Scheduler on Windows 7, Click Start Button -> Control Panel -> System Security -> Administrative Tools -> Task Scheduler.
Alternatively you can Run the Task Scheduler from the Command Line by Typing Taskschd.msc.

2. Click the Action menu and then click Create Basic Task

3. Type a name for the task and an optional description, and then click Next.

4. Select the option daily and then click Next.


5. Set start date and time and then click Next.


6. Select the option Start a program

7. As Program/script set the path to the Xtract Universal Command tool:“C:\Program Files\XtractUniversal\xu.exe” .

Set the field Add arguments (optional) to: -s localhost -p 8065 -n SAPPlants

Click Next.

xu command task scheduler

 

8. Check the Summary and Click Finish.

xu command task scheduler 02

Now the Task is planned. You can right-click the task and select run to run it immediately.

If you want the task to run more than one extraction, open edit and go to the tab Actions and create new actions as described in step 7.

This was just a demonstration. The Task Scheduler offers more options. For more options check Microsoft technet.

SQL Server Agent

You can also use the SQL Server Agent to schedule the job.

Create a step of Type Operating System (CmdExec) and set the command to

“C:\Program Files\XtractUniversal\xu.exe” -s localhost -p 8065 -n SAPPlants

Written by Khoder Elzein

Khoder is responsible for presales and always has an attentive ear for our customers, prospectives and partners. When travelling in Germany or abroad, he provides customer support at PoCs, workshops and on training courses. He also looks after the further development of our software solutions. Khoder has been working in IT since the turn of the millennium; he has been a member of team Theobald since 2009. When it comes to private interests, family, nature and reading feature at the top of his list – along with innovative fusion cuisine, as you may infer from his favourite dish of Swabian cheese noodles with tabouleh.