TrustRadius
Informatica’s Intelligent Cloud Services (IICS) platform is a solution for synchronizing and integrating cloud and on-premise applications. It offers prebuilt connectors and actions between applications and programs, allowing for data transformation within the program, as well as case-specific services.Informatica Cloud is a must for any organization that uses SalesforceIt is being used by our Integration team. Basically, it is used to solve business problems where integration needs to be done between a legacy system and Salesforce.,First and foremost is its capability of integration Secondly, the transformation is just so simple It has everything which you need to start from scratch and deploy in the cloud.,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.,8,A positive impact is bringing more projects. Getting data out of various systems such as Salesforce.com or FTP and consolidating it into tables in one central database. Having the ability to run data transformation tasks (the equivalent of batch jobs in SF or stored procedures in SQL) on a schedule without consuming those resources on the target or source systems.,,Dell BoomiGood for the valueRight now we are still in test phase. It is used for ETL from local server and AWS.,We like the fact that Informatica Cloud can connect to all on premise and cloud databases with TLS 1.2, which helps to ensure data transfer is secure. I especially like the Mapping Designer which is easy to use and does the job efficiently. Informatica Cloud's replication allow us to replicate data between load and cloud servers in near real time.,Coming from the Informatica PowerCenter world, IDE is different so it might take some time to get used to. The error information seems less informative than PowerCenter. Hopefully the tool can have online patch capability so that we can keep outages to minimum.,8,Existing ETL process can support cloud, which reduces training and rework I am glad we do not have to pay big one time purchase for cloud,MySQLInformatica Cloud -- a professional level product for professional organizationsWe currently use Informatica Cloud to integrate data between our Oracle financial system, Salesforce.com and our internal transactiton processing system. Being cloud-based, we do not have the added overhead of maintaining our own server infrastructure to implement this solution. Informatica Cloud is a critical part of allowing us to meet both our technical and business requirements.,Informatica Cloud has a relatively easpy learning curve for new users and developers Multiple database sources and targets are easily defined Extensive built-in features and functions allow us to define the required mapping for our data needs,Some of the error messages are cryptic and difficult to discern the meaning and cause of the error The ability to use sophisticted and complex SQL is somewhat limited Some of the syntax for the built-in data formatting is a little difficult to understand,8,Informatica Cloud has proven itself a worthwhile investment as it has allowed us to "retire" numerous other data systems through integration The only negative to Informatica Cloud (the same with most other tools) is the substantial upfront cost of implementation (licensing/professional services, etc.),SQL Server Integration Services,SQL Server Integration Services, Snagit, SQL DeveloperGreat for agile BI teams, complementary to PowerCenterWe use both Informatica Cloud and Informatica Power Center enterprise-wide as our primary ETL tool. It helps manage our internal gateways moving around data from our ERP systems into containers and other tools for extracting into reporting or analytics. Our primary use of the cloud product is to extract data from both our internal systems and our external CRM tools (i.e. Salesforce) into Azure Data Warehouse instances for us to leverage with BI tools and Website personalization tools.,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.,Price is a factor, the charges for each and every connector to various systems can add up, and seem to be annual expenses to account for in budget each year. We switched to just using Cloud between 2 systems so we only have to pay for 2 connectors because the price is pretty high. For other sources we’ve begun building out in Mulesoft to keep the budget in check. Access to customer service is not the greatest. When running into problems the first line of defense for cloud is that it is not a Cloud issue and they cannot help. They are correct, of course, but could at least offer some support services to help us track back through permissions and secure agent setup to help identify and fix our issues, not just brush us off. Updates to the Cloud product seem to hit without too much communication or follow through. While some of this could be prevented by our internal Administrator, I do think the level of communications from Informatica to the Admin are very thin as well. New features should be broadcast when you log in, and changes should be communicated within the app, and that does not happen with Informatica Cloud.,8,Because Cloud is not as advanced as On-Prem, you may need to have both which can double your costs. If that is the case try to split them out so you don’t have to pay for the same connectors for both products. You would think buying a connector for one would let you have it for both products, but that is not always the case, with any software I suppose. Speed to get data out and into a cloud container is worth every penny. If you have a capable BI team, they can run ahead of or even fully without any Informatica developers to build the ETL. Once you set up the secure agent and have the end container stable, any worthwhile analyst can extract and push their data to the cloud. Very helpful for lean teams using tools working both sides of the firewall. The ability for the BI team to manage their own integrations has had tremendous savings on the personnel budget by reducing the need for Informatica developers. Now we can get by with just 1 or 2 developers monitoring and shoring up integrations and let the BI Analysts pick and choose their own data sets to manage.,Mule ESB, Informatica Enterprise Data Integration, Informatica Data Explorer, Alteryx Connect, Talend Cloud Integration, Actian DataConnect, Oracle Business Intelligence Cloud Service and PowerCenter,Mule ESB, PowerCenter, Alteryx Analytics, Qlik Sense, Microsoft Power BI, Business Objects SRC, Actian Analytics Platform, Actian DataConnect, Talend Cloud Integration, Talend Data Integration, ThoughtSpot, Salesforce Analytics Cloud, Salesforce Service Cloud, Azure SQL Database, Oracle Advanced Analytics, Microsoft Azure, Azure Active Directory, Azure API Management, Google Maps API, Microsoft SQL Server, Microsoft Visual Studio Code, QlikView, Tableau Server, Hitachi Enterprise Cloud, Infor LN, IBM Analytics Engine, IBM InfoSphere Warehouse, Medallia, dotConnect for Salesforce, Salesforce CPQ (formerly SteelBrick), Oracle Engagement Cloud (formerly Oracle Sales Cloud)Informatica Cloud is an amazing resource for data import automation and duplicate checkingWe use Informatica Cloud to help leverage data and reporting in our instance of Salesforce. It is used daily to import new contacts and leads to our instance of Salesforce to allow for better tracking and elimination of duplicates and other data integrity issues. We originally used native Salesforce support for importing but found that Informatica Cloud provided so much more depth and insights.,Data importing Duplicate checking Duplicate elimination Data tracking Data import automation,The UI can be somewhat difficult to get used to. This recently changed and was made somewhat better, but it is still somewhat difficult for new users to work. Some of the duplicate management is hidden or hard to find initially. The single Sign-on integration at first can be tricky to navigate if you aren't a Salesforce Admin.,9,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.,Zapier and Anypoint Platform,Zapier, DemandTools, TargetXInformatica Cloud, from a real user.Informatica cloud is used to connect our numerous Cloud SaaS solutions to our internal and cloud data platforms. It is used exclusively by our Technology department.,Informatica does a great job partnering with other Cloud solution providers, creating packaged solutions.,I'd like to see Informatica combine the Informatica Cloud and PowerCenter capabilities.,8,Informatica Cloud has allowed us to quickly connect numerous SaaS-based solutions without having to be proprietary SaaS web service experts. By leveraging Informatica Cloud packaged connectors we were integrating data within days, not weeks or months.,PowerCenter,Alteryx Analytics, IBM Cognos, IBM InfoSphere Information ServerCost Effective Data Integration Software for Low - Mid Complex ArchitectureInformatica Cloud Data Integration Suite is used by our client for seamlessly integrating data between Infor ERP and Salesforce CRM. Salesforce CRM is used across Organization by the key users of the different business entities. Informatica Cloud Data Integration helps in asynchronous transfer of data from Infor ERP to Salesforce CRM and vice versa. Since it is a cloud based application, a physical server is not required to house the applications. It helps meet the business requirements and is very cost effective.,Implementation of any integrations with Informatica Cloud Data can be done easily. A consultant with base knowledge about integrations can easily implement. It has inbuilt aggregate functions which can be used during mapping source table fields with target table fields. Source and Target database connections can be easily configured with minimum no of steps. Source data can be easily filtered through by applying conditions.,It doesn't quite support complex implementations. It doesn't support complex SQL Queries. Working towards attaching a document to a mail, needs a work around. A shell script has to be written and to be executed. Configuring integration for Re-processing of failed records needs proper design of the system.,7,Implementation of Integration of Infor ERP with Salesforce through Informatica Cloud Data Integration was cost effective. Business users benefited with a lot of analytical business reports and historical data reports that would help them in better decision making. Business benefited in having all required information in one application/dashboard, instead of wandering to multiple applications/screens for getting the required information.,Oracle Data Integrator,Infor BI, Microsoft AccessStandardized and Automated Data Imports Using Informatica CloudInformatica Cloud is an application integrated with TargetX SRM and SalesForce.com. It is currently used by the Office of Admission, and eventually the Office of Graduate and Professional Studies as well. Informatica Cloud is used for importing data into our CRM (TargetX) through the use of built-in data mappings.,Informatica Cloud is a great tool for automating data imports. Raw data files can be scheduled to run at designated times, and using pre-built mappings ensures that the data goes into the system accurately each time. It is also a great tool for converting raw data into specific formatting. For example, configuring the mapping so that the first letter of a first, middle or last name is always capitalized. Additionally, Informatica Cloud has a built-in field-matching tool so that records that already exist are updated rather than having duplicates created.,Learning the syntax for formatting the data can be difficult, and some of the functions are not as intuitive as they could be. Power Centers are difficult to create on your own. A power center is a tool that converts one file type to another prior to importing the data: for example, changing a .txt. file to a .csv file. Making sense of certain error reports can also be challenging. When a file errors and does not import, the system will provide a report so that errors can be fixed. These reports do not always provide straightforward reasons why the file did not import.,9,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.,Dataloader.io,Salesforce.com, Google Drive,NoUnspecified
Informatica Cloud
32 Ratings
Score 7.5 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>TRScore

