SAP-R/3 is one of the most common ERP applications for manufacturing industries. The data warehouse for such installations has been Oracle. The biggest pain point for Oracle implementations has been getting the data out of SAP-R/3, which involves complex processes and expert domain knowledge. With the introduction of SAP-BW, the data warehouse suite, ’Getting the data out’ of SAP-R/3 requires little effort. Over years, SAP-BW has matured to handle large data volumes and meet the service level agreements for large enterprises. The question then arises, especially for those organizations with an Oracle data warehouse, if moving to SAP-BW makes long term sense. There are several factors to be considered, the core being organizational commitment and long term vision. One of the factors is understanding the differences between SAP-BW and Oracle within the context of an enterprise data warehouse. Read more
Tag Archive for: SAP BW
IBM-Cognos 8 and SAP
One of the advantages that IBM-Cognos 8 brings to the table in any implementation is the ability to handle varying data sources. One particularly complex data source that is often encountered is SAP BW. IBM-Cognos has invested heavily in this integration, giving SAP customers the potential to significantly enhance the value they get from information stored in their BW instances.
SAP customers have a unique situation in that SAP BW is a strongly viable solution as a Data Warehouse for their SAP sourced data. Companies who run soley SAP transactional/ERP systems should consider heavily the value of SAP BW. The value of the standard content/extractors SAP provides, very likely outweighs the limitations/complexities which plauge implementations that are not 100% SAP. On the other hand companies that are heterogeneous (The category I believe 95% of companies are actually in), need to weigh a variety of factors when deciding on a Data Warehousing strategy. Ironside has experience in advising customers and weighing these factors towards an end of an appropriate data warehousing strategy.
The decision on which path to travel (BW vs Traditional SQL DW) should not be taken lightly as the implications are significant. Simply put, a technology decision should be able to be made using quantitative methodology. Although, often times this method is skewed by the scorecard author’s bias. Other factors needing to be considered, non-SAP data sources, the relative cost and availability of technical resources, as well as fluidity of business strucutures (ie propensity for an organization to change, significant meta data volatility, …), are significant in their impact on technology decisions.
This being said, oftentimes a Business Intelligence decision is made independent of Data Warehouse strategy. BI teams are expected to deliver often complex requirements sourced from databases originally built to service different requiremenst. This is where the biggest challenges and yet the biggest opportunity exists for Business Intelligence teams. Transformation on the fly of business data is one of the most promising yet problematic capabilities of BI solutions.
Prior to IBM, Cognos has long toughted it’s strategic relationship with SAP. Practically speaking, I believe that two organization with different and sometimes competing intentions do not always end up in the same place at the same time as a result of conflicting priorities.
I believe that as a resultof IBM’s involvement/influence in the Cognos/BW product direction, we have seen significant transparancey and progress toward a much better solution.
I’ll admit that we have experienced some challenges, in implementing Cognos reporting off of SAP. Very often expectations and understanding are the beginning seeds of frustration, and the run time transformation mentioned above leads to performance concerns.
IBM has released a whitepaper titled: “IBM Cookbook for IBM Cognos 8.4 for use with SAP Netweaver BusinesS Warehouse”. This is a very detailed resource for those who use, or plan to use Cognos 8 with SAP BW. Obivously nothing is a subsitute for experience, Ironside has consultants who can help guide you down the path to succesful implementation. But having a map like this will be helpful in getting resources up to speed as well as evaluating current configuration
The Cognos/BOBJ discussion is confusing and concerning at the same time for SAP customers who often use Cognos as their Enterprise Business Intelligence platform. In my opinion the depth and transparancy this whitepaper provides should convince you that IBM is serious about it’s support of BW as a data source.
At Ironside we have one customer who has the following databases all in use as sources from a single instance of Cognos 8:
IBM DB2, Oracle,MS Sql,Sybase,SAP BW,Access, XML Feed
Very often there are more than one of the above as a single source.
Cognos has long toughted it’s strategic relationship with SAP. Practically speaking, I believe that two organization with different and sometimes competing intentions do not always end up in the same place. Now that IBM has become involved and leveraged their strategic relationship with SAP, which from the outside looks to be much deeper.
I believe that post IBM aquisition this investment/relationship had begun to have an affect on direction and mutual understanding of
I’ll admit that we have experienced some challenges, in implementing Cognos reporting off of SAP. very often expectations and understanding are the beginning seeds of frustration
The Cognos/BOBJ discussion is confusing and concerning at the same time for SAP customers who often use Cognos as their Enterprise Business Intelligence platform. IBM-Cognos has for quite a while been trumpeting the depth of their relationship with SAP.
We have long stressed to our customers the fact that consulting assistance in planning and executing on Project including SAPBW sourced data is critical to success. This
One of the advantages that IBM Cognos 8 brings to the table in any implementation is the ability to handle varying data sources. One particularly complex data source that is often encountered is SAP BW. IBM Cognos has invested heavily in this integration, giving SAP customers the potential to significantly enhance the value they get from information stored in their BW instances.
Prior to IBM, Cognos had long touted it’s strategic relationship with SAP. Practically speaking,the alignment that existed could have been improved upon, as optimizing two very strong yet complex tools is challenging. IBM’s recent involvement and influence in the Cognos/BW product direction, armed with their long standing relationship with SAP has been positive. As consultants and implementors, we have seen significant transparency and progress toward a much better, more integrated solution, allowing Cognos/BW customers to leverage more of the Cognos 8 BI capability.
Ironside is a data, analytics, and AI consulting and technology implementation company. We work with clients to understand their business objectives and day-to-day challenges, then employ our deep expertise in data strategy, architecture and engineering, integration, business intelligence, AI, and generative AI. We create technical solutions and practical approaches designed to drive smarter, data-driven decisions across a company and help it move further and faster toward its business goals.