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
Qlik Cloud Analytics (Qlik Sense)
Score 8.2 out of 10
N/A
Qlik Sense® is a self-service BI platform for data discovery and visualization. It supports a full range of analytics use cases—data governance, pixel-perfect reporting, and collaboration. Its Associative Engine indexes and connects relationships between data points for creating actionable insights.
We, actually, previously used WebSphere Data Architect. Erwin's product is more flexible and has many more interfaces. It integrated well with Oracle, SQL Server and MySQL environments. It also has a better visual representation and better reverse-engineering capabilities.
We found Qlik Sense provided better governance and the ability for IT to retain some control of how the data is collected and used. In-memory analytics model also stood out.
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.
Qlik Sense is a program whose purpose is to greatly improve all your operations and use of all data in an organic way. The mission will always be to increase the economic and commercial processes of the company in a short time. I recommended it for its high technology, which was Created for this area, the results are successful. We have noticed how it has increased relationships with our clients thanks to the credibility and security that we provide.
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.
Qlik Sense is a constantly improving it's software and working with its' users to make it better. They are great at keeping their users informed of progress and care about delivering a quality product
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.
Qlik Sense has a better and easy to learn user interface compared with other analytics tool which always help us to create regular and adhoc reports within the stipulated time frame and can be easily refreshed at a scheduled time and sent to multiple stakeholders for timely update regarding the Key metrics indicator.
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.
Qlik is great for companies with lots of business domains and departments because it scales well, especially if data that is reported is saved in SQL and similar structures. Its ease of use and good UI enables business units to create and manage their own reports. That removes a great burden of creating and managing/modifying these pages from the IT team. Overall, it's a win-win for both IT and business units.
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 customization of the platform opens up plenty of other options depending on the use cases. The API layer is incredibly rich and makes integration of Qlik based visualization into web pages a simple and effective pattern. It's been very easy to use with a great community made up of professionals. Qlik Sense has introduces artificial Intelligence into my data visualization and reporting activity.