The AvePoint Confidence Platform is used to transform the chaos of digital workplace technology and data into a secure, enriched, and controlled experience that improves productivity, improves decision making, and lowers cost of ownership.
N/A
SAS Data Management
Score 8.0 out of 10
N/A
A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.
It is better than Veeam since it can backup more different types of data such as Project Online and Public Folders. Setup is generally easier if support is there to help.
AvePoint Cloud Backup for Office 365 stacks up against Datto Backupify well. Although I feel that Datto's Backupify was a bit easier to configure and setup, and process backups. Probably because I have experience with it, but overall I do feel that it is easier to use than …
The product is best when combined with the other products of the SAS suite. In particular, it's great for the preparation, analysis and display of the data if it is carried out with the products indicated above. When it is combined with products other than those of the SAS …
SAS Data Management Platform requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres. Has almost all features present as compared to the alternatives we evaluated. On top of it, SAS offered statistical transformations and strong metadata …
Because of ease of using SAS DI and data processing speed. There were lots of issues with AWS Redshift on cloud environment in terms of making connections with the data sources and while fetching the data we need to write complex queries.
SAS integration is not easy because there are various PAM related modules which require additional vendor involvement. Overall once all integrations are set up, it's a great tool and provides multiple options to users for running their model.
Because SAS Data Integration Studio is the third party it seems to work equally well with all our systems. That is to say that it doesn't really work better with Microsoft or Oracle but really just seems to work equally well with all of them. It has a very powerful back-end …
Datastage might be the closest one. Being a full ETL tool, it's weird to compare both. Datastage might be more robust for extraction but it lacks the simplicity that the end users need for everyday data extract and analysis.
SAS/Access can work well with MySQL. There are some coding differences between the two, for example how missing values are handled or rules for variable names. MySQL has simpler coding, but if you are familiar with Base SAS, it is not too difficult to learn. With SAS/Access the …
AvePoint's Confidence Platform is very well suited for all businesses, specifically those on a budget, who are looking to secure, harden, and manage their Microsoft 365 environment. Their stack includes products to migrate data, back up data, secure and maintain data, apply custom policies around data management, and get valuable insights into how your data is being used. I cannot think of a scenario where their products would not be well suited for a company, because data management is critical.
SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.
SAS supports the main database connection options that allow you to optimize the performance of your extracts and loads.
Simplicity of the syntax for a basic connection.
Ability to configure by an administrator in a BI environment so that all users can benefit from the connection without having to establish it by themselves.
I am not confident in their Exchange migration tool, which in the past, has not been a reliable method for data migrations
Some of the products in their stack are very complex, and without some hand holding, it can be cumbersome to set up and maintain
I would like to see live support options, which don't seem to be available at the moment. You are forced to create a ticket, then wait until a support agent reaches out to you.
It is a versatile product but sometimes difficult to use due to the very close link with the proprietary programming language where specific knowledge is required.
Compared to competitors on the market that offer the same functions for the integration perimeter, it is certainly very expensive.
It is very simple to use when combined with products from the SAS suite, less so it is being used stand-alone or integrated with other well-known brands.
Overall, I think AvePoint's Confidence Platform, and specifically, their backup solution and data migration solution, are very user friendly, even for a novice. Their knowledge base for the products is extensive, and provides detailed instructions for almost everything you will be doing within their platform. They also have a very knowledgeable support staff, and their products are tailored to make your company more secure.
The main negative point is the use of a non-standard language for customizations, as well as the poor integration with non-SAS systems. However, there is no doubt that it is a high-performance and powerful product capable of responding optimally to certain requirements.
With SAS, you pay a license fee annually to use this product. Support is incredible. You get what you pay for, whether it's SAS forums on the SAS support site, technical support tickets via email or phone calls, or example documentation. It's not open source. It's documented thoroughly, and it works.
It is better than Veeam since it can backup more different types of data such as Project Online and Public Folders. Setup is generally easier if support is there to help.
Because SAS Data Integration Studio is the third party it seems to work equally well with all our systems. That is to say that it doesn't really work better with Microsoft or Oracle but really just seems to work equally well with all of them. It has a very powerful back-end that allows us to transform and load our data quickly and efficiently programmer time wise.