IT Central Station is now PeerSpot: Here's why
Buyer's Guide
Master Data Management (MDM) Software
June 2022
Get our free report covering Informatica, SAP, TIBCO, and other competitors of Informatica PIM. Updated: June 2022.
610,190 professionals have used our research since 2012.

Read reviews of Informatica PIM alternatives and competitors

Independent Software Consultant at a tech services company with 11-50 employees
Consultant
Top 5Leaderboard
Great user interface, very good documentation, and offers excellent pricing
Pros and Cons
  • "Their documentation is excellent."
  • "They need to make the workflow more enhanced or dynamic in its functionality."

What is our primary use case?

One use case was mastering client data. I did the installs and a proof of concept for both Profisee and Semarchy side-by-side so that I could showcase the different features of each tool for the client, to guide them to a decision on which product to buy. That use case would have been mastering personal data in the support of a non-profit.

How has it helped my organization?

For this client, they were most excited about Semarchy over Profisee and Informatica. Informatica was kind of out of the running because it was too expensive for this client. We eliminated them early. However, between Profisee and Semarchy, the end-user was more excited about Semarchy, even though Profisee won the end battle. The reason that they liked Semarchy was that the interface was so easy and it was very non-technical. They were all early childhood education end users. They wanted something really simple and unintimidating, and Semarchy offers that.

What is most valuable?

Semarchy offers very good ease of use. The ease of installation and maintenance are also great.

I love their interface. I love the fact that all their features can be implemented out of one client interface. That is wonderful, as one of the things about Informatica is that you've got to go to the administrator tool to do all the backend stuff. That's fine, however, then you've got to do all your data quality stuff through your analyst tool. That's a lot of bouncing around. I love the fact that in Semarchy, you can install it very quickly. You can get it up and running, and you can do a quick proof of concept really fast. 

They're the cheapest of all three of the products that I helped the client evaluate. You get a big bang for the buck with Semarchy.

I love the fact that their APIs were really easy to build straight from that single interface. I love that. 

Their training, their online training is fantastic.

Their tech support is the best out of all three of the solutions I've looked at - including Informatica and Profisee.

Their documentation is excellent.

What needs improvement?

They need to make the workflow more enhanced or dynamic in its functionality. That was the tiebreaker between Profisee and Semarchy - the client had a SQL server development environment and they could do a lot of stuff using the SQL server SDK to do complicated dynamic workflows. With Profisee, it wasn't impossible, however, it was a little bit more complicated to do. Semarchy is working on making it possible. I almost don't want to even say that that would be room for improvement, as I know that they're working. They may have already solved it. 

They could put a little bit more energy into out-of-the-box reporting. That was one of the things that I saw in Profisee that wasn't even really marketed that much. I wasn't even looking to their reporting features until I implemented it. At that point, I was like, "Oh my gosh, look at all this out-of-the-box data quality reporting that's going on! I don't have to necessarily go out and build all these reports from scratch." I was pleasantly surprised to see that in Profisee. I don't know that Semarchy has put the energy into that. They may have, but it certainly not to the extent that the other solution did.

For how long have I used the solution?

I've been using the solution for about a year and a half.

What do I think about the stability of the solution?

The solution is very stable. I would give it a highly favorable rating.

What do I think about the scalability of the solution?

I don't know about scalability. We didn't put that to any kind of test. In my experience, I never put it through any kind of test to see if it could handle millions and millions of rows. 

However, part of that is dependent on how well you have your database, your operating system, and all those other infrastructure pieces tuned. To me, it seems like the tool would handle scaling okay. That said, it's not like I have tried to do any kind of stress testing on it. 

As far as the scalability capability in terms of being able to handle multi-domains, business use cases, and everything, it's very scalable and extensible. You start off with your data model and that's pretty much unlimited. You build the data model and you go from there. There aren't any constraints on that. I would give it a high score on that. I feel that it's very scalable.

How are customer service and technical support?

The technical support is excellent for this product. We're very satisfied with the level of service they provide. It's even better than Informatica's or Profisee's.

Which solution did I use previously and why did I switch?

I also use solutions such a Profisee and Informatica.

I'm always dabbling with solutions, as I've got VMs and I'm always practicing with the installs and trying to keep up with the new features that they're incorporating into their offering. I stay in touch with each solution's technical team.

How was the initial setup?

The initial setup is not complex at all. It's very straightforward. I'd give it a grade of ten out of ten. 

