44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100
Top Rated
156 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

Highlights

Informatica Intelligent Cloud Services and Matillion are both software designed to help organizations extract and transform business data.  Informatica Intelligent Cloud Services is an integration platform as a service built to help businesses synchronize cloud and on-premise applications.  Matillion is a data integration tool designed to help businesses quickly pool together data from multiple sources such as SaaS applications. Matillion is most popular with mid-sized businesses, while Informatica Intelligent Cloud Services is most popular with large enterprises, perhaps due to its robust development tools.

Features

Informatica Intelligent Cloud Services and Matillion both allow businesses to transform and extract data, but they also have a few standout features that set them apart from each other.

Informatica Intelligent Cloud Services provides built in support for over 80 SaaS applications, making it a strong choice for businesses with a variety of applications to pull in data from.  Additionally, Informatica Intelligent Cloud Services provide support for a wide variety of regulatory compliance standards including HIPAA, Privacy Shield, and SOC 3.  Lastly, Informatica Intelligent Cloud Services allows for data sharing over the cloud so users can easily obtain and provide business data to other users.

Matillion provides robust compliance support specifically for GDPR compliance, making it a great software for organizations that do business in Europe.  Additionally, Matillion provides a simple to use user interface, so users will require minimal training in order to get the most out of the software.

Limitations

Informatica Intelligent Cloud Services and Matillion provide data integration features for businesses, but they also have a few limitations that are important to consider.

Informatica Intelligent Cloud Services offers a number of compliancy features, but it doesn’t ensure GDPR compliance.  For businesses that deal in Europe, this can be an important drawback.  Additionally, Informatica Intelligent Cloud Services has a complex user interface, so users will require significant training to start using it optimally.

Matillion provides support for GDPR compliance, but not for other regulatory standards, so businesses with medical data may prefer other options. For businesses with many SaaS applications, Matillion provides around 40 native integrations, compared to Informatica Intelligent Cloud Service’s 80.

Pricing

Informatica Intelligence Cloud Services and Matillion do not provide exact pricing information.  Businesses can reach out to the vendor for a quote depending on the exact needs of the organization.

Matillion pricing similarly depends on the needs of the business, but it starts as low as $1.37 an hour and offers support for Amazon Redshift, Google BigQuery, Azure Synapse Analytics, and Snowflake.

Community Pulse

