Kategorien
.net Process Automation SAP

Calling SAP BW EasyQuery from C# .Net

EasyQuery is SAP´s newest technology for providing external access to SAP BW via Web Services. Unfortunately there is not a whole lot information out there on how to actually call an EasyQuery Web Service other than from SAP standard tools like BO Design Studio, etc.So here I’ll give a detailed introduction on how to call […]

Kategorien
.net SQL Server

Delta Loading a Table with SqlDeltaGenerator

In my previous Post I did describe what needs to be considered to implement a fast and stable delta load process. In this post I am going to introduce a tool that will help you to implement such a process within a couple of minutes. The SqlDeltaGenerator is basically a wizard that will create all the […]

Kategorien
.net SQL Server

How to implement a stable delta load process

This article describes two different approaches for loading data from a source system into a staging area of a Business Intelligence system. Full Load and Delta Load. Both approaches can be used to load a table like structure like below from either a database table, a CSV file or a Web Service into a staging table. […]