TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    ER/Studio

    Score9.9 out of 10
    N/AER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.

    $2,687

    per year per user

    Informatica MDM & 360 Applications

    Score5.5 out of 10
    N/AInformatica MDM is an enterprise master data management solution that competes directly with IBM's InfoSphere and Oracle's Siebel UCM product.Informatica MDM and the company's 360 applications present a multidomain solution with flexibility to support any master data domain and relationship—whether on-premises, in the cloud, or both.N/A
    Pricing
    ER/StudioInformatica MDM & 360 Applications
    Editions & Modules
    Standard
    $2,687
    per year per user
    Professional
    $3,693
    per year per user
    Enterprise
    Custom
    per year per user
    No answers on this topic
    Offerings
    Pricing Offerings
    ER/StudioInformatica MDM & 360 Applications
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional DetailsPricing for new customers only, first year maintenance included. Maintenance includes access to technical support and product updates for the defined period of the agreement.—
    More Pricing Information
    Community Pulse
    ER/StudioInformatica MDM & 360 Applications
    Considered Both Products
    Idera, Inc.
    No answer on this topic
    Informatica
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    88%
    Would buy again
    14 Answers
    Delivers good value for the price
    No answers on this topic
    93%
    Delivers good value for the price
    14 Answers
    Happy with the feature set
    No answers on this topic
    94%
    Happy with the feature set
    15 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    87%
    Lived up to sales and marketing promises
    13 Answers
    Implementation went as expected
    No answers on this topic
    79%
    Implementation went as expected
    11 Answers
    Best Alternatives
    ER/StudioInformatica MDM & 360 Applications
    Small Businesses
    No answers on this topic
    No answers on this topic
    Medium-sized Companies
    No answers on this topic
    No answers on this topic
    Enterprises
    erwin Data Modeler
    Score10 out of 10
    SAP Master Data Governance
    Score8 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    ER/StudioInformatica MDM & 360 Applications
    Likelihood to Recommend
    8.0
    (5 ratings)
    9.0
    (20 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    9.0
    (1 ratings)
    Usability
    -
    (0 ratings)
    9.0
    (1 ratings)
    Support Rating
    9.0
    (1 ratings)
    9.0
    (2 ratings)
    Implementation Rating
    -
    (0 ratings)
    8.0
    (1 ratings)
    User Testimonials
    ER/StudioInformatica MDM & 360 Applications
    Likelihood to Recommend
    Idera, Inc.
    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
    Read full review
    Informatica
    It is a robust software with great management and data model. It can be difficult to learn how to use and deploy the first time but the mapping and features work very well and have optimized our productivity and cost savings. We can customize reports, create rules and integrate with other applications. Overall I recommend it.
    Incentivized
    Read full review
    Pros
    Idera, Inc.
    • 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
    Read full review
    Informatica
    • This program raises us to a professional level where we have better versatility to control all the media of my work and have a correct response for each scenario.
    • It is essential to be right about the destination and development of my data, Informatica MDM is here to simplify all these processes for its users.
    Incentivized
    Read full review
    Cons
    Idera, Inc.
    • 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
    Read full review
    Informatica
    • It is unfortunate how this program has a couple of limitations in terms of insertions; it does not have the ability to agglomerate and archive the data in real-time by groups.
    • To have automation functions, the program is very limited in performing one task at a time, compared to other systems that perform functions simultaneously.
    Incentivized
    Read full review
    Likelihood to Renew
    Idera, Inc.
    No answers on this topic
    Informatica
    Supporting well in managing our huge customer base and managing the customer hierarchies well aligned with transactional processes
    Incentivized
    Read full review
    Usability
    Idera, Inc.
    No answers on this topic
    Informatica
    Strong Customer MDM capabilities for de-duplication, merging, golden record, exposing customer master data. Strong Integration capabilities
    Incentivized
    Read full review
    Support Rating
    Idera, Inc.
    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
    Read full review
    Informatica
    I'm not sure since I never used support. My colleagues never had any issues with it, therefore my rating would be an 8 with a certain range of uncertainty.
    Read full review
    Implementation Rating
    Idera, Inc.
    No answers on this topic
    Informatica
    The integrator did a fair job and even though Business Change Management was complex, it was well concluded on time
    Incentivized
    Read full review
    Alternatives Considered
    Idera, Inc.
    ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.
    Incentivized
    Read full review
    Informatica
    Informatica MDM has proven it's worth in the organization by driving the revenue growth. It saves our lot of time by filtering out duplicate values and helps in solving critical business problems. It is very helpful when we deal with a lot of data. Apart from this we can populate data on various third party integration which is most useful case
    Incentivized
    Read full review
    Return on Investment
    Idera, Inc.
    • 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
    Read full review
    Informatica
    • I cannot speak to this for 2 reasons. 1. I am not privy to the financials associated with this implementation or the previous one. 2. We have not hit our 'go-live' for this implementation yet to compare it's performance to our previous solution.
    Incentivized
    Read full review
    ScreenShots

    ER/Studio Screenshots

    Screenshot of logical data models in ER/Studio Data Architect.Screenshot of data catalog in ER/Studio Data Architect.Screenshot of data glossaries in ER/Studio Data Architect.