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 →

Connecting Power BI in Office 365 with SAP

Scheduled Data Refresh in the Cloud In this article, we will look at how Power BI workbooks in Office 365 can be automatically refreshed with data from on-premise SAP data sources. With Microsoft’s Data Management Gateway, on-premise data sources can be connected with Power BI workbooks in Office 365. You can use the Data Management Gateway to schedule automated data refreshes and provide your Power BI users with up-to-date reports and business insights in the cloud. Connecting to on-premise SAP data In previous articles on the topic of Connecting Power BI with SAP,…continue reading →

How to build perfect SAP Integration using Xtract Universal and Kettle

In this blog I will show how to use Kettle to run SAP extractions created with Xtract Universal to load it into an Oracle Database. Xtract Universal is an SAP connector by Theobald Software, a leading vendor of SAP Integration products. Xtract Universal supports integration of your SAP data in the most different target systems, like SQL Server, Oracle, IBM DB2, Teradata, flat files and others – fast, straight-forward and user-friendly. Kettle (aka Pentaho Data Integration (PDI)) is an open source data integration (ETL) engine that allows the user to define data integration…continue 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 →

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 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…continue reading →