erwin Data Intelligence by Quest Reviews

We don't have all of the EDGE products. We are using the Data Intelligence Suite (DI). So, we don't have the enterprise architecture piece, but you can pick them up in a modular form as part of the EDGE Suite.

The Data Intelligence Suite of the EDGE tool is very focused on asset management. You have a metadata manager that you can schedule to harvest all of your servers, cataloging information. So, it brings back the database, tables, columns and all of the information about it into a repository. It also has the ability to build ETL specs. With Mapping Manager, you then take your list of assets and connect them together as a Source-to-Target with the transformation rules that you can set up as reusable pieces in a library.

The DBAs can use it for all different types of value-add from their side of the house. They have the ability to see particular aspects, such as RPII, and there are some neat reports which show that. They are able manage who can look at these different pieces of information. That's the physical side of the house, and they also have what they call data literacy, which is the data glossary side of the house. This is more business-facing. You can create directories that they call catalogs, and inside of those, you can build logical naming conventions to put definitions on. 

It all connects together. You can map the business understanding in your glossary back to your physical so you can see it both ways. 

We have only had it a couple months. I am working with the DBAs to get what I would call a foundational installation of the data in. My company doesn't have a department called Data Governance, so I'm having to do some of this work during the cracks of my work day, but I'm expecting it to be well-received.

They have just the most marvelous reports called mind maps, where whatever you are focused on sits in the middle. They have this wonderful graphic spiderweb that spreads out from where you can see this thing mapped to other logical bits or physical bits and who's the steward of it. It's very cool and available to your business teams through a portal. 

Right now, we're focusing on building a library. erwin DM doesn't have the ability to publish out easily for business use. The business has to buy a license to get into erwin DM. With erwin DI, I can have a full library of physical data there or logical data sets, publish it out through the portal, and then the business can do self-service. 

We are also looking at building live legends on the bottom of our reports based on data glossary sets. Using an API callback from a BusinessObjects report from the EDGE governance area in the Data Intelligence Suite back to BusinessObjects, Alteryx, or Power BI reports so you can go back and forth easily. Then, you can share out a single managed definition on a report that is connected to your enterprise definitions so people can easily see what a column means, what the formula was, and where it came from.

It already has the concept of multilanguage, which I find a really important thing for global teams.

It does have some customization, but it is not quite as robust as erwin DM. It's not like everything can have as many user-defined properties or customized pieces as I might like.

There are a lot of little things like moving between read screens and edit screens. Those little human interface type of programming pieces will need to mature a bit to make it easier to get to where you want to go to put the stuff in.

We have only had erwin DI for a couple months. We brought it in at the very end of last year.

So far, I haven't had any problems with it whatsoever. Now, I'm not working on it all day every day. It seems to be just as stable as erwin DM is. I used this tool when it was still independent and called Mapping Manager, before it became part of the erwin Suite. It's lovely to see it maturing to connect all the dots.

Four people are maintain the solution. The DBAs are going into harvest the metadata out of the physical side of the house. Then, I'm working with the data architects to put in the business glossaries.

It is a database. All of the data is kept outside of the client, so it's how you set up your server.

We have five development licenses and 100 seats for the portal. Other than those of us who are logging in to put data in, nobody much is using it. However, you have to start some place.

Right now, the DBAs, data architects, and I are its users.

I'm expecting the solution to expand because the other cool thing that this Data Intelligence Suite has is a lot of bulk uploads. I can create an Excel template, send it to the business to get definitions, and then bulk upload all their definitions. So, we don't need a lot of developer licenses. It becomes a very nice process flow between the two of us. They don't have to login and do things one by one. They just do it in a set, then I load things up for them. I have also loaded up industry standard definitions and dictionaries making it easy to deal with.

I haven't interfaced with anybody who is just an EDGE team member. I will say the sales and the installation teams that we worked with were both fabulous.

We did not previously use another solution. erwin didn't have a formal business glossary.

The initial setup seemed to be very straightforward. I don't do the installations, but the DBAs seem to find it pretty easy. They got the installation instructions from the erwin team, followed them, and the next day, it was up and running.

We're just following the same implementation strategy that we're doing with erwin DM. We didn't set up the lower tiers because I didn't see that we need lower tiers except for upgrades. We just do lower tiers when we do an upgrade and push to production, then we just drop the lower tier. Other than having to train people on how to use it, implementation has been pretty easy.

ROI is a bit hard to come at. There is peace of mind knowing that we now have visibility into the business. To be able to know that I'm instantly pushing all the data definitions out to the business, even though culturally I haven't changed everything so they are looking at it on a daily basis. This is still hard to put a price tag on. I know I'm doing my piece of the job. Now, I have to help them understand that it's there and build a more robust data set for them.

