Try our new research platform with insights from 80,000+ expert users
Professor of Economics of Informatic at CMAYOR
Real User
Enables seamless integration of diverse data sources for effective analysis
Pros and Cons
  • "My overall experience with Informatica PowerCenter is positive."

    What is our primary use case?

    I use Informatica PowerCenter for data warehousing. I integrate information from multiple sources, including IBM and Oracle databases, into a uniform form for data warehousing. This ensures that the data is ready for analysis.

    What is most valuable?

    A significant feature of Informatica PowerCenter is its ability to integrate a wide range of data sources, such as those from IBM and Oracle, into a uniform form for processing in a data warehouse. This integration capability is beneficial for preparing data for analysis. The system supports real-time integration, which is essential for many of my tasks.

    What needs improvement?

    To improve Informatica PowerCenter, I suggest enhancing the performance, especially when processing large amounts of information in Oracle databases. Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.

    For how long have I used the solution?

    I have been using Informatica PowerCenter for more than ten years.
    Buyer's Guide
    Informatica PowerCenter
    February 2025
    Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
    839,422 professionals have used our research since 2012.

    What was my experience with deployment of the solution?

    I have not encountered any issues with the deployment of Informatica PowerCenter.

    What do I think about the stability of the solution?

    Informatica PowerCenter is stable and can scale well. Whenever I have had to scale, I have always been able to accomplish this using the available resources.

    What do I think about the scalability of the solution?

    Informatica PowerCenter is a scalable solution. I am always able to scale and expand my systems as needed.

    How are customer service and support?

    I like the technical support provided by Informatica. It is satisfactory, and I have had positive experiences with it.

    How would you rate customer service and support?

    Neutral

    How was the initial setup?

    The initial setup of Informatica PowerCenter can be challenging. Although the installation process is automated, it requires a thorough knowledge of Informatica, Oracle, and databases to troubleshoot any arising errors.

    What about the implementation team?

    During installation, it is helpful to have knowledge of Informatica and databases to address any errors that may arise. It is possible for one person to handle the installation if they have sufficient expertise.

    What was our ROI?

    I view the investment in Informatica PowerCenter positively. It offers quality, and when you buy quality, it ultimately benefits you.

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

    I find that the pricing and licensing for Informatica PowerCenter align with its quality. The cost-revenue balance makes the investment worthwhile.

    What other advice do I have?

    My overall experience with Informatica PowerCenter is positive. On a scale from one to ten, I would give Informatica PowerCenter ten points as I am very satisfied with its capabilities.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Flag as inappropriate
    PeerSpot user
    Buyer's Guide
    Download our free Informatica PowerCenter Report and get advice and tips from experienced pros sharing their opinions.
    Updated: February 2025
    Buyer's Guide
    Download our free Informatica PowerCenter Report and get advice and tips from experienced pros sharing their opinions.