Informatica Cloud Reviews

Informatica Cloud
32 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.5 out of 101

Do you work for this company?

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-8 of 8)

Companies can't remove reviews or game the system. Here's why.
Vaibhav Khanna ☁⚡ profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
It is being used by our Integration team. Basically, it is used to solve business problems where integration needs to be done between a legacy system and Salesforce.
  • First and foremost is its capability of integration
  • Secondly, the transformation is just so simple
  • It has everything which you need to start from scratch and deploy in the cloud.
  • 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.
The ability to replicate tables from one target to another. It takes care of all of the field type creation and adapts to new fields being created on the fly without having to alter the target. It has a very easy learning curve with a point-and-click interface. It's good for regular business analysts who are not very technical.
Read Vaibhav Khanna ☁⚡'s full review
Feng Cai profile photo
March 02, 2019

Good for the value

Score 8 out of 10
Vetted Review
Verified User
Review Source
Right now we are still in test phase. It is used for ETL from local server and AWS.
  • We like the fact that Informatica Cloud can connect to all on premise and cloud databases with TLS 1.2, which helps to ensure data transfer is secure.
  • I especially like the Mapping Designer which is easy to use and does the job efficiently.
  • Informatica Cloud's replication allow us to replicate data between load and cloud servers in near real time.
  • Coming from the Informatica PowerCenter world, IDE is different so it might take some time to get used to.
  • The error information seems less informative than PowerCenter.
  • Hopefully the tool can have online patch capability so that we can keep outages to minimum.
