it_user430596 - PeerSpot reviewer
Sr. System Analyst at a healthcare company with 1,001-5,000 employees
Vendor
It does not require any additional plugins like for the other ETL tools.​ I would like to see its data handling improved.

What is most valuable?

SAP Business Objects Data Services is user friendly and easy to learn. It is easy to connect to SAP ECC or SAP BW, and does not require any additional plugins like for the other ETL tools.

How has it helped my organization?

Our organization uses SAP BI tools, and Qlikview for building reports for our doctors and other teams. It has helped us to build an Enterprise Data Warehouse (EDW). It helps the BI teams to build reports over this warehouse.

What needs improvement?

It needs some improvement in its performance. It handles our data great as we do not process much data daily, but we are going to process huge amounts of data. I don't think it can handle well when compared to other ETL tools. I would like to see its data handling improved.

What was my experience with deployment of the solution?

We've had no issues with deployment.

Buyer's Guide
SAP BusinessObjects Business Intelligence Platform
March 2024
Learn what your peers think about SAP BusinessObjects Business Intelligence Platform. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 professionals have used our research since 2012.

What do I think about the stability of the solution?

We've had no issues with stability.

What do I think about the scalability of the solution?

We've had no issues with scalability.

What other advice do I have?

I think this product is best if we are not loading huge data. Also for its easy to use and learn.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Business Intelligence Applications Team Leader at a energy/utilities company with 5,001-10,000 employees
Real User
It allows the analysis of business data and enables decisions based on the analysis.
Pros and Cons
  • "It allows the analysis of business data and enables decisions based on the analysis."
  • "More thorough testing of Service Packs before release."

What is most valuable?

It allows the analysis of business data and enables decisions based on the analysis. I found the SAP suite of products powerful. They scale well for enterprise use, i.e., thousands of recipients of the output of the products as dashboards and/or reports.

How has it helped my organization?

It gets people off Microsoft Excel spreadsheets and sharing the same reports/dashboards, so departments receive the same figures for KPIs and company performance.

This stopped the waste of time in management meetings, whereby people would spend a lot of time explaining different performance results (different Excel spreadsheets) so they could analyze results and plan to act on the results.

What needs improvement?

More thorough testing of Service Packs before release.

For how long have I used the solution?

I have used Webi, Universe Designer, and Dashboards for 12 years. I’ve used Lumira for one year.

What do I think about the stability of the solution?

We had stability issues, mainly with the integration of the SAP BI products with SAP’s EIM products (Data Services, Information Steward). We had some instability when applying patches and new releases.

There was poor quality of the testing of new functionality introduced in new releases.

What do I think about the scalability of the solution?

We have not really had scalability issues. The readiness of the products for the enterprise was a strong point.

How are customer service and technical support?

Customer Service:

Patchy. Depending on the product with the issue (eg WebI or Information Steward) the responses can be good (WebI) or awful (Information Steward).

Technical Support:

Technical support was hit and miss. Sometimes it was good. Other times it was awful. Especially when the problem raised was hard for them to reproduce. They often ask the same questions over and over.

Which solution did I use previously and why did I switch?

We didn’t have a previous solution. We have pretty much been an SAP BI shop for a long time.

How was the initial setup?

Setup was quite complex due to the number of environments being used (Dev/SIT/UAT/Prod) and the integration between BI and EIM products. It is even harder now that we use SAP HANA.

What about the implementation team?

Implemented in-house.

What's my experience with pricing, setup cost, and licensing?

Make sure you factor in plenty of time for regression testing as the way SAP release Service packs these days there is good (new functionality) and bad (lack of thorough testing) news.

Which other solutions did I evaluate?

Over the years, we have reviewed other BI products, such as IBM Cognos and Tableau. Some of them are also in use along with the SAP BI products.

What other advice do I have?

Check the number of intended users and which part of BI you are intending to introduce (reporting, analytics, etc.).

