New Xtract Universal destination for Salesforce

When it comes to SAP integration with other technical environments or software there are some considerable new developments and players which have to be taken into account.  One increasingly important fish in the big pond of IT business solutions is Salesforce. Salesforce is a US-based world leading enterprise application for customer relationship management (CRM). Whereas Salesforce is widespread and well-known in the United States it is only of moderate importance in Europe for the time being, but nevertheless expanding with high growth rates. One characteristic of Salesforce is that it is a pure…continue reading →

SAP integration for Office 365

There is an unmistakable trend towards migrating IT solutions into the cloud. Software applications running in the cloud offer a new range of opportunities to enterprises and private users alike. With Office 365, Microsoft provides an online platform that enables users to access their everyday business applications like email, calendar, file sharing, instant messaging, Office Online, etc. from anywhere. Integrating external data with Office 365 however is difficult by using out-of-the-box features. Nevertheless there is a growing demand to integrate external business data like SAP to cloud environments. All the more a reason for…continue 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 →

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 →

Processing incremental data load of SAP datasources (extractors) with Xtract QV and QlikView

Incremental data load (delta load) is a very common task when extracting data from SAP, especially when extracting a big amount of data (e.g. transaction data like accounting line items). SAP delivers business content datasources (i.e. extractors) that can be extracted using the DeltaQ component in Xtract QV. Many of those extractors provide a delta mechanism (Update mode) that is managed by SAP. Executing an extractor in the Delta update mode delivers new, changed or deleted records since the last extraction. This sample uses the SAP extractor 0CUSTOMER_ATTR (for Customer Attributes) to develop…continue reading →