Informatica Cloud is designed to do ETL between on-premise and cloud servers. As organizations move certain parts (or all) of IT into cloud, there will be a long period of time in which both environments coexist. We use Informatica Power Center to do ETL in a local data center, I am glad we can do the same thing to cloud.
Read Feng Cai's full review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
We currently use Informatica Cloud to integrate data between our Oracle financial system, Salesforce.com and our internal transactiton processing system. Being cloud-based, we do not have the added overhead of maintaining our own server infrastructure to implement this solution. Informatica Cloud is a critical part of allowing us to meet both our technical and business requirements.
  • Informatica Cloud has a relatively easpy learning curve for new users and developers
  • Multiple database sources and targets are easily defined
  • Extensive built-in features and functions allow us to define the required mapping for our data needs
  • Some of the error messages are cryptic and difficult to discern the meaning and cause of the error
  • The ability to use sophisticted and complex SQL is somewhat limited
  • Some of the syntax for the built-in data formatting is a little difficult to understand
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 this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use both Informatica Cloud and Informatica Power Center enterprise-wide as our primary ETL tool. It helps manage our internal gateways moving around data from our ERP systems into containers and other tools for extracting into reporting or analytics. Our primary use of the cloud product is to extract data from both our internal systems and our external CRM tools (i.e. Salesforce) into Azure Data Warehouse instances for us to leverage with BI tools and Website personalization tools.
  • 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.
  • Price is a factor, the charges for each and every connector to various systems can add up, and seem to be annual expenses to account for in budget each year. We switched to just using Cloud between 2 systems so we only have to pay for 2 connectors because the price is pretty high. For other sources we’ve begun building out in Mulesoft to keep the budget in check.
  • Access to customer service is not the greatest. When running into problems the first line of defense for cloud is that it is not a Cloud issue and they cannot help. They are correct, of course, but could at least offer some support services to help us track back through permissions and secure agent setup to help identify and fix our issues, not just brush us off.
  • Updates to the Cloud product seem to hit without too much communication or follow through. While some of this could be prevented by our internal Administrator, I do think the level of communications from Informatica to the Admin are very thin as well. New features should be broadcast when you log in, and changes should be communicated within the app, and that does not happen with Informatica Cloud.