Check out the free trial periods and see if there are options to use cloud computing versus installing it in your own data center.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
SAP BusinessObjects Business Intelligence Platform
March 2024
Learn what your peers think about SAP BusinessObjects Business Intelligence Platform. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 professionals have used our research since 2012.
it_user6663 - PeerSpot reviewer
BI Expert at a transportation company with 51-200 employees
Vendor
SAP Business Objects vs. Microsoft BI

A quick look at the whole idea on another weblogs gives you a sense that all of them just talked about very brief things like report refresh feature in BO or cube feature in MS Analysis Service. I choose MS BI and I want to share my reasons and opinions on why I choose it and give you another quick but a little deeper compare on these two BI platforms.

As we all know both Business Objects and Microsoft are big companies who are working on BI solutions and both have their own advantages. It’s not true to compare them in term of which one is better, we have to check what is our requirements and then depend on requirements take the decision whether MS or BO. A vision like this could help us relief from religious decisions against a software or technology.

In a BI architect first of all we have the data store level, I mean the storage of the raw data not the stage or olap cubes or universe data source, I mean the first place of our data. This is important to know that where your raw data is and what is the type of storage used to store them. Whether file system or Access or Fox database or a complex database solution like oracle, sqlserver or a web service can made our place of raw data. We have to check our tools against them; check to see which one gives us a smooth way to transfer them among ETL process to destination. So take a look at what Business Objects gives us.

There is a Data Integration platform in Business objects but the problem is that you have to buy that separately because it is not shipped with the BI system. In Microsoft sqlserver enterprise you have all the services and features needed for this part of the game. SSIS is the service that sqlserver deliver for data extract, integration and load. Both product gives you the ability to enhance the data quality and data cleansing portion of your integration phase, but when we down to details things change a little to the Microsoft side, because of the ability of using your Dot.Net knowledge to write complex parts of ETL process you have more room to think and do whatever you want in your process, and in BO side it is always look simple and it’s really not easy to take complex situation into it. There are advantages and disadvantages on this. First you can do many things with the ability of dot.net code but it could give you complexity in your development so you have to decide on your situation, if things looking normal both could fit your need, but if the situation is not stable and you have to make yourself ready for the changes in future it’s better to get the power of SSIS and spend a little more time development today to create a powerful and easily changeable mechanism that could help you in future. You can also do that with Business Objects Data Integration but you have to spend more bucks for the development and changes of ETL processes because development cost in Business Objects solutions is always a nightmare for a project.

At this point we have a brief understanding of differences in ETL process between two vendors, so it’s good time to take a look back to the source database. Here is a very quick answer, if you use mostly MS products to store your transactional data then take your decision and move to MS for a robust and compatible BI platform. Business Objects don’t have a database system and it always used other database solutions to store data for its universe.

So guess what happen ! from an administrator perspective performance tuning is somehow problematic ! since we should use other database systems we should use different technics for each database systems. And this is one of the areas that MS wins the competition because when you use Microsoft platforms there lots of joint mechanism for performance considerations.

Before the SQL Server 2012 we have SSAS with its famous aggregated cubes, because of the nature of SSAS in previous versions we couldn’t call it a semantic layer, here is a little why. A semantic layer provides translation between underlying data store and business-level language(Business semantic that business users familiar with). There was no actual translation in previous release of SSAS. Perhaps we had some difficulties over SSAS to understand for a business user. So Microsoft change its approach in SSAS 2012 from delivering a complex understandable solution to end users to a true semantic layer like what we has in Business Objects that called Universe. So from now MS BI users can use a powerful toolset like Microsoft Excel and use their existing knowledge to interact with semantic layer. What Microsoft do in backyard is to create aggregations in memory so the performance of this approach is really high ! I don’t want to deep dive into what Microsoft do in backyard in this post but it would be one of my next topics. (sounds like advertisement :D )

I talked about aggregations so know that in BO there are no facility for aggregation tables, so you have to deal with DBAs to create aggregation tables manually and integrate them into the Universe.

