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
Vena
Score 8.1 out of 10
Mid-Size Companies (51-1,000 employees)
Vena Solutions provides a financial process automation solution to automate Corporate Performance Management, accounting and budgeting, Regulatory & Compliance, and other finance-related processes. It is scaled for medium to large-sized organizations.
N/A
Pricing
Informatica PowerCenter (legacy)
Vena
Editions & Modules
No answers on this topic
Professional
N/A
Complete
N/A
Offerings
Pricing Offerings
Informatica PowerCenter (legacy)
Vena
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
Yes
Entry-level Setup Fee
No setup fee
Optional
Additional Details
—
The Professional Plan is the most flexible way to get started quickly and can be added onto as a company grows. The plan includes: Vena Platform, Customer Success Manager, Standard Support and Customer Portal.
Complete Plan includes everything in Professional, plus: Vena Insights, Premium Support, Sandbox Environment, and Expert Managed Services.
For a limited time, new customers who use Microsoft Dynamics 365 Business Central (Online) as their primary ERP can get a free year of Vena and 40% off implementation costs.
Vena also offers special pricing for not for profit organizations. To learn more, speak to an expert.
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.
Vena is great for managing data and putting all of your information in one easy-to-locate spot. It also makes finding data faster and easier. It is also great for tracking project performance and budgeting. It is fairly user-friendly and easy to use from an admin side.
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.
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.
Preparing forecasts under different scenarios can be challenging. Your input templates need to be set up to toggle between the various scenarios. We found that certain templates, particularly workforce were not able to easily switch between different scenarios.
Connection to Bamboo - initial testing of this resulted in the history being deleted and only showing the current employees. For us it was important to have the history in Vena.
No native connection to Tableau - while a CSV upload is a way around would be great to have this since you already have a Power BI connection.
Vena has been a huge win for us as an organization, as it vastly improved our budgeting process by removing manual consolidation that was incredibly time consuming, and it allows us to see a multi-year view of our organizational budget across all of our funding sources. We've seen Vena's platform grow over the years and we've not yet fully adopted some of them so it feels like there's still potential to get even more value out of the platform.
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.
I would rate Vena's overall usability as an 8 out of 10. Vena offers a user-friendly interface, especially for those familiar with Excel, making it relatively easy to use. Most features are intuitive. However, some advanced functionalities may require more training or time to master, so it's not a perfect score. Overall, Vena provides a solid user experience that supports efficient financial planning.
Vena has been available and running. There are notifications well ahead of scheduled maintenance and so far, scheduled maintenance has been occurring during off hours and fortunately has not occurred during a time that is crucial for us to be actively using.
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
Vena Solutions pages load quickly and only a few times does it get a bit slow, only when there are many integrations and the reports are long. But in general it is always fast and honestly I am very satisfied with the speed in the generation of statistical reports and the pages
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.
They are very quick to respond when you submit a ticket and typically fix issues quickly as well. I only didn't give this a 10 because there is still an open issue with our Salesforce connection that we've been waiting on now for a few months.
Our initial in person training was a little rough b/c I felt like our trainer wanted to focus on maximizing Vena rather than understanding what we were needing for our organization. He was very responsive and added insights, but could have worked to understand our needs a little better.
The training was structured as a group training to learn the basics of creating a data model and mapping a template. While we had nearly 10 participants, I was the only actual implementer so we probably didn't actually need the training and could have just learned the initial skills from the implementation consultant. Two years later, when we hired a new team member, they completed several modules in Vena Academy (a self paced learning course) which allowed them to get up to speed on the basics with just a bit of supplemental guidance from me as our existing admin.
The Vena consultant had great knowledge of both the Vena solution and Excel and Excel functions. He was able to help suggest ways to build our templates that met our requirements using Excel functions we had not previously considered using. And we have been able to use the Excel information he provided in other ways outside of Vena. He was very patient and flexible as we learned the Vena tool and created templates
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.
Vena is a strong fit for teams that want to keep working in Excel while adding structure, workflows, and a centralized database. Vena emphasizes its native Excel experience, along with planning templates, workflow automation, and integrations for budgeting/forecasting.
Planful is more positioned as an end-to-end financial performance platform, with a broader emphasis on planning, budgeting, forecasting, reporting, AI/ML-driven forecasting support, real-time collaboration, and enterprise-scale (including multi-entity/multi-currency environments). It also supports Microsoft 365 reporting via Spotlight. We selected Vena because it was a better fit for our current use case and team setup:
Our Operations and FP&A teams primarily use it for budgeting and forecasting, so the Excel-based workflow made adoption easier.
It was easier to implement and simpler for users to learn and operate day-to-day.
It fit well with our need to improve planning structure without forcing a major process change.
Vena solutios is a software that provides robust tools that help different departments in their statistics and we can visualize a lot of promising and visually attractive data. Vena Solutions' level of scalability is high and sustainable over time thanks to the fabulous technical support that is ready to help us at all times
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.
Automated monthly financial statements saves us 3 hours a month.
Moving reporting away from IT has begun to save hours of IT involvement, which will only grow as we shift more reports to Vena. This frees up IT to work on more important IT initiatives.
Using budget templates saved hours of copy and paste time when gathering inputs from each department.