Informatica Cloud is an excellent tool for freeing up trapped data in your internal systems and exporting it into a cloud data warehouse or SQL container. Especially if you have any internal SQL query generators that allow you to copy and paste into the Source setup. For example, we use Business Objects internally, and you can build out the query you need inside the firewall with that, then paste it into the query within Informatica Cloud while establishing the Source connection. This way you are not writing all your source parameters by hand, cutting new jobs setup time by 50%. Where Cloud will not suit you well is if you need significant visibility to the health of the system from a tracking, monitoring or error handling standpoint. Cloud will tell you it failed, maybe give you an example error, but has no further troubleshooting or diagnostic assistance to offer.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Informatica Cloud to help leverage data and reporting in our instance of Salesforce. It is used daily to import new contacts and leads to our instance of Salesforce to allow for better tracking and elimination of duplicates and other data integrity issues. We originally used native Salesforce support for importing but found that Informatica Cloud provided so much more depth and insights.
  • Data importing
  • Duplicate checking
  • Duplicate elimination
  • Data tracking
  • Data import automation
  • The UI can be somewhat difficult to get used to. This recently changed and was made somewhat better, but it is still somewhat difficult for new users to work.
  • Some of the duplicate management is hidden or hard to find initially.
  • The single Sign-on integration at first can be tricky to navigate if you aren't a Salesforce Admin.
If you are wanting to run any kind of data importing automation, Informatica Cloud is essential for your day to day business operations. We don't know of another tool that does all that Informatica Cloud can do. Manual imports with Informatica are also great because there is so much more you can do with it than native Salesforce import tools leverage. It is a great tool. It might be seen as overly complicated if you are just doing it for small, one-off manual imports, but if they are going to be at any kind of regularity, it is a great tool.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
Informatica cloud is used to connect our numerous Cloud SaaS solutions to our internal and cloud data platforms. It is used exclusively by our Technology department.
  • Informatica does a great job partnering with other Cloud solution providers, creating packaged solutions.
  • I'd like to see Informatica combine the Informatica Cloud and PowerCenter capabilities.
