SQL Server Integration Services vs. Veritas NetBackup

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.

Incentivized

Backuping complex infrastructures (VMware ESXi, Microsoft Hyper-V, Oracle, and MSSQL databases, etc.). Regarding product price, it's not the most affordable for small businesses, but it can handle nearly all infrastructures and systems. With good training people, it's a Swiss knife of company data backup, no stress about keeping backups in a safe place!

Incentivized

• Standard ETL use cases for daily loads
• Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
• Creating outgoing data files and writing them to Vendor FTPs
• Easy Active Directory integration for seamless connections to SQL Server
• CI/CD by hosting the code on visualstudio.com

Incentivized

• The activity monitor allows me to easily see if there are issues with backup jobs or the environment.
• Community support for NBU is very good. I've been able to research issues with ease and find other users that have been in similar situations.
• Policy management for backups is very easy and there are lots of options.

Incentivized

• 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.

Incentivized

• Admin console
• SAP HANA application Templates should also be introduced instead of scripting
• SAP MAXDB application template should also be introduced
• Tape Management need improvement
• MOBILE connectivity is missing
• Admin console is so simple it should be more funcky or stylish
• Small database should also be considered for backup

Incentivized

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

Incentivized

Veritas continues to keep up with the backup game. There virtual machine backup capabilities are now top notch, and I believe they will prove valuable when our cloud presence demands a backup solution.

Incentivized

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.

Incentivized

NetBackup provides a complete, flexible data protection solution for a variety of platforms. The platforms include Microsoft Windows, UNIX, and Linux systems. NetBackup lets you back up, archive, and restore files, folders or directories, and volumes or partitions that reside on your computer.
During a backup or an archive, the client sends backup data across the network to a NetBackup server. The NetBackup server manages the type of storage that is specified in the backup policy. During a restore, users can browse, then select the files and directories to recover.

Incentivized

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.

Incentivized

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.

Incentivized

Support is pretty good but it is split between America and outsourced companies so it is hit or miss sometimes. I have actually had to argue with the outsourced support as they sometimes have no practical experience using the software which makes troubleshooting difficult when they have no practical experience using the system.

Incentivized

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

Incentivized

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

Incentivized

CrashPlan has the capability to sync data with a cloud storage source. This is great for a workstation where data is typically only for one user. However, Netbackup does a much better job for maintaining multiple levels of file restores for Enterprise Servers. Netbackup has a superior management console that does not rely on Cloud services in the event of an internet outage.

Incentivized

Veritas NetBackup is very expensive, and I think price is the main reason which some customers don't want to use this solution. The price is fair. Most people have felt this solution was somewhat expensive.
licensing model is based on the number of NetBackup clients, agents, servers, and options that NetBackup will be protecting or run on. A customer purchases the same number of licenses as the count of clients, agents, servers, and options.

Incentivized

Education, Consulting and Managed services to keep our business running smooth.They provide the expertise needed to help you bridge the gap between excellent information management solutions and the information essential to help you reach maximum business value. They Meet information management goals with agility and flexibility.

Comprehensive 24x7 monitoring, management and support of your backup and archiving environments.

Incentivized

• 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.

Incentivized

• We never experienced a significant system or data loss during the time we used NetBackup. We restored individuals files and small databases based upon user mistakes, but we never had to implement a DR plan. From that aspect, it is difficult to evaluate the ROI. Backups are a commodity service. Features are very similar across multiple tools. Once you decide to stay on-prem or move to the cloud, the list of options are narrowed. Then it becomes a matter of price.
• From an administration and support perspective, the ROI is low. Vendor technical support is not always responsive. The first two tiers of support are not knowledgeable and their typical recommendation is to read the white paper. My small team spent a lot of time troubleshooting NetBackup, often without much vendor help.

Incentivized