While it's really easy in the cloud, it's a little bit more complicated on the on-prem deployment, however, even that was really easy. In fact, when I did my evaluation for the client, I gave Semarchy an A++ on the standing up the tool.

In terms of deployment, Profisee is very tightly coupled with the SQL server. Therefore, one of the things that was good with Semarchy is that they weren't so tightly coupled with the database. They'll run easily on SQL server or Oracle or Postgre. That is a positive feature for Semarchy.

What was our ROI?

I'm just going to say that since they have the lowest price point and the quickest time to get something up and running, they're always going to show a return on investment. I can't give exact figures as the use case was for a non-profit and they didn't choose Semarchy in the end. I can't say, "yeah, they developed this ROI on the purchase," as they didn't purchase it. 

What's my experience with pricing, setup cost, and licensing?

The pricing of the solution is excellent. It costs less than Informatica and Profisee.

What other advice do I have?

I'm not sure which version of the solution I'm using.

While I typically use the on-premises version, I took their partner training workshop a few months ago and that was in the cloud on AWS.

It is one cool little tool. I was able to take a handful of records as a use case and easily ingested them into the tool, and the customers just loved it. I was able to show how you can easily cleanse those records, standardize those records, match them, and build the golden record very quickly.

I'd advise users to pick a small use case, take it end to end, and build it out that way as a proof of concept. Have fun with it, however, be sure to start out small. Pick the low hanging fruit. I hate saying that, as it sounds so cliche and overused. That said, it really works. You can really have fun with Semarchy, due to the fact that you can build something very quickly. I loved it.

What we would do is, we would have a use case that was like a story about a handful of customers that we wanted to master. We would start off with our little animated presentation, then we would get everybody on a Zoom call and we would walk them through. We'd say "Okay, now we're going to ingest the records. Now, look, see, we can see how X is in here five different times. Let's look at her addresses. Now, let's pick the key fields that we want to use as our match criteria. Etc." 

If you make it fun with the client and bring the client on board, it really gives you the best chance for success. Building those relationships with the data stores, with the different product owners and everything is so important. Otherwise, the client is going to be intimidated and scared, and they'll end up spending a lot of money and it'll sit on the shelf.

Overall, I would rate the solution eight out of ten. To take it to a 10, they would have to, for example, put in dynamic workflows and then improve their reporting to make it a little bit more out-of-the-box. Other than that, it's excellent.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Independent Software Consultant at a tech services company with 11-50 employees
Consultant
Top 5Leaderboard
Great ability to support workflows, excellent out-of-the-box usability, and very good documentation
Pros and Cons
  • "The product is able to utilize the SQL server toolkit and it has tight integration with the SQL server."
  • "The way training is laid out in their Profisee University, makes it really, really hard to find what you need fast."

What is our primary use case?

The client wanted a way to master their clients, which were within a foster care system. The solution would be used for a client that would be a foster care student.

How has it helped my organization?

I felt that their ability to support workflow was really good and this client really needed that as they needed to be able to manage the mastering of those clients through their stewardship cycle. Profisee did a good job with that. 

What is most valuable?

I was really impressed with their out-of-the-box data quality reporting features. There's a lot that they have out of the box that is very, very useful. In some of the other tools, you're on your own when it comes to building the reporting features, although all of the MDM vendors are making that piece more robust. However, I thought that Profisee did a really good job with that.

The product is able to utilize the SQL server toolkit and it has tight integration with the SQL server.

The solution offers lots of good training, including videos, to help you learn aspects of the product. They have all those modules that offer web training. Experts get up and they talk and there are class discussions, and they show you the demos of everything.

What needs improvement?

Profisee needs to better highlight data profiling. At least when I was using this a year ago, the features for data profiling were buried. In other words, they don't pull it out as a key feature, and it really should be. Often, that whole life cycle phase is overlooked, the data profiling aspect.

One of the strengths, like being able to utilize the SQL server toolkit and it's tight integration with SQL server, can be a disadvantage too, as there are some things that they pushed down to the database that makes it difficult when trying to figure out where and how you achieve that functionality. It's buried in the database functionality or in one of the database tools for SQL Server. They need to make it more clear and bring it out more effectively.

If you were to compare it to Informatica, that's where Informatica does a really good job in their tool suite. They've got their whole platform and each one of the tools, they spell out exactly what they do. Even though there is some overlap in functionality, you know what the best practice is and where to do what.

