OneStream vs. PostgreSQL

Financial Planning / Forecasting, People Planning, and Financial Close and Consolidation are well suite while we are still evaluating GL Account Reconciliations and other solutions available via the Solution Exchange. Overall, we believe OneStream is going to allow us to "get out of excel" and perform Global Consolidation in the system

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

PostgreSQL is best used for structured data, and best when following relational database design principles. I would not use PostgreSQL for large unstructured data such as video, images, sound files, xml documents, web-pages, especially if these files have their own highly variable, internal structure.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Consolidation of Group Results across 600 Entities
• Flexibility of Reporting through Dashboard Reporting Suite and Excel Interface
• Ability to create Bespoke Models for specific requirements. (Ifrs15/16/BC/DC/Payroll, Covenance Reporting, etc.)
• Singular Cube for One source of the Truth
• Customisable Maintenance Platform to facilitate high growth strategy

• It works well with external data sources and runs on platforms with stable performance.
• Clients can rest assured that their personal information will be safe and secure.
• Many forums discuss setup and usage, and most are free.
• Adding tooling applications to a computer is unlimited.
• PostgreSQL runs on many OS platforms and supports ANSI SQL, stored procedures, and triggers.

• Journal copy feature would be good to have
• The Excel Add in is limited to only one application. Would be good to have the ability to pull from say Dev and Prod so side by side comparisons could be done
• Better interface to handle metadata changes

• Clearer indications on what is the query plan, to optimize the query
• More out of the box, Postgres specific, SQL functions
• It would be nice to have a more visual aid of the relationship between all tables, but possibly this depend more on the UI used

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Currently we are using OneStream with people 80 - 100 to load the PL, BS , Forecast budget and People Planning. OneStream give us more visibility on trend and way forward thinking. Thanks to OneStream for the tool which helps the business in growing way. Thinking of innovation OneStream is right path.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

As a needed software for day to day development activities

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Overall usability as an end-user is very easy. There are more people in the system getting information now than the prior platform used. People are gathering their information quicker as well. From an administrator standpoint, there are fewer glitches and issues than the prior platform. This is very good.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

OneStream support is focused on the infrastructure. Which means mainly when there issues with accessing to the system, they will be able to help. When the question is to much leaning towards functional it really becomes billable. The other issue is that the response time is not optimal. There is a lot of pingpong of messages and the time between the message can sometimes be long. Sometimes this result into a simple ticket to be taking days before it is closed.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.

But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

onestream offers a range of training. I have attended a number of trainings. During the trainings a vast amount of information is discussed. The trainings also include exercises. The speed of the training is pretty high. When reviewing the training material afterwards, I found that the material is not complete as reference as it relies also very much on the verbal explanation and elaboration.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

The online documentation of the PostgreSQL product is elaborate and takes users step by step.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

OneStream is the overall clear winner against HFM. There are a few things HFM does better (a couple things in Smart View), but it just doesn't have as much capability. The single, integrated platform that OneStream is provides a massive upgrade from HFM.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Although the competition between the different databases is increasingly aggressive in the sense that they provide many improvements, new functionalities, compatibility with complementary components or environments, in some cases it requires that it be followed within the same family of applications that performs the company that develops it and that is not all bad, but being able to adapt or configure different programs, applications or other environments developed by third parties apart is what gives PostgreSQL a certain advantage and this diversification in the components that can be joined with it, is the reason why it is a great option to choose.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

The DB is reliable, scalable, easy to use and resolves most DB needs

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Customers have moved from multiple EPM systems as well as multiple EPM applications to OneStream.
• Their ROI has been quite high as lesser admins are required, no need to move data back & forth, no need for an additional dashboarding / BI tool, once a user is on OneStream can leverage it for more than 50+ use cases at no additional license cost.
• Automation, direct integration, scheduling, complex calculation capabilities, all help to further improve ROI and free up the time for the team to do value-adding tasks.
• Last but not the least is the confidence on the numbers is much higher.

• Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
• Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
• It's free. You can't beat that.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info