Informatica PowerCenter was data integration technology designed to form the foundation for data integration initiatives, application migration, or analytics. It is a legacy product.
N/A
SAP BusinessObjects Business Intelligence
Score 7.1 out of 10
N/A
The SAP® BusinessObjects™ Business Intelligence Platform provides users with ad hoc queries, reporting, data visualizations, and analysis tools. Its integrated, unified infrastructure aims to offer scalability from one-to-many tools and interfaces on-premise, in the cloud, or as a hybrid approach.
N/A
Pricing
Informatica PowerCenter (legacy)
SAP BusinessObjects Business Intelligence
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Informatica PowerCenter (legacy)
SAP BusinessObjects Business Intelligence
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Informatica PowerCenter (legacy)
SAP BusinessObjects Business Intelligence
Considered Both Products
Informatica PowerCenter (legacy)
Verified User
Manager
Chose Informatica PowerCenter (legacy)
PowerCenter is simply so robust and refined that most other apps cannot do as much as it can. Even Informatica’s own Cloud version is so anemic as to not even compare against it. While from that perspective it feels bloated with too much to navigate through, many of those …
1.- Scenaries with poor sources of data is not recomended (Very bad ROI). The solution is for medium-big enterprises with a lot of sources of data and users. 2.- Bank and finance enviroment to integrate differente data form trading, Regulatory reports, decisions makers, fraud and financial crimes because in this kind of scenary the quality of data is the base of the business. 3.- Departments of development and test of applications in enterprises because you can design enviroments, out of the production systems, to development and test the new API's or updateds made.
As mentioned earlier reporting was a big headache for us and the tools we used didn't support large data sets and visualization Performing analytics with such data sets was cumbersome and later post using this SAP BusinessObjects Business Intelligence we were able to correlate different data sets and prepare the dashboard pretty easier which were helpful and easier to understand.
Informatica Powercenter is an innovative software that works with ETL-type data integration. Connectivity to almost all the database systems.
Great documentation and customer support.
It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, BigData which can be used to analyze data and correct it.
This software is easy to initially learn, and very powerful in producing reusable reports.
It is much faster than my company's internal manual queries. The ability to build off of a saved query and share queries to other users is a great positive.
My favorite part is that you can run queries in the background and it does not interfere with your current work or slow your computer down.
There are too many ways to perform the same or similar functions which in turn makes it challenging to trace what a workflow is doing and at which point (ex. sessions can be designed as static or re-usable and the override can occur at the session or workflow, or both which can be counter productive and confusing when troubleshooting).
The power in structured design is a double edged sword. Simple tasks for a POC can become cumbersome. Ex. if you want to move some data to test a process, you first have to create your sources by importing them which means an ODBC connection or similar will need to be configured, you in turn have to develop your targets and all of the essential building blocks before being able to begin actual development. While I am on sources and targets, I think of a table definition as just that and find it counter intuitive to have to design a table as both a source and target and manage them as different objects. It would be more intuitive to have a table definition and its source/target properties defined by where you drag and drop it in the mapping.
There are no checkpoints or data viewer type functions without designing an entire mapping and workflow. If you would like to simply run a job up to a point and check the throughput, an entire mapping needs to be completed and you would workaround this by creating a flat file target.
The installation can be very complex and time-consuming, it requires a lot of planning and foresight as to what role the software will play in the organization.
The software has a relatively large learning curve that takes dedicated users months to get comfortable with, the UI is a bit intimidating for new users.
SAP could organize their help better, it can be difficult to find dependable solutions to issues via their website and support channels.
The institution has decided to move in a different direction, and will be using MSBI for reporting. I have been very happy with the Business Objects suite of tools, and will continue to use them heavily until we make the transition.
Positives; - Multi User Development Environment - Speed of transformation - Seamless integration between other Informatica products. Negatives; - There should be less windows to maintain developers' focus while using. You probably need 2 big monitors when you start development with Informatica Power Center. - Oracle Analytical functions should be natively used. - E-LT support as well as ETL support.
From a server and client side perspective. the Business Intelligence Platform provides a foundation for all aspects of content development, distribution, analysis, collaboration and self service. Ease of use from targeted content delivery through controlled accessibility. Content exporting in the format of the users choice. Scheduling for internal or external delivery. Public and private folders for secure content access when requied. Web based for viewing on the users device of choice without the need to download additional applications.
PowerCenter is robust and fast, and it does a great job meeting all the needs, not just the most commercially vocal needs. In the hands of an expert power user, you can accomplish almost anything with your data. It is not for new users or intermittent users-- for that the Cloud version is a better fit. Be prepared for costly connectors (priced differently for each source or destination you are working with), and just be planful of your projects so you are not paying for connectors you no longer need or want
Overall, the tool (Web Intelligence 4.2) is fast and solid. One issue is a dependability on JAVA for a full feature report creation/edit capabilities (as opposed to limited HTML option). Second, planned end of JAVA support by major browsers (Chrome is already not supporting JAVA applet).
Informatica power center is a leader of the pack of ETL tools and has some great abilities that make it stand out from other ETL tools. It has been a great partner to its clients over a long time so it's definitely dependable. With all the great things about Informatica, it has a bit of tech burden that should be addressed to make it more nimble, reduce the learning curve for new developers, provide better connectivity with visualization tools.
SAP has released various versions of SAP BO BI. starting from 3.1 and going to 4.0,4.1,4.2 and latest being 4.3. SAP provides support to these new versions. As new versions keep on coming, support for the very old software goes out of scope from SAP. it is when the different organization plans to get their BO content migrated from a lower version to a newer version. The newer version had definitely added functionality and features which ease the work of users.
Hire specialists and experienced staff. Mix some beginners so that everyone is not a leader but a learner too. Plan well; architect well; break down implementation in small steps and move towards larger steps. Create a centralized and authorized SAP Business Objects implementation team.
While Talend offers a much more comfortable interface to work with, Informatica's forte is performance. And on that front, Informatica Enterprise Data Integration certainly leaves Talend in the dust. For a more back-end-centric use case, Informatica is certainly the ETL tool of choice. On the other hand, if business users would be using the tool, then Talend would be the preferred tool.
We selected SAP BusinessObjects Business Intelligence (BI) based on price. It can stack up against others in terms of price and honestly, that's about it. Salesforce Commerce does a hell of a better job at handling it. However, in the space of Business Intelligence, SAP can do more, and that's why at the end we went with it
SAP BusinessObjects Business Intelligence (BI) Platform supports SOA Service Oriented Architecture. You can start/restart/enable/disable all the servers. You can seamless do load balancing and clustering. It supports all leading application and web server. Supports LDAP SSO integration. People who can work on excel with training they can work on SAP Business Objects Web Intelligence, dashboard, Lumira, Information design tool product suite. Tool is very user friendly and easy to learn and implement
The data pipeline automation capability of Informatica means that few resources are needed to pre-process the data that ultimately resides in a Data Warehouse. Once a workflow is implemented, manual intervention is not needed.
PowerCenter did require more resources and time for installation and configuration than was expected/planned for.
The lack of or minimal support of unstructured data means that newer sources of dynamic/changing data cannot be easily processed/transformed through PowerCenter workflows.
By generating and distributing reports in a timely manner, we were able to save millions of dollars for the company which otherwise would not have been visible.
Almost realtime dashboard, saved the company a huge amount by showing the outages and kept the company from buying a tool to do just that.
It showed the customers who were not paying the bills and were missing in the system due to some loophole. This was visible by doing reporting on the theft usage of electricity.