Feature Set Ratings

    Cloud Data Integration

    8.8

    Informatica Intelligent Cloud Integration Services

    88%

    Matillion

    Feature Set Not Supported
    N/A
    Informatica Intelligent Cloud Integration Services ranks higher in 6/6 features

    Pre-built connectors

    9.0
    90%
    14 Ratings
    N/A
    0 Ratings

    Connector modification

    8.6
    86%
    13 Ratings
    N/A
    0 Ratings

    Support for real-time and batch integration

    9.6
    96%
    14 Ratings
    N/A
    0 Ratings

    Data quality services

    8.7
    87%
    13 Ratings
    N/A
    0 Ratings

    Data security features

    8.3
    83%
    13 Ratings
    N/A
    0 Ratings

    Monitoring console

    8.3
    83%
    14 Ratings
    N/A
    0 Ratings

    Data Source Connection

    Informatica Intelligent Cloud Integration Services

    Feature Set Not Supported
    N/A
    8.9

    Matillion

    89%
    Matillion ranks higher in 2/2 features

    Connect to traditional data sources

    N/A
    0 Ratings
    9.2
    92%
    92 Ratings

    Connecto to Big Data and NoSQL

    N/A
    0 Ratings
    8.7
    87%
    58 Ratings

    Data Transformations

    Informatica Intelligent Cloud Integration Services

    Feature Set Not Supported
    N/A
    8.5

    Matillion

    85%
    Matillion ranks higher in 2/2 features

    Simple transformations

    N/A
    0 Ratings
    9.0
    90%
    93 Ratings

    Complex transformations

    N/A
    0 Ratings
    7.9
    79%
    92 Ratings

    Data Modeling

    Informatica Intelligent Cloud Integration Services

    Feature Set Not Supported
    N/A
    8.9

    Matillion

    89%
    Matillion ranks higher in 6/6 features

    Data model creation

    N/A
    0 Ratings
    9.1
    91%
    34 Ratings

    Metadata management

    N/A
    0 Ratings
    9.0
    90%
    41 Ratings

    Business rules and workflow

    N/A
    0 Ratings
    9.0
    90%
    81 Ratings

    Collaboration

    N/A
    0 Ratings
    9.0
    90%
    82 Ratings

    Testing and debugging

    N/A
    0 Ratings
    9.2
    92%
    83 Ratings

    feature 1

    N/A
    0 Ratings
    8.2
    82%
    4 Ratings

    Data Governance

    Informatica Intelligent Cloud Integration Services

    Feature Set Not Supported
    N/A
    8.2

    Matillion

    82%
    Matillion ranks higher in 2/2 features

    Integration with data quality tools

    N/A
    0 Ratings
    8.2
    82%
    23 Ratings

    Integration with MDM tools

    N/A
    0 Ratings
    8.2
    82%
    21 Ratings

    Attribute Ratings

    • Informatica Intelligent Cloud Integration Services is rated higher in 2 areas: Likelihood to Renew, Support Rating
    • Matillion is rated higher in 1 area: Likelihood to Recommend

    Likelihood to Recommend

    8.3

    Informatica Intelligent Cloud Integration Services

    83%
    14 Ratings
    9.6

    Matillion

    96%
    94 Ratings

    Likelihood to Renew

    9.0

    Informatica Intelligent Cloud Integration Services

    90%
    1 Rating
    6.5

    Matillion

    65%
    7 Ratings

    Usability

    Informatica Intelligent Cloud Integration Services

    N/A
    0 Ratings
    8.8

    Matillion

    88%
    93 Ratings

    Support Rating

    8.0

    Informatica Intelligent Cloud Integration Services

    80%
    6 Ratings
    7.5

    Matillion

    75%
    10 Ratings

    Implementation Rating

    Informatica Intelligent Cloud Integration Services

    N/A
    0 Ratings
    8.2

    Matillion

    82%
    2 Ratings

    Product Scalability

    Informatica Intelligent Cloud Integration Services

    N/A
    0 Ratings
    7.5

    Matillion

    75%
    86 Ratings

    Vendor post-sale

    Informatica Intelligent Cloud Integration Services

    N/A
    0 Ratings
    9.1

    Matillion

    91%
    1 Rating

    Vendor pre-sale

    Informatica Intelligent Cloud Integration Services

    N/A
    0 Ratings
    9.1

    Matillion

    91%
    1 Rating

    Likelihood to Recommend

    Informatica

    Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.
    Read full review

    Matillion

    I always suggest Matillion for organizations that do not want to spend money and time developing their own ETL tool, Matillion is a mature one and meet all requirements about it. It is important to check if you have any edge case and have a look if it is covered by Matillion or not.
    Read full review

    Pros

    Informatica

    • Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
    • The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
    • The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.
    Read full review

    Matillion

    • Extremely user-friendly workflow orchestration between multiple languages such as SQL, Python, bash, and various API connectors
    • Salesforce connectors to pull and push data between systems save us a ton of time
    • Matillion Exchange workflows allow for easy sharing of templated best practice transformation jobs with ease
    • Very responsive support
    Read full review

    Cons

    Informatica

    • The User Interface can be a bit difficult to get in initial stages.
    • Error messages are hard to understand which sometimes takes a lot of time for the resolution
    • Cannot Implement complex SQL queries which should be fixed in future release.
    Read full review

    Matillion

    • Passing variables between jobs (orchestration or transformation) feels a bit clunky. It can also be frustrating that you can't pass a variable back up to the calling orchestration job, you can only pass it down to child jobs.
    • It would be great to have some kind of debug mode, through which you're able to 'step through' the various tasks in an orchestration/transformation job.
    • Matillion's generic API functionality is difficult to understand. Things like handling pagination and rate limiting are complex. Although I understand improvements have been made in recent versions.
    Read full review

    Pricing Details

    Informatica Intelligent Cloud Integration Services

    Starting Price

    Editions & Modules

    Informatica Intelligent Cloud Integration Services editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Matillion

      Starting Price

      Editions & Modules

      Matillion editions and modules pricing
      EditionModules

      Footnotes

        Offerings

        Free Trial
        Free/Freemium Version
        Premium Consulting/Integration Services

        Entry-level set up fee?

        No setup fee

        Additional Details

        Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.

        Get More Info!

        Likelihood to Renew

        Informatica

        No answers on this topic

        Matillion

        With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
        Read full review

        Usability

        Informatica

        No answers on this topic

        Matillion

        Pretty good UI, especially for a completely web-based system. Source control integration is a bit clunky at times, but overall makes code versioning and branching much more simple, since it's largely within the same context as the rest of the code. Finding some core settings can be difficult - they're just not where one would expect them to be.
        Read full review

        Support Rating

        Informatica

        I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.
        Read full review

        Matillion

        Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
        Read full review

        Implementation Rating

        Informatica

        No answers on this topic

        Matillion

        Not really a part of the implementation to give fare insight.
        Read full review

        Alternatives Considered

        Informatica

        First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.
        Read full review

        Matillion

        We used Airflow for a year before switching to Matillion. We switched to Matillion because the Airflow servers were not stable, and we didn't have any in-house expertise that could manage the Linux OS which Airflow is built on. We were constantly frustrated by the fact that we had to wait for a consultant whenever we wanted to manage one of the servers, or if something was down we had to wait for someone to fix it. Also, Airflow doesn't have a GUI that is drag and drop. It is a lot more work to manage the flow of the scripts in Airflow, and requires a lot more explanation, especially for an entry level data engineer. There is a lot more coding in Airflow, which is fine if you are a good coder. However, Matillion offers a bigger tool set for those who just want to focus on building an ETL pipeline, and don't care to do a lot of coding.
        Read full review

        Scalability

        Informatica

        No answers on this topic

        Matillion

        The product scales great for small to medium size teams or groups. For groups larger it becomes more challenging and requires more individual instances depending on the volume of running jobs and concurrent users - it handles 10's of concurrent users and jobs very well but much larger than that would be extremely difficult on the largest instance or cluster that is available at this time.
        Read full review

        Return on Investment

        Informatica

        • Cut costs on the number of staff we need for data import.
        • Cut costs for automation that can be done for data that no longer has to be manually imported.
        • We've saved countless dollars by eliminating duplicates in our system with this tool.
        Read full review

        Matillion

        • Matillion had had a positive impact on our ability to scale up our ETL process without increasing our headcount. We've been able to double the number of jobs we have in the last year.
        • A positive impact on the amount of time we need to investigate failures. Coming from other tools that had high rates of failures (say 2 jobs failing a week), we have not seen as many technical failures from Matillion. This reduces the number of resources we focus on tracking down failures, fixing, and re-running jobs by 25%.
        Read full review

        Screenshots

        Add comparison