Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
N/A
Varicent
Score8 out of 10
N/A
From quotas to sales and compensation, Varicent helps revenue leaders in enterprise organizations chart a more effective, connected path to revenue by providing vital data, insights, and sales go-to-market planning tools.
As I mentioned earlier SQL Server Integration Services is suitable if you want to manage data from different applications. It really helps in fetching the data and generating reports. Its automation make it very easy and time efficient. It works well with large database as well. But it doesn't work well with real time data, it will take some time to gather the real time data. I would not recommend using it in a real time/fast-paced environment.
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.
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
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
Connection managers for online data sources can be tricky to configure.
Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
Mapping destination using OLE DB command is difficult as destination columns are unnamed.
Excel or flat file connections are limited by version and type.
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.
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
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
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.
SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
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
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.
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
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
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
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.
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
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 implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
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
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.
I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer
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.
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
Without this, we would have to manually update a spreadsheet of our SQL Server inventory
We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.
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.
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
