Skip to Content
Author's profile photo Dan Everett

Integrating ERP and BI

Mapping the data in source systems to BI reports and dashboards is where companies spend the most time and money, in both initial development and ongoing maintenance. Transactional systems typically have complex data schemas that span multiple functional modules and utilize thousands of relational tables. In addition, the names used for tables and columns are often cryptic, which makes it difficult to decipher what data a table contains unless you’re familiar with a particular transactional system.


Further complicating the integration process is the fact that an application programming interface (API) must be used to access the security mechanisms and business logic of the transactional system. And it’s common for the joins used in BI reports to be broken by transactional system upgrades because column and table names get changed, columns are added to or deleted from tables, or whole tables are added/deleted.


Unlike a generic BI tool, business intelligence in SAP Business All-in-One comes preconfigured, which help reduce the time and cost associated with implementing and maintaining reports and dashboards. To see a product demo go to the following page on

Assigned tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Dear Dan
      Could you please start blogs like this with a sentence like: ”Warning this is a commercial”. Section 1 and 2 of your blog states well known problems in the extraction phase and as a reader I’m asking “What is he aiming at” and then it’s revealed that you want to sell something. Please move your conclusion up in the text so that I do not waste my time.

      With Kind Regards
      Kristian Appel

      Author's profile photo Dan Everett
      Dan Everett
      Blog Post Author
      I will be mindful of that in future posts.
      Author's profile photo Former Member
      Former Member
      You are foregiven (;-))
      There is a tendency at the moment that the Blogs are changing in nature. More (I think) is promoting something either products or events. As I see it it is a kind of spam. I would like to read intelligent blogs, but spare me for the commercials.

      With Kind Regards