One of the important aspects of a BI system is the learning curve of the solution, it was always the slogan of the Business Object that learning curve is very low ! yes for end users it is not hard to interact with Universe. BUT ! the thing that I say here is the problem of every BI platform from Microsoft to BO or Cognos that deliver Semantic layer, it is very easy for a user to get the wrong answer, because everything is behind the Universe or Semantic Model and know that tracking from report back to the base data is a Non-trivial task. So be aware about letting users create whatever they want with their own knowledge. There should always an IT professional observing the whole process. So never think about a fully out of the box solution, because you will shortly find it on Mars ! or your users may have the chance to take decisions based on wrong calculations and find their way to Mars again :D

Another important aspect of a BI systems is the cost of it, about the Business Objects we can definitely say that it is expensive and for sure Microsoft could be expensive ! but how can we decide ' the answer is to compare the detail parts, there are 4 main parts Database, ETL, Semantic Layer and Reporting or user interaction layer. If you choose to go over BO you have to find heads for your data warehouse, database solution and Java skills or tomcat or other J2EE platform professionals for ETL and development phase and BO specific heads for Universe Modeling, Design, Implementation, perhaps you need security administration and if you want to integrate your Active Directory with this platform it is problematic and integrating with other LDAP platforms is a nightmare ! so be aware of these costs. The point of Microsoft solution is that we can use our in house knowledge like Dot.Net and SqlServer, SharePoint, Windows Server and these knowledge are transferable to other skills. But with BO we need headcount dedicated to BO (Universe Design, Implementation, Maintenance, Security) since BO skills are not transferable to other skills, those extra heads blow the project’s budget ! Microsoft BI platform is a more manageable, more secure and less expensive solution, I see the BO as a consultant dream, as an endless font of billable hours :D

Conclusion

I decide to go over Microsoft BI platform but I would not suggest anyone at first place to choose Microsoft. This is really depend on the nature and scale of the project and what you did and what technologies you have used in past but a quick look gives an idea that Microsoft’s platform is looking more robust and coherent in different parts so it can be a very good and convenient choice and perhaps after the release of SQL Server 2012 and its BI Semantic layer the answer is more easier and acceptable than before.

I also would like to hear about your experience on either of these solutions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
GaryM - PeerSpot reviewer
GaryMData Architect at World Vision
Top 5LeaderboardReal User

It was an interesting comparison with some useful insight which I appreciate but it gets muddy when you start mixing in the entire platform.

I suggest comparing just the BI tools themselves and leaving database and ETL out of it since those are completely separate decisions. Personally I love BO's semantic layer and its still (even with MS BI 2012) the fact that MS doesn't have it is a massive hole in MS's approach. Yes they now have the "tabular data model" which has potential but its such apples to automobiles comparison to BO universe which is truly just semantic model. MS's approach is an in-memory engine like Tableau or Qlikview server so not really relevant to just a pure BI/reporting evaluation. The other interesting muddy aspect is that BO has multiple tools, not just Bobj/webi and so does MS like Crystal Reports (which is often used without the semantic layer btw). MS has SSRS, Excel services, PerformancePoint, PowerView, PowerMap, Power this and power that. Everything seems to have power these days. Hope we don't get a big solar flair.

Course like someone indicated, the REAL power is in the database. Without a good database platform AND design, the BI tools are all pretty darn worthless. I would argue with the person who claims SqlServer can't handle volume - its a relative thing. Petabytes no. Gigabytes yes. That has more to do with how you build it than it does the platform. Stupid designs have stupid performance. Its usually more about the incompetence of the designer than it is the database. Unless it's my design of course - then it must be the database platform that's at fault ;-)

All that said, it would be an interesting showdown to compare the myriad of MS reporting tools to BO, Cognos, Microstrategy, Tableau, Qlikview, Excel, etc. and include pricing and learning curve in the analysis.

What I see is that SSRS is a 2 day class with no conference verses Tableau has a week long conference just on a reporting tool that's supposed to be a super easy end-user friendly tool! Am I the only one that thinks thats a bit crazy? Oh and the Qlikview 4 day conference is coming up. Don't miss it so you can find out how easy it is to use. It's so easy you have to attend a week long conference every year! Course it is in Orlando and my golf game is bit rusty...