You buy a seat license for your portal. We have 100 seats for the portal, then you buy just the development licenses for the people who are going to put the data in.

We did evaluate other options. Even though erwin DI got a few extra points from the evaluation to coordinate with the erwin DM tool, we looked at other tools: Alteryx Connect, Collibra, DATUM, and Alation.

We did a whole pile of comparisons:

• Some of them were a bit more technical. 
• Some of them were integration points.
• Customization.
• The ability to schedule data harvests, because the less you have to do manually, the better.
• The ability to build your data lineages, then the simplicity of being able to look at those sorts of things to do searches. 

There were a different things along those lines that showed up in the comparison.

Erwin DI checked all the boxes for us. There are some things that they will grow into over time, but they had all of the basics for us.

Collibra scored a little higher on being able to integrate with SAP Financials. In fact, other products scored a bit higher with the SAP integration altogether, because with erwin DI, you need to buy a connection to do some of that.

For the connection with some of our scheduler tools, Alation was able to integrate with our UC4 scheduler. Right now, the EDGE tools don't.

For the most part, the functionalities were exactly the same, e.g., being able to do bulk uploads with high performance, Alteryx, Collibra, and erwin Data Intelligence Suite tied on a lot of things. However, erwin's pricing was cheaper than its competitors.

If you have the ability to pull a steering committee together to talk about how your data asset metadata needs to be used in different processes or how you can connect it into mission-critical business processes so you slowly change the culture, because erwin DI is just part of the processes, that probably would be a smoother transition than what I am trying to do. I'm sitting in an office by myself trying to push it out. If I had a steering committee to help market or move it into different processes, this would be easier.

Along the same lines as setting up an erwin Workgroup environment, you need to be thoughtful about how you are going to name things. You can set up catalogs and collection points for all your physical data, for instance. We had to think about if we did it by server, then every time we moved a server name, we'd have to change everything. You have to be a little careful and thoughtful about how you want to do the collections because you don't want the collection names to change every time you're changing something physically.

What we did is I set up a more logical collection, so crossing all the servers. The following going into different catalogs:  

• The analytics reporting data sets 
• The business-purchased applications 
• External data sets 
• The custom applications. 

I'm collecting the physical metadata, and they can change that and update it. However, the structure of how I am keeping the data available for people searching for it is more logically-focused.

You can update it. However, once people get used to looking in a library using the Dewey Decimal System, they don't understand if all of a sudden you reorganize by author name. So, you have to think a bit down the road as to what is going to be stable into the future. Because the more people start to get accustomed to it being organized a certain way, they're not going to understand if all of a sudden you pull the rug out from under them.

I'm going to give the solution an eight (out of 10) because I'm really happy with what I've been able to do so far. 

The more that the community uses this tool, the more feedback they will get, and the better it will become.

The three big areas that we use it for right now: metadata management as a whole, versioning of metadata, and metadata mappings and automation. We have started to adopt data profiling from this tool, but it is an ongoing process. I will be adding these capabilities to my team probably in Q1 of this year.

It is improving just a small piece of our company. We are an extremely big company. Implementing this to the company, there is probably a zero percent adoption rate because I think it is only implemented in the development team of our platform. 

If you look at this from the perspective of the platform that we are delivering, the adoption rate is around 90 percent because almost every area and step somehow touches the tool. We, as a program, are delivering a data-oriented platform, and erwin DI is helping us build that for our customers. 

The tool is not like Outlook where everyone in the company really uses it or SharePoint that is company-wide. We are using this in our program as a tool to help my technical analysts, data modelers, developers, etc.

The possibility to write automation scripts is the biggest benefit for us. We have several products with metadata and metadata mapping capabilities. The big difference when we were choosing this product was the ability to run automation scripts against metadata and metadata mappings. Right now, we have a very high level of automation based on these automation scripts, so it's really the core feature for us.

I'm working as a solution architect in one of the biggest projects and we really need to deliver quickly. The natural thing was that we went through the automation and started adopting some small pieces. Now, we have all our software development processes built around the automation capabilities. I can estimate that we lowered our time to market by 70 percent right now using these automation scripts, which is a really big thing.

The second best feature that we are heavily using in our project is the capability to create the mappings and treat them as a documentation. This has shown us the mappings to the different stakeholders, have some reviews, etc. Having this in one product is very nice.

