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
ER/Studio Data Architect
Score 9.9 out of 10
N/A
ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.
N/A
Pricing
AvePoint Confidence Platform
ER/Studio Data Architect
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
AvePoint Confidence Platform
ER/Studio Data Architect
Free Trial
No
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
Pricing for new customers only, first year maintenance included. Maintenance includes access to technical support and product updates for the defined period of the agreement.
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.
ER/Studio is great for dividing logical and physical design. A logical model can be used with different physical platforms.
Studio can a useful macro capability that allows me to apply the naming standards across the model with ease and consistency.
ER/Studio does a very good job at comparing the model with the actual database and generating DDL scripts for production deployments.
ER/Studio has an excellent reporting and model publishing capabilities allowing me to produce models in the HTML format and publish them for the team as needed.
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.
Relationships are a bit on the weaker side. Many times I found orphaned relationships that I could not get rid of, or additional columns that were automatically created during the push to the physical model that appear to be due to key constraint bugs
There are a lot of bugs introduced when merging keys. I tend to model 2 tables for example logically, establish the relationship, and then merge the additional key column that is automatically created when establishing the relationship. This sometimes causes downstream issues with the physical model (creating duplicate columns with _1 appended)
Meta-data could be improved. I find it hard to keep descriptions and other meta information clean when copying and pasting from other sources due to formatting tags being introduced on each object (font, size, color, etc.). The attachment feature comes in handy, however I am looking for the ability to cleanly document and map multiple sources to a single target while providing searchability and traceability
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.
I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.
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.
ER Studio Data Architect is a global leader in the data modelling space and most other solutions that have support for third party data models include support for ER Studio Data Architect file formats. Many of the features are a bit more intuitive than the competitors and several of our vendors were already using Data Architect themselves which helped solidify the choice.
Using ER\Studio to create models and eventually the actual database schema allows for a picture that is understandable to the customer and saves significant time writing DDL to create the database objects (tables, indexes, relationships, constraints...)
A nice customer interface tool so you can create a web based interface to the metadata for a particular design.
The tool also supports sub-models so you can break a large project into smaller parts, I find this feature very helpful.
