Grow, from Epicor since the March 2022 acquisition, is a business intelligence software that is designed to empower businesses to become data-driven and accelerate growth by aligning team objectives and inspiring strategic decisions.
N/A
erwin Data Modeler
Score 8.9 out of 10
N/A
erwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives, accomplishing this whil esupporting data governance and intelligence efforts.
Grow.com is well suited if you have a lot of data or client data to manage. If you do not have tons of data, there are other options out there that are a bit more simple and easy to use and a better price.
I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.
I love the fact that you have a team of developers who can help me build metrics or fix metrics that I do not create properly. I had to learn SQL in order to really build the metrics that mattered, which was a lot of fun, but resulted in many broken metrics. The vendor's team was great in responding to me requests for help!
Really, really appreciate the fact that Grow has SQL formulas to reference when building metrics. Again, as a novice, this accelerated my ability to learn and not have to leave your site and resources and stay within the Grow web properties.
Great account managers who check in regularly and are willing to help out whenever needed.
Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.
Grow.com is structured in [...] such a way that it is easy to get started for individuals that known SQL. For individuals that are not as well versed at SQL, the learning curve is much steeper. In such cases, it would be better for users to learn SQL and then go for data visualization with Grow.com.
I had a lot of experience using erwin Data Modeler for designing data models. I think it's pretty intuitive and easy to use. It has enough features to represent your database requirements in form of a model.
If there is one area that Grow.com excel[s] upon much better than other data visualization tools, it is Grow.com's customer/tech support. Grow.com responds much quicker and does a better job of getting to a solution [than] any other business intelligence tool on the market. The support staff gets the big picture [...] and knows how to help.
CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.
Grow doesn't have as many advanced analytics features and other capabilities as some other 'dashboard' platforms on the market. Simply, if you want a tool for internal use only that has high-level analytics capabilities (regressions, completely custom visualizations, modeling), Grow probably isn't the platform for you. To put it another way, if you have a team of data engineers and scientists doing complex analysis, Grow might not make the most sense. However, if you understand the value of data/visualization/dashboards, but lack some of those skillsets in your company, Grow might be the perfect fit. Not only is it incredibly scalable and reasonably priced compared to other market solutions, but their transform capabilities really stand out. They have many native data transformations that mimic SQL coding of a dataset, without requiring any knowledge of SQL. They've converted these transformations to easy-to-use tools in the platform, which are perfect for the less-technical user.
Not listed, but I've only used alternatives built into something like the Squirrel SQL editor. That one is semi-functional but lacking many features and, in some instances, just plain wrong. The only pro there is that it's freely available and works over ODBC. I've tried some of the other free ones like Creately but didn't have much success.
