"Having more control over page size is lacking in this product. We have chosen to go for a cloud-based database, and it supports that, which is very useful." Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully." "It supports a wide variety of databases, including the latest ones.
#Allfusion erwin data modeler how to#
Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. With the model comparison, I can track the differences between two versions of the same database." "The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. With the reverse engineering, I can understand the databases from third-party products. But it's just got gobs and gobs of stuff that you can implement if you so choose to." "The most valuable features are the ability to reverse engineer and do model comparison.
It seems to be pretty common that not all the functionality is fully utilized. There's a whole boatload of functionality in this thing and we use maybe 10% of it. There are some notes, naming standards, and other functions that we use as well. This has made it easier for our clients to consume our databases for their own purposes." "The modeling portion of the tool is the most valuable. erwin has allowed me to explicitly document that and create ERDs. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed." "What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. It has to take days off out of the work." "Another feature of erwin is that it can help you enforce your naming standards. You would have to take your design and just type in manually. It's not only nice but it also saves man-hours of time.
#Allfusion erwin data modeler code#
The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It gives us the ability to work on the same model, regardless of where we are physically." "We find that its ability to generate database code from a model for a wide array of data sources cuts development time. "The ability to collaborate between different members across the organization is the most valuable feature. They are responsive and the answers they provide are detailed." "The product is easy to use and well-structured for the integrations we need it to make." "The most valuable feature is that it has a customizable meta-model, which is key." "It's more than just an enterprise architecture tool as it has a lot of nice features, e.g. It is a pretty good tool." "Scalable and stable tool for roadmapping and modeling, with a good dashboard, end-to-end impact analysis, and portfolio management." "There are a lot of different features, but the business/decision-maker feature, visibility, and dashboards are most valuable." "There are plenty of features available such as the ability to test applications for issues and a user-friendly dashboard." "The technical support is very good. "The ease of modeling and the ease of showing interconnectivity and relationships is the most valuable.
0 kommentar(er)