The way training is laid out in their Profisee University, makes it really, really hard to find what you need fast. They'll have these one-hour long video clips and you need to fast forward or rewind to find the actual useful details. There's an index that allows you to just jump to the correct information. That is very frustrating as a developer that needs the information. You can't find the information fast for support at all. They need to be able to articulate their training into something that is searchable. Online training that is text-based and not just buried in a super-long video. A product like SUMADI is a great example of training done right.

When I left that client, I really wanted them to put more emphasis on profiling. I'd have to go back out there to their website and see if they actually have anything of that nature. It wasn't obvious to me, even their best practices with profiling. In Informatica, profiling isn't overlooked at all. In Profisee, it seems it might have been. I'd like more emphasis placed on the tool if possible.

For how long have I used the solution?

I've been using the solution for a year and a half at this point.

What do I think about the stability of the solution?

The solution is very stable. It's a reliable product.

What do I think about the scalability of the solution?

The solution can scale very well. It's so tightly coupled with the database platform and you've got somebody that is managing your SQL Server environment. They're going to be able to take on managing the growth of that software tool as well.

How are customer service and technical support?

Technical support is excellent. I'm quite satisfied with the level of service provided.

Which solution did I use previously and why did I switch?

I've used a few different solutions such as Informatica and Semarchy.

There are certain things in our tool evaluation between Semarchy, Profisee and Informatica where I thought that Semarchy was the easiest one to stand up with and get it up and running really, really fast. 

If you have users that aren't really technical, then Semarchy is the way to go. If they don't need very sophisticated workflow functionality, Semarchy is a lot cheaper and you can get it up and running right away. Their ability to support REST APIs is really, really simple. So in that way, Semarchy wins. 

I've found, for example, that while Profisee's ability to support workflow was really good, Informatica was even better at that aspect. There are other things like profiling and data quality stuff, Informatica beats everybody hands down.

How was the initial setup?

I'd rate the initial setup at a six out of ten. It's not straightforward, or too complex. If you compare it to a solution like SUMADI, that's quite straightforward, and this is more moderate in the level of difficulty. Some tasks flow nicely and in other areas, you struggle.

It wasn't cohesive. Looking back, there were some things in the DBA that were being a little bit cantankerous, and that was hard to communicate with the client sometimes. Installing and configuring it was not straightforward. They could do a better job if I'm trying to be fair and honest with them. They could do a better job and have a more comprehensive install guide for their product.

There may have been issues associated with the APIs and stuff you had to do on SQL Server. You just had to spend too much time chasing things. 

There are videos, whoever, that cover large aspects of the implementation that are helpful. I'd take screenshots at key points in the video and that would help me figure out what to do. Still, it would be helpful to have a search feature within the videos, so that you could go to the exact spots you needed more easily.

What was our ROI?

The client is doing really well. In fact, they've been published in several IT magazines for their efforts, and also for their Data Cleansing efforts and their Data Stewardship. They've learned how to use the product already. They're comfortable with it. They are in an effort to monetize some of their functionality, and they're a non-profit, so they're doing a lot of really cool things and they're doing a great job with everything. I'm very proud of them.

What other advice do I have?

We handle many aspects of the solution, including initially handling the tool evaluation and then installing it and doing proof of concepts, build-outs, and training of the client.

I'm not sure of which version of the solution we're using.

I'd advise new users to just have fun with it. Master Data Management can be a daunting endeavor. Just take small use cases, and do a proof of concept and take it end to end. That is the best way to be successful. And we made it fun with the users. We would start off with a little animated video as those in the Foster care system are into early childhood development. We showed them a small use case and we walked them through the process. In the end, we just had a lot of fun.

Our biggest lesson was learning how to gain the trust of our client community, especially if they're non-technical. Learning how to gain their trust and make it fun was huge. It's so daunting and typically clients are more concerned about their daily jobs. If you can gain their trust and make it fun they don't resent the process. They got excited and so did we. Just that trust, that initial trust component is key. 

Overall, I would rate the solution eight out of ten. The only thing they really need to do is to fix the online training so that users can zero in on specific areas a bit easier. Indexing the videos would go a long way towards solving this one issue.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Master Data Management (MDM) Software
June 2022
Get our free report covering Informatica, SAP, TIBCO, and other competitors of Informatica PIM. Updated: June 2022.
610,190 professionals have used our research since 2012.