See all 4 comments
it_user494061 - PeerSpot reviewer
SAP Certified BI, BOBJ, BODS Consultant at a healthcare company with 501-1,000 employees
Vendor
It provides a unified view of business processes across the organization, and helps control massive amounts of information.

What is most valuable?

  • Data integration
  • 64-bit architecture

What needs improvement?

I would like to see the capability to directly access social media data.

For how long have I used the solution?

I have been using it for 14 years.

What was my experience with deployment of the solution?

We have encountered so many issues when the architecture and design was fragile.

How are customer service and technical support?

Technical support is 10/10.

Which solution did I use previously and why did I switch?

I previously used Microsoft DTS. Microsoft BI products are ideal for small-scale businesses. whereas SAP BusinessObjects is suitable for enterprise-level implementation.

How was the initial setup?

If you have the skills and time, initial setup will be easy.

What about the implementation team?

I worked for both vendor teams and in-house teams. I have been involved in the implementation of complex BI solutions on the SAP BusinessObjects Enterprise platform in major USA and Canadian companies across different industries.

For successful implementation, you need a technical expert who has specialized in the area of Extract, Transform, and Load (ETL) with in-depth knowledge of the data warehouse lifecycle processes (DWH design and ETL development) and extensive hands-on experience with both the SAP Enterprise Information Management (SAP Data Services) technology stack and the SAP BusinessObjects reporting products stack (IDT, Universe, Web Intelligence, Designer, Dashboards).

The manager should be from the in-house (for decision making) team and the technical experts should be from the outside (vendors and consultants).

What's my experience with pricing, setup cost, and licensing?

SAP has different kinds of licensing for mid-size to large enterprises.

What other advice do I have?

If you want to implement SAP Analytical applications, you need skilled resources with clear requirements.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Manager of Architecture/Design at a government with 501-1,000 employees
Real User
License price is prohibitive and it should go back to CPU based. Connectivity with databases is good.

What is most valuable?

  • Universal concept
  • Connectivity with databases
  • Good visualization

How has it helped my organization?

It's improved decision making process.

What needs improvement?

  • Better visualization
  • Better portal
  • License price is prohibitive should go back to CPU based
  • Improve customer service.

For how long have I used the solution?

I've used it for five years.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

We had no issues with the stability.

What do I think about the scalability of the solution?

I've had no issues scaling it.

How are customer service and technical support?

Not good. SAP does resolve issues in time.

Which solution did I use previously and why did I switch?

We are retiring SAP Business Object Webi and Xcelsius, they will be replaced by IBI Web Focus.

How was the initial setup?

The security set up is complex, and there are compatibility issues with Internet Explorer.

What about the implementation team?

We built some dashboards and an application brought some reports out of the box.

What was our ROI?

It is too expensive, charging by user and if you have hundreds of them you won’t be able to get ROI not even in many years.

What's my experience with pricing, setup cost, and licensing?

Be careful with the license model. If you want to promote personal BI or ability to run your reports in disconnect/passive mode this is not the product.#

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Ariel Lindenfeld - PeerSpot reviewer
Director of Community at PeerSpot
Vendor
Gartner's Magic Quadrant report says that SAP customers report software quality as an obstacle to wider deployment

In the February 2013 Magic Quadrant Report, Gartner says that SAP customers report software quality as an obstacle to wider deployment. Additionally, customers expressed dissatisfaction with SAP support.

Are you a Real User of SAP BO? Have you found this to be the case in your organization?

If you are a user or are evaluating SAP BO, add your comment below or write your own review. Share your opinion with our community!

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user6579 - PeerSpot reviewer
it_user6579Engineer at a tech services company with 1,001-5,000 employees
Consultant

SAP Business objects is one of the great tool which helps in taking confident decisions by connecting people, information and businesses across business networks. Though it comes with the price which can be costly for small to medium sized organizations. Though it has various features and SAP BusinessObjects Explorer is one of them, which provides intuitive user interface to search and explore the business data.

See all 3 comments
it_user6969 - PeerSpot reviewer
Consultant at a tech consulting company with 51-200 employees
Consultant
Considerations for Upgrading from Business Objects Enterprise 3.1 to 4.0

