This blog will focus on creating data sets from SAP in the form of SQL queries.  Once you have the query, you can easily turn it into view, and report on it using any front end reporting tool you choose.  You can also use the query/view to load analytics engines for building cubes.  The views are also an ideal way to feed the SQL 2012 in-memory tabular data model.

The database platform for all the blog entries will be Microsoft SQL Server.  The SAP tables come from an SAP system running the Simplement Data Libertor (SDL). The SDL provides SAP data (whether SAP is running on Oracle or SQL Server) in real-time in an MSFT SQL Server environment.

I work for Simplement, but this isn't a sales blog.  I'll make self-contained samples so that you don't you need the SDL to run the samples and follow the articles in this blog.

Most posts will be contain a "Summary" section and a "Detail" section.  If you're in a hurry, just read the Summary and skip the Detail.  The Summary section will have links to the sample outputs, the sample data and the code you need, and a brief description.   The Detail section will have more thorough descriptions that explain the code in depth.