How to schedule Xtract Universal extractions to load data from SAP

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 correspondent URL that can be found in the Run Dialog (e.g. http://nbelzein:8065/?name=plants)

 

In this blog I will show you how to schedule the run of the Xtract Universal extractions that is as easy as calling a URL. Xtract Universal delivers the command tool XtractUniversalCmd.exe (to be found in the installation folder, e.g. C:\Program Files\XtractUniversal) to run an extraction using the cmd. 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. Click the Action menu and then click Create Basic Task

 

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

 

3. Select the option daily and then click Next.

 

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

 

5. Select the option Start a program

 

6. As Program/script set the path to the Xtract Universal Command tool: "C:\Program Files\XtractUniversal\XtractUniversalCmd.exe". Set the field Add arguments (optional) to the url of the extraction, e.g. http://nbelzein:8065/?name=plants . Click Next

 

7. Check the Summary and Click Finish.

 

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 6. 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 toset the path to the Xtract Universal Command tool and the url of the extraction "C:\Program Files\XtractUniversal\XtractUniversalCmd.exe" http://nbelzein:8065/?name=plants