ER/Studio vs. RapidMiner

Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms

Incentivized

RapidMiner is really fantastic to perform fast ETL processes and work on your data as you want, no matter what is the source. You will really save a lot of time when you learn how to use it. You can create mining analysis with several algorithms, and thanks to add-ons, you can apply a lot of techniques. It will not replace a business intelligence dashboard but it allows to create great datamarts for your BI tools. One negative thing is that It's no easy to share your outputs.

Incentivized

• ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type.
• ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names.
• My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models.

Incentivized

• I am very impressed at how easily you can work within RapidMiner without much data analytics training. Plus with the help of the crowd, you can see what steps others have taken with their data analytics projects.
• Text mining was simple and clean. We used this for our call transcription problem where we didn't have the resources to listen to each call. We needed to qualify each call based on some key phrases.
• Our direct mail program was large and not very targeted. Using RapidMiner, we were able to isolate a predictive level we felt comfortable with and decided not to send to anyone below that level. We saved quite a bit of money.

Incentivized

• ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running.
• The repository can be slow when the model count gets larger. By large I mean 20 to 30 models.
• A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two.

Incentivized

• I hope RapidMiner would be the first data science platform that allows data scientists to change the behaviour of a machine learning algorithm that already exists in the repository. For example, I want to be able to change the way a genetic algorithm mutates.
• Automatic programming: One day, I hope RapidMiner can automatically generate codes in any 4th generation programming language based on the developed model.
• More tutorials/samples needed: Why doesn't RapidMiner becomes the next 'UC Irvine Machine Learning Repository'? Provide real examples and real cases for users to study and understand the best practices in modelling. RapidMiner already has some datasets for a tutorial. Besides the existing samples, I hope RapidMiner can provide more sample data and examples.

Incentivized

Very fast and user-friendly tool

Incentivized

Very use to use and learn

Incentivized

I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.

Incentivized

ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.

Incentivized

We tried different data tools and we figured we give RapidMinder Studio a shot as one of our employees had experience with it, and when compared to some of the other tools that we used it was the best fit among the test group that we used. Overall it was a little more fluid and user-friendly.

Incentivized

• ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase.

Incentivized

• Thanks to the patters that RapidMiner has detected, we have been able to follow clues in the right direction, both for the Protein Interaction Network Analysis and for the Epilepsy Research
• Students and participants of the machine learning workshops have learned about this technology and about the tool

Incentivized