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 →

Connection Scope for Nintex Workflow Custom Actions supported

Some SAP integration scenarios require several function modules to be executed in a row in order to complete a process successfully. This is particularly the case for HR processes, where a personnel number must often first be locked and then unlocked  after some changes have been in the personal administration. However, this series of function calls must always take place in the same so-called "connection scope". The connection scope ensures that the functions are related. Setting up and using a connection scope is now available as a new feature in the Nintex Workflow Custom Actions in…continue reading →

Making Xtract IS available in Azure-SSIS

Introduction   **UPDATE 2018/04/20** Azure-SSIS IR has moved to public preview. Microsoft has provided this guideline on how to set up custom components in Azure-SSIS IR.  It's basically the same steps we followed in our test runs. Feel free to contact us for a public preview version of Xtract IS for Azure. Please send us an email at support@theobald-software.com. We recently had the chance to test run a private preview version of the Integration Runtime (IR) in Azure Data Factory v2 (ADFv2). With Azure-SSIS, the IR offers SSIS capability through a native compute…continue reading →

Sync Salesforce to SAP in near-real time using NWC and ERPConnect Services Core

In this blog, I will describe a scenario, where a Salesforce account is synchronized in near-real time to SAP, where an SAP customer is created and his number is written back to Salesforce using the following tools: - SAP ECC system on Premise - ERPConnect Services Core (ECS Core) for SAP Integration in cloud scenarios - Salesforce - Nintex Workflow Cloud NWC as workflow ECS Core enables you to build powerful and sophisticated cloud applications for SAP on Premise. It allows you to integrate your cloud-based apps with SAP. For that ECS Core…continue reading →