15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100
38 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Likelihood to Recommend

Azure Synapse Analytics (Azure SQL Data Warehouse)

It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards
Anonymous | TrustRadius Reviewer

Informatica Intelligent Cloud Services

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.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Cloud Data Integration

Azure Synapse Analytics (Azure SQL Data Warehouse)
Informatica Intelligent Cloud Services
7.6
Pre-built connectors
Azure Synapse Analytics (Azure SQL Data Warehouse)
Informatica Intelligent Cloud Services
7.4
Connector modification
Azure Synapse Analytics (Azure SQL Data Warehouse)
Informatica Intelligent Cloud Services
6.7
Support for real-time and batch integration
Azure Synapse Analytics (Azure SQL Data Warehouse)
Informatica Intelligent Cloud Services
7.9
Data quality services
Azure Synapse Analytics (Azure SQL Data Warehouse)
Informatica Intelligent Cloud Services
7.9
Data security features
Azure Synapse Analytics (Azure SQL Data Warehouse)
Informatica Intelligent Cloud Services
7.9
Monitoring console
Azure Synapse Analytics (Azure SQL Data Warehouse)
Informatica Intelligent Cloud Services
8.0

Pros

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • It is very cost-effective
  • Development time needed was much less in comparison to other systems
  • Played very nicely with our ETL and OLAP reporting tools
Samir Patel, PMP | TrustRadius Reviewer

Informatica Intelligent Cloud Services

  • 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.
Anonymous | TrustRadius Reviewer

Cons

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • Limited T-SQL query library
  • It is not suitable for OLTP environment
  • Doesn't support cross-database queries
Prabhu Sundararaj | TrustRadius Reviewer

Informatica Intelligent Cloud Services

  • Incremental jobs can run very slowly on large table updates. Incremental jobs do not work at all for Salesforce.com history tables.
  • No real ability to report on what jobs you have set up or the performance of those jobs (failures, number of records copied, etc.).
  • It is only available within the user interface and you basically have to copy paste it from the browser if you want the information.
Vaibhav Khanna ☁⚡ | TrustRadius Reviewer

Usability

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 8.0
Based on 1 answer
It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.
Prabhu Sundararaj | TrustRadius Reviewer

Informatica Intelligent Cloud Services

No score
No answers yet
No answers on this topic

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 7.9
Based on 3 answers
I like their Support team
Anonymous | TrustRadius Reviewer

Informatica Intelligent Cloud Services

Informatica Intelligent Cloud Services 8.0
Based on 6 answers
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.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Azure Synapse Analytics (Azure SQL Data Warehouse)

SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data
Anonymous | TrustRadius Reviewer

Informatica Intelligent Cloud Services

We were originally given Informatica Cloud as a bundled piece of software with the Salesforce implementation company we signed up for so we didn't do a lot of detailed searching for competitors. Since then we have seen it go against Mulesoft Anypoint and Zapier. Both were good, but Informatica Cloud just worked so much better for everything we are using and was cheaper.
Anonymous | TrustRadius Reviewer

Return on Investment

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • We have had an improvement in our overall processing time
  • Cost was much lower than most of its competitors
  • Our reporting needs have grown and housing the data here has been great
Samir Patel, PMP | TrustRadius Reviewer

Informatica Intelligent Cloud Services

  • One positive ROI is that Informatica Cloud ensures that data is being imported in the same format each and every time so a user can be confident of data integrity.
  • Secondly, being able to match of certain fields prevents record duplication.
Anonymous | TrustRadius Reviewer

Pricing Details

Azure Synapse Analytics (Azure SQL Data Warehouse)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Informatica Intelligent Cloud Services

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Azure Synapse Analytics (Azure SQL Data Warehouse)
8.3
Informatica Intelligent Cloud Services
8.6

Usability

Azure Synapse Analytics (Azure SQL Data Warehouse)
8.0
Informatica Intelligent Cloud Services

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)
7.9
Informatica Intelligent Cloud Services
8.0

Add comparison