I recently performed an upgrade from SAP Business Objects 3.1 to the SAP BI Platform 4.0. In the process, I noted a few idiosyncrasies you should consider if you plan to upgrade your 3.1 environment. Not all of these items may pertain to everyone but you should at a minimum consider them when planning your upgrade. These three items include Connections, Excel and Life Cycle Management (LCM).

The first topic is Connections and only need addressed if you are using Universes in your current 3.1 environment. For those with only Crystal Reports in the environment that do not access Universes, this does not apply. Specifically, it addresses Custom Access Levels that you may currently have in the environment. In order for users to access Universes in 4.0 you need to ensure the following rights are granted within the Custom Access Level. Under the System category, you should see Connections and Relational Connections. Under these subheadings, ensure that Data Access is granted for both of these items. The migration will only enable rights to Connections, not Relational Connections. You will need to grant Data Access to the Relational Connections otherwise users will not be able to refresh Universes.

The second topic is Excel. If you current 3.1 environment includes reports that are scheduled with a format of Excel, consider the following. During the upgrade, these reports get transformed to use the new DLL’s in the 4.0 environment. The reason this may present an issue is that the 3.1 environment saves to an .xls format whereas the 4.0 environment will save to an .xlsx format by default. You will have to determine if the organization has Microsoft Office 2007 or above in to order to read these files. If not, then you should note all of these schedules and change to the prior Excel format, or ensure that all of the client machines have the ability to read and open .xlsx formats.

The final topic is relevant to almost everyone in the 4.0 environment, since LCM needs to be installed on the 4.0 environment. However, this specific ‘gotcha’ only occurs if you change the default port for LCM. The default port for LCM is 3690. In Support Pack 4 and above, Version Management is an item in the Central Management Console under Manage. If you changed ports and click on this item you will be prompted for a system, user name, a password and authentication mode. As part of the SAP Business Intelligence Platform installation using Windows, it installs a service called LCM_Repository which uses port 3690. The port number you enter during the installation of the Platform is only the port number that the platform looks for and not the port number in which the subversion tool gets installed by default. In order to change this port so that it can start the LCM_Repository server at the correct port number you need to use the regedit tool. Note that any time you edit the registry there are profound implications. Please only do so if you are sure you’ve exhausted other issues and know for a fact that this is your problem. Peform a search for the LCM_Repository service and you should see the command line as one of the registry items. Add the following item to the string in the registry key –listen-port PORT. Where PORT is the port number that you told the platform to look for during the installation.

These are but three specific items to keep in mind when upgrading your SAP Business Objects Enterprise platform. Ideally you will provide ample time and attention to planning your upgrade prior to diving it. It will make your journey to the newest version much smoother and reduce downtime and other negative impacts.

Disclosure: My company is partners with SAP Business Objects, Microsoft & QlikView

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Strategic Account Manager at a comms service provider with 5,001-10,000 employees
Real User
Useful for development, reliable, and scalable
Pros and Cons
  • "The development using SAP BusinessObjects Business Intelligence Platform is very good."
  • "The solution can improve by having more analytical features."

What is our primary use case?

The solution can be deployed on-premise and in cloud environments. We are using Microsoft Azure and Amazon AWS for cloud services.

Our main use case for the use of this solution is for reporting.

How has it helped my organization?

The solution has given us multi-systems and databases that have been very good for us.

What is most valuable?

The development using SAP BusinessObjects Business Intelligence Platform is very good.

What needs improvement?

The solution can improve by having more analytical features.

For how long have I used the solution?

I have been using the SAP BusinessObjects Business Intelligence Platform for approximately nine years.

What do I think about the stability of the solution?

The stability of the solution has been good.

What do I think about the scalability of the solution?

I have found the scalability to be good.

What other advice do I have?

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free SAP BusinessObjects Business Intelligence Platform Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Buyer's Guide
Download our free SAP BusinessObjects Business Intelligence Platform Report and get advice and tips from experienced pros sharing their opinions.