Informatica is a great solution for connecting SaaS-based solutions to either your cloud-based data warehouse and/or your on-premise data warehouse.
Read this authenticated review
Raviraj Raikar profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source
Informatica Cloud Data Integration Suite is used by our client for seamlessly integrating data between Infor ERP and Salesforce CRM. Salesforce CRM is used across Organization by the key users of the different business entities. Informatica Cloud Data Integration helps in asynchronous transfer of data from Infor ERP to Salesforce CRM and vice versa. Since it is a cloud based application, a physical server is not required to house the applications. It helps meet the business requirements and is very cost effective.
  • Implementation of any integrations with Informatica Cloud Data can be done easily. A consultant with base knowledge about integrations can easily implement.
  • It has inbuilt aggregate functions which can be used during mapping source table fields with target table fields.
  • Source and Target database connections can be easily configured with minimum no of steps.
  • Source data can be easily filtered through by applying conditions.
  • It doesn't quite support complex implementations.
  • It doesn't support complex SQL Queries.
  • Working towards attaching a document to a mail, needs a work around. A shell script has to be written and to be executed.
  • Configuring integration for Re-processing of failed records needs proper design of the system.
Informatica Cloud Data Integration is well suited for integration projects which involve non-complex architecture. For non-complex system integrations, Informatica Cloud Data Integrations is one of the most cost effective tools. Informatica Cloud along with MDM is widely used for integrating with Salesforce CRM. MDM helps in removing the duplicate customer information, and site/address details. For complex system architectures one would need to use Oracle Data Integrator or Informatica Power Center.
Read Raviraj Raikar's full review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
Informatica Cloud is an application integrated with TargetX SRM and Salesforce.com. It is currently used by the Office of Admission, and eventually the Office of Graduate and Professional Studies as well. Informatica Cloud is used for importing data into our CRM (TargetX) through the use of built-in data mappings.
  • Informatica Cloud is a great tool for automating data imports. Raw data files can be scheduled to run at designated times, and using pre-built mappings ensures that the data goes into the system accurately each time.
  • It is also a great tool for converting raw data into specific formatting. For example, configuring the mapping so that the first letter of a first, middle or last name is always capitalized.
  • Additionally, Informatica Cloud has a built-in field-matching tool so that records that already exist are updated rather than having duplicates created.
  • Learning the syntax for formatting the data can be difficult, and some of the functions are not as intuitive as they could be.
  • Power Centers are difficult to create on your own. A power center is a tool that converts one file type to another prior to importing the data: for example, changing a .txt. file to a .csv file.
  • Making sense of certain error reports can also be challenging. When a file errors and does not import, the system will provide a report so that errors can be fixed. These reports do not always provide straightforward reasons why the file did not import.
Informatica Cloud is a great tool for users of TargetX and Salesforce. It may work with other database systems as well.
Read this authenticated review

Informatica Cloud Scorecard Summary

Feature Scorecard Summary

Pre-built connectors (8)
8.2
Connector modification (7)
7.8
Support for real-time and batch integration (8)
8.5
Data quality services (7)
7.7
Data security features (7)
7.8
Monitoring console (8)
8.0

About Informatica Cloud

Informatica’s Intelligent Cloud Services (IICS) platform is a solution for synchronizing and integrating cloud and on-premise applications. The core of Informatica’s services is a capacity for automating data importing and formatting via prebuilt action programs and connectors. The vendor claims the set of prebuilt tools, along with a point-and-click interface, allows for “codeless advanced integration.”

IICS offers a variety of services tailored to specific use cases. These services range from onboarding B2B partners to API management, and scaling data integration, as well as the core connectors and data transformation capabilities. This service structure allows businesses to scale their use of Informatica to their specific needs.

Informatica Cloud Competitors

Informatica Cloud Technical Details

Operating Systems: Unspecified
Mobile Application:No