MySQL vs. Varicent

MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.

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

For the use cases we have at the bank, ICM is a perfect solution. For any bank or institution that has similar requirements, ICM would be a perfect solution. But I also think for any use case that has any sort of incentives based on Sales done, this would work amazing, as both Calculations and reports are handled by ICM very well; it's an all-in-one solution, I feel like.

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

• Stable - it just runs, with minimal downtime or errors
• Fast - well-structured data is quickly written and read
• Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
• Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL

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

• Flexibility - Varicent is not template based. You can implement the model specifically for your organisation.
• Scalability - Since it is not stick to templates you are able to expand the model for other domains as well.
• Reporting - Several ways of reporting are possible and each has their own benefit/purpose.
• Strong/Powerfull Calculation Engine delivering fast results/speed to insight
• User Interface is minimized to what you need and is not showing off all the functions it can "also" do
• Strong audittrail
• Appears to be almost unlimited in what you are able to create

• Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
• Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.

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

• As [the] model gets more and more transactional data, the calculation time increases. This should/can be handled internally with better model optimization.
• Migrating from one env to other sometimes is challenging. There can be better 'Alerts' or 'Explanation' provided to handle it or at least to give a hint of the error.
• For managers viewing their rep's report, the access part can be made easier. It should be linked to Payee hierarchy and access can be done automatically.

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

For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

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

Customer support from IBM is impeccable. They are quick to respond and they don't nickel and dime you for every request you make. Their goal is to ensure your success and as a user, I really feel like they listen to my concerns. That's not to say there are no problems. All software has its issues, but I don't feel like those issues fall on deaf ears.

I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.

Any calculations can be implemented as there are hardly any limitations on complexity. However, online real-time usability is lacking - a simple user enters, and the system calculates work in a way that it is in the browser and hence still needs overnight to be properly reflected in the batch calculations and backend tables.

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

Never went down in last 3 years that I worked with it (every hour of the day basically). That is a 10 in my book.

All is fast, but with API's it is sometimes slower due to the application we are pulling data from. Reports are loaded directly or within seconds and our reports are very detailed with many columns and rows.

We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.

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

Giving a 10 would suggest there is no room for improvement. I don't feel like their support is perfect. However, I have never met another team that was more dedicated to making sure we get what we want and need.

The training was good in general with a nice trainer as well. But, the training could be better if it is more focussed on our process/data etc.

There is a learning portal with many videos about navigation, creating reports and managing your model.

1. Estimate your data size. 2. Test, test, and test.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

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. TR verified that a representative sample of customers was invited. More Info

Test test test. Make sure that the product is calculating everyone 100% correctly. DO NOT accept a 70% pass rate as some companies would like to have you believe is acceptable. This means conducting thorough testing by providing 100% of all expected results, but it will be worth it when you know that the compensation plans are working entirely as expected.

MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.

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

In 2015, we used a scorecard containing 80 attributes in our review of Oracle, Callidus, and Xactly & Varicent. Oracle did not have true self serve capabilities- programming was heavily required, not intuitive, out of the box functionality was limited. Callidus & Xactly could not provide us a demo using our data, statements could not be sent out in bulk form, difficulty in importing/exporting to CRM. Varicent excelled in most areas and was the clear winner.

It is very scalable and adaptable to changing complexities of calculations and business rules under a variety of different scenarios. It does not get full points because in large data loads the time needed to calculate and import the data increases exponentially and may cause issues related to timing potentially.

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 it is an open source solution through community solution, we can use it in a multitude of projects without cost license
• The acquisition by Oracle makes you need to contract support for the enterprise version
• If you have knowledge about oracle databases, you can get more out of the enterprise version

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

• Compliance - with a central system used for calculation incentive payments and commissions, we are able to provide reports and data showing every detail of how payments are calculated and why they are justified. We can also identify anomalies and outliers.
• Integration with our payroll system is seamless. Except for regular pay, nothing goes to payroll without going through ICM. The process for paying incentives/bonuses/commissions is now very structured and efficient.

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