The SDK behind this entire product needs improvement. The company really should focus more on this because we were finding some inconsistencies on the LDK level. Everything worked fine from the UI perspective, but when we started doing some deep automation scripts going through multiple API calls inside the tool, then only some pieces of it work or it would not return the exact data it was supposed to do. This is the number one area for improvement.

The tool provides the WSDL API as another point to access the data. This is the same story as with the SDK. We are heavily using this API and are finding some inconsistencies in its responses, especially as we are going for more nonstandard features inside. The team has been fixing this for us, so we have some support. This was probably overlooked by the product team to focus more on the UI rather than on the API.

We have been using the product for two and a half years.

There have been no issues with the stability from the erwin DI platform. We haven't encountered any problems for the last two and a half years.

It is maintained by another team. erwin is maintained by the team who generally maintains our platform. However, the effort is close to zero because there is nothing happening. Hold the backups and everything is automated by default on our shared platforms on which it is installed. 

It is a Java-based platform. So, if there would be some issues with the performance of this platform, we would probably migrate this to a bigger server. Therefore, it can scale. 

It does not have fancy cloud scaling tools capabilities, but we don't need this. For this type of tool and deployment, it's sufficient.

We have around 40 users. All the roles are very different because half of the developers work with different technologies. One-fourth of the users are technical analysts. The rest of the users are data modelers.

We have used the technical support several times. It's really different based on the complexity of the task. Usually, they meet their SLAs for fixes and changes in the required support time.

We did not previously use another product.

We used this product even before it was bought by erwin. Before, it was a company called AnalytiX DS. Then, after two years ago, erwin bought this company and their product, doing some rebranding. So, we started using this product as version 8.0, then it was migrated to version 8.3. Now, we are using version 9.0. We went through a few versions of this product.

The initial setup was not so simple, but it wasn't hard. If it would be between a one and five, with one being easy and five being hard, I would put it at a two. 

It was a new tool with new features. It had to be installed on-premise. Therefore, we struggled a bit with it. We were using it for quite a complex task, so we needed it to go through areas that would be potentially supported with the tool. The work associated with this initial setup to define that was not so easy, just to go through everything. 

Some companies have an initial packet that they show you everything in a very structured way. When we were implementing this, we really needed to discover what we needed rather than be given the documentation showing that this is here, this can contribute to your use case, and so on. We needed a lot of effort from our side. In comparison, I'm leading some other PoCs right now with other vendors in different areas. Those vendors contribute highly to me being capable to assess their tools, install and use them. 

The deployment took two days and was nothing special. It was just a simple Java application with a back-end database.

Migrating my team to use this tool properly, do some training, putting some capabilities so does people have some reason to use the tool, that took us around three months. Because we are using this for automation, the automation is an ongoing process lasting continuously for these two and a half years because we are adopting and changing to the new requirements. So, it's like continuous improvement and continuous delivery here.

I was involved from the very beginning of the PoC, actively checking the very basic capabilities. Then, I designed how we would use it, leading the whole automation stream around this tool. So, I was involved from the very beginning to the full implementation.

It took us around three months to introduce this tool.

If you count that it takes 70 percent less time to deliver and multiply this by 40 people who work around the development process, this is a big time savings that we can use for more development. From my perspective, there is a very big return on investment for this tool.

The licensing cost is around $7,000 for user. This is an estimation. 

There is an additional fee for the server maintenance.

We evaluated four products and chose erwin. None of the competitors had this out-of-the-box automation feature. This was the biggest thing for me because we were looking for a tool which would allow us to do big scale automation. When I was searching for this tool, my responsibility was to find a tool that could be used in our development process and core automation product. We built the whole development lifecycle and everything. In our platform, we are doing some development around automation capabilities. Usually people have a manual process and they automate some parts of it, we went the other way. We were searching for automation capabilities and built our entire process around its capabilities to use them as much as we could. The key differentiator straight from the very beginning was the automation capability.

Other competitors were showing us that they had an API and we could use that to automate somewhere else. Automating somewhere else means to me that I need to create some other platform, server, etc., then maintain it with some other resources to just make it run. This was really not enough for us. In addition, erwin already had some written automation templates on the PoC level which showed us that they had something that worked. 

At the PoC level, erwin was able to convince the customer (us) that this is the automation, this is how it runs, and you can use it almost straightaway.

I learned how to automate in the data area and how this is very different from any CI/CD development platforms that I was working on before. I learned that we need totally different things to automate properly in the data area. We need very accurate metadata. We need precise mappings reviewed by different data stakeholders. 

I would rate this product as an eight (out of 10). I can imagine some capabilities for this product that would make it even better.