Integrated Capabilities – Impressions from the MBAS 2019

Last week, our team from Theobald Software was at the Microsoft Business Application Summit which took place in Atlanta, GA from June 10 – 11. For us, it was the first time as a sponsor and as attendees at the Summit, and it exceeded our expectations in many ways. This year’s event brought together over 3,500 experts, users, and business leaders from 30 countries to connect and learn about all things related to Dynamics 365, Power BI, Excel, PowerApps, Flow, and even Mixed Reality. Keynote takeaways James Phillips, Corporate VP of the Business…continue reading →

Xtract Universal provides SAP Integration in Alteryx

Alteryx, the Leader in Self-Service Data Analytics, provides analysts with the ability to easily prepare, blend, and analyze all data using a repeatable workflow, then deploy and share analytics at scale for deeper insights in hours, not weeks. Xtract Universal, an SAP Connector from Theobald Software, enables you to save data streams from SAP to different destination environments, and thereby significantly reduce development time, thanks to a high degree of automation. We launched an Alteryx Destination for Xtract Universal that makes it easy to integrate SAP data and Processes using Alteryx. 1342continue reading →

Connecting Datazen with SAP

In this article, we will see how to integrate SAP data into Datazen. Datazen Software is a mobile business intelligence and data visualization service and has been acquired by Microsoft in April 2015 to accelerate its Power BI strategy. If you have Microsoft SQL Server 2008 or later Enterprise Edition and Software Assurance you are entitled to download the Datazen Server software at no additional cost. As an SAP Connector I will use Xtract Universal to extract sales data from SAP BW using a query. In Xtract Universal I will use the OData…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 use an SQL Configuration Table with Xtract IS

SQL Server Integration Services (SSIS) provides package configurations that you can use to update the values of properties at run time. In this blog I will show how to store your package configuration in an SQL table. In my sample I will use Xtract IS to load the SAP table T001 for company codes using a where statement. The goal is to use the SQL configuration table to update the value of the where statement and the value of the SAP connection string. 785continue reading →