Mastering SAP Access with Xtract Universal and Powershell

Xtract Universal is an SAP connector that enables you extract save data streams from different SAP ERP and BW objects to different target systems. Xtract Universal offers a command tool that can be used for automating and scheduling the SAP extractions and for integration with different ETL Tools. Powershell also is a powerful and popular task automation and configuration framework from Microsoft that is based on .Net framework and includes a command-line shell and a scripting language. In this blog, I will show tips how to use PowerShell in combination with Xtract Universal.…continue reading →

Sync Dynamics 365 Accounts to SAP in ERPConnect Services Core

In this blog, I will describe a scenario, where a Dynamics 365 account is synchronized in near-real time to SAP, where an SAP customer is created and the SAP customer number is written back to the Dynamics 365 account. For this scenario, I am using the following tools: - SAP ECC system on Premise - ERPConnect Services Core (ECS Core) as SAP Integration platform and the Business Content for SAP customer master data management -¬†Dynamics 365 CRM Account - Microsoft Flow as workflow Let me give you more details about the scenario. The…continue reading →

Activating Datasources in the SAP OLTP System

To be able to extract OLTP Datasources from SAP ERP, you first of all have to activate the relevant DataSources in the SAP OLTP system. After activating the DataSources you can extract data from all the active DataSources using the DeltaQ component. Thoses steps have to be carried out in the SAP ERP system (OLTP). No SAP BW system is required. 814continue reading →

How to open SAP GUI from browser

In this blog I will show how to launch SAP GUI from IE Browser using Javascript. In Javascript we will use an ActiveXObject (wscript.shell) to call SAPshortcut.exe with the required parameters to open the SAP GUI. The result should be as the following: 684continue reading →