Anaplan is a scenario planning and analysis platform designed to optimize decision-making in complex business environments so that enterprises can outpace their competition and the market. By building connections and collaboration across organizational silos, the Anaplan platform surfaces key insights.
N/A
Microsoft SQL Server
Score 8.6 out of 10
N/A
Microsoft SQL Server is a relational database.
$1,418
Per License
Pricing
Anaplan
Microsoft SQL Server
Editions & Modules
No answers on this topic
Subscription
$1,418.00
Per License
Enterprise
$13,748.00
Per License
Offerings
Pricing Offerings
Anaplan
Microsoft SQL Server
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Anaplan
Microsoft SQL Server
Considered Both Products
Anaplan
Verified User
Engineer
Chose Anaplan
All these tools have different applications. Anaplan provides [the] ability to enter data online, directly to the precise cells, then to manipulate this data easily (Power BI can only present data). It allows for easy pivoting and visualizations of huge data sets and enforces …
I believe that Adaptive is more user-friendly. The reason being, every functionality is intuitive. Also, it has an out-of-box reporting solution that allows the use of Excel for reporting purposes. Also, Adaptive offers a planning tool that allows users access to Adaptive …
I've implemented a number of projects for Anaplan for Sales Performance Management use cases. It is obviously built for financial planning, but it allows for a lot of flexibility for territory and quota, ICM, sales forecasting, and other important use cases. Territory and Quota is very powerful in the tool as it organize complex assignment structures into hierarchies for easier analysis and reporting.
Microsoft SQL is ubiquitous, while MySQL runs under the hood all over the place. Microsoft SQL is the platform taught in colleges and certification courses and is the one most likely to be used by businesses because it is backed by Microsoft. Its interface is friendly (well, as pleasant as SQL can be) and has been used by so many for so long that resources are freely available if you encounter any issues.
Anaplan removes the time consuming process of integrating the results of individual spreadsheets.
Anaplan facilitates the standardization of assumptions across all sub-processes
Anaplan provides full transparency of the calculations and source inputs
Anaplan allows us to automate certain planning processes that would have been impossible when relying on the computational capabilities of an individual computer.
Microsoft SQL Server Enterprise edition has a high cost but is the only edition which supports SQL Always On Availability Groups. It would be nice to include this feature in the Standard version.
Licensing of Microsoft SQL Server is a quite complex matter, it would be good to simplify licensing in the future. For example, per core vs per user CAL licensing, as well as complex licensing scenarios in the Cloud and on Edge locations.
It would be good to include native tools for converting Oracle, DB2, Postgresql and MySQL/MariaDB databases (schema and data) for import into Microsoft SQL Server.
Anaplan is a very strong multi-dimensional modeling tool that provides a calculation engine to empower a complex planning process. It is fairly easy to learn for those with experience in similar tools, or excel. It forces structure and auditability that spread sheets do not have, along with extensive security capabilities
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
As a user it is a very simple tool, but at the same time with a very mature and powerful calculation engine. It is very easy to switch from excel or traditional tools with added capabilities of multi dimensionality and real time calculation engine to see quick insights needed to create plans and scenarios
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
There are very few outages. Maintenance is scheduled on two or three Saturdays per month, so as not to affect businesses. When there is an outage, users are kept informed of progress to restore the platform and typically this takes no more than an hour. Anaplan customer support is very responsive if we ever have questions about platform issues
Everything is calculated in memory in the cloud. It's nearly instantaneous updates when you make changes. The only time things get a little slow is when you have a massive model with very intricate calculations...but "slow" for Anaplan is not what I would call "slow" for something like Hyperion. We used to have Hyperion calcs that ran for 60 mins before you could use data. The equivalent would be 60 seconds in Anaplan.
Support quality has dropped since Thoma Bravo has taken over. I think some serious re-focus needs to happen here -- part of the beauty of being in the Anaplan community was how involved you felt in it before. Before I didn't dread sending a support ticket, now I am starting to.
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
In my opinion, in-person training is always the best if you have the option to do so. This allows real-time interactions with the instructions, whereas the online training I took required me to write-down questions, email them, and wait for responses. This slows down the process, as you can imagine. That said, in-person training is an extra cost and it likely isn't needed for everyone. I would suggest selecting a small number of people to take in-person training and then having them act as mentors to the rest of your team. That way, as the rest of the team takes the online training, they have a resource to help them in real time.
Anaplan training materials are clear, simple, easy to understand and to follow. Visuals are excellent. The vendor is good at updating training materials in a timely manner and encouraging users and administrators to keep coming back to Academy site for refresher courses or new feature courses. I really like their interactive diagrams
One key insight from implementing Anaplan is that success comes from focusing on designing the process, not just building the model. Anaplan is extremely flexible—there are very few planning scenarios it cannot support—but that flexibility means the project needs strong governance, clear ownership of requirements, and a well-defined data model. When those foundations are in place, implementations are fast, iterations are easy, and users can quickly see value. In our projects, both Financial Planning and Integrated Business Planning models were adopted smoothly because we involved business users early, kept the model design intuitive, and leveraged Anaplan’s Excel-like syntax and user-friendly dashboards. The result was more efficient day-to-day work, reduced manual tasks, and increased collaboration across teams. In short: when you combine Anaplan’s flexibility with a structured implementation approach, adoption and value realization happen quickly.
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
Anaplan is more powerful than Pigment considering that it is an Enterprise class system and is able to manage bigger data sets. Anaplan allows for advanced scenario modeling and formula capabilities along with custom reporting functionalities. Anaplan has proven its capabilities and stability across various use cases and across bigger enterprises when compared to Pigment which is still in earlier phases of its development
[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
We have managed to leverage Anaplan for financial planning and forecasting across the business. It is now used by almost every department, with more than 50 users (but I know of companies that have hundreds of users) and still the platform is quick and reliable. It is easy to make changes to divisions and departments or add users and apply different user settings - the core part of the model is not affected and end users can continue their work without any disruption
Anaplan's implementation led to a significant reduction in planning cycle errors and bugs, streamlining processes and improving overall accuracy in data inputs
Standardizing the planning process and enabling cross-functional collaboration through Anaplan enhanced our ability to adapt swiftly to changing business needs, resulting in improved agility in decision-making
The platform's capabilities, especially in Demand Planning and Supply Chain, positively impacted our ROI by optimizing resource allocation and solving complex business problems efficiently across multiple functions
Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.
