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.
N/A
Cyfe
Score 8.8 out of 10
N/A
Cyfe is all-in-one dashboard software for analyzing data from online services like Google Analytics, Salesforce, AdSense, MailChimp, Amazon, Facebook, etc, from Traject.
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.
Cyfe might be for you if you are looking for a cost-effective way to display all of your marketing metrics in one place. If you are looking for a detailed, fine-tuned, niche, or extremely specific metrics, this might not be the best solution. Cyfe is good for a general health check-up of marketing, but not a finely tuned examination.
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.
I'd love to see additional functionality to customize colors. The light/dark option is very nice, but a little more flexibility in the colors would go a long way, especially if it was possible at the dashboard level rather than just the account level. Along the same lines, being able to customize the charts a little more, for example being able to show an x-axis on single data type graphs, could make them easier to read in some cases.
Being able to choose to report on converted clicks or conversions in AdWords would be helpful.
Needs the ability to show the date range on the shared URL dashboards. Would be even better if the date range was adjustable on that view, too.
It has become a part of our internal tools so unless a competitor comes out with similar functionality as a similar price point it is unlikely that we would not renew. One area that would cause us not to renew would be if a competing service came out with more third-party integrations that match our needs. Price at this point is no longer an issue as it would allow us to automate a somewhat manual process that we have now connecting Cyfe widgets to Google Sheets.
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.
I gave it a rating of 7 because it does a good job at what it does, but there are missing that are missing which I would have benefited from. For instance, if I was able to drill down more on the specific metrics I was able to see, that would have been helpful.
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.
Because I had a very minor question and I was able to speak directly to the founder through LinkedIn and through email. I know that as they grow this may not always be an option but the fact that he made himself available to answer my questions said a lot about his passion for the product.
Cyfe is a 15 minutes implementation, then some time to get your data sources created. This is an easy one person job that will not result in down time or unnecessary wasted man hours.
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.
The Salesforce dashboard is comparably flexible and intuitive, but designed more to its internal CRM focus. SumAll shares the social media dashboard capabilities, but lacks all others. Its interesting feature is side-by-side graph analysis for cross-channel performance. Cyfe might borrow from SumAll's default weekly email summary of performance from the dashboard, but implementation could be too complex. Nuvi dashboard is exclusively for social media marketing, but lacks Cyfe's flexibility for third party integration and window customization settings.
