Informatica Cloud Connectors Reviews & Product Details

Informatica Cloud Connectors Overview

What is Informatica Cloud Connectors?

Informatica Cloud Connectivity. Rapidly Integrate Cloud and On-Premise Applications, Databases and Files. Informatica Cloud can connect to on-premises and cloud-based applications, databases, flat files, file feeds, and even social networking sites. And the Informatica Cloud Platform makes just about any type of data integration as a custom cloud service or plug-in possible. Whether it's already prebuilt and ready to go or you'd like to find out if a particular application or database is supported, be sure to visit the Informatica Marketplace to check out our library of Informatica Cloud connectivity and templates. Informatica Cloud Connectors deliver connectivity to an enterprise application or database. Connectors exist for many system including ACORD, Google BigQuery, Goldmine, JD Edwards, MS Access, MS Dynamics, MS Great Plains, MS Navision, Netsuite, Oracle EBS, Salesforce, SQL Database, and SWIFT Transformation.

Informatica Cloud Connectors Details
Product Description

Informatica Cloud Connectivity. Rapidly Integrate Cloud and On-Premise Applications, Databases and Files.


Seller Details
Seller
Informatica
Company Website
Phone
650-385-5000
Year Founded
1993
HQ Location
Redwood City, CA
Total Revenue (USD mm)
$1,047
Twitter
@Informatica
109,693 Twitter followers
LinkedIn® Page
www.linkedin.com
4,878 employees on LinkedIn®
Description

Organizations around the world rely on Informatica to realize their information potential and drive top business imperatives. Worldwide, over 5,000 enterprises depend on Informatica to fully leverage their information assets from devices to mobile to social to big data residing on-premise, in the Cloud and across social networks.

Show More

Informatica Cloud Connectors Screenshots

Informatica Cloud Connectors Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 40 Informatica reviews
Popular Mentions
Showing 40 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Region
Already have Informatica Cloud Connectors?
Write a Review
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Very easy to use.

connectors are provided to connect with the variety of data sources.

No need to write and maintain complex codes.

UI is so best we can do data mapping through UI

easy to implement

supports all the file format

replicate large data set on the cloud

Security in data transition.

use proxies for data transfer Review collected by and hosted on G2.com.

What do you dislike?

Informatica takes more time when you transfer a large file.

Prices are high for a small company.

No GDPR and Governance feature. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We have to migrate data from a variety of sources like Azure, Aws, google cloud, salesforce, etc. We have created Data warehouse that data is being used for analytical purpose. Review collected by and hosted on G2.com.

Show More
Show Less
Senior software Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Infromatica cloud has great features which made us easy to push the data from legacy system (AS400) to our newly built system.It has a great user interface and a variety of connectors to integrate data between different systems. Review collected by and hosted on G2.com.

What do you dislike?

Of course all the connectors are not free. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Informatica cloud best tool to build ETL solutions,It really helps us to transform the data from different sources and sync to our Datawarehouse. Review collected by and hosted on G2.com.

Show More
Show Less
II
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Informatica helps us alot with respect to collecting data from different sources we have loge different digital assets and strong into single place and creating dashboards on it. It's really best thing available in market Review collected by and hosted on G2.com.

What do you dislike?

There's nothing such that I would say that I dislike in Informatica but yes Few recommendations can be added to make it better in future for example creating provision to do real time data analysis and also applying frw Machine learning algorithms or connectivity Witt Python language Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We use Informatica for mutilple purpose in our organization.. Right from creating reports to creating ETL... It's really helpful to get data from various resources and dump it at specified server which may feel like it sources data.. It's really helpful to work on Informatica Review collected by and hosted on G2.com.

Show More
Show Less
Lead Consultant
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Real time tracking of web service callouts and the response from the target system is very helpful to track and monitor Review collected by and hosted on G2.com.

What do you dislike?

The fact that I will have to monitor the flows between SFDC to IOD (Request / Response) and IOD to Siebel (Request / Response) separate from each other doesn't provide the end to end perspective. Though I can make it up by linking those two using the record IDs in Informatica. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Informatica is a very big player in the middleware products and offer a suite of applications to meet your integration requirements. However it is important to understand the limitations especially with respect to the callout time out based on the source and the target systems that you are integrating Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Integrating Salesforce with Siebel ERP to facilitate the flow of CRM data such as Account, Contact other such data . Siebel ERP takes care of the ordering and other back office functions Review collected by and hosted on G2.com.

Show More
Show Less
Technical Team Lead/Consultant
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Informatica Cloud gives lot of flexibility to have one stop tool for data integrations with cloud CRM platforms like Salesforce where the data can be replicated and loaded into target database with batch jobs without any manual intervention. Developing cloud mappings, tasks and scheduling the tasks through task flows are much easier than said. great cloud integration tool indeed. Review collected by and hosted on G2.com.

What do you dislike?

There is no specific thing which I dislike about informatica cloud. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Integrating and replication cloud CRM data which is entered daily by business users and tranforming that data and loading for business reports. Review collected by and hosted on G2.com.

Show More
Show Less
CM
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Easiness to use the tool. The transformations are similar to Powercenter Transformations Review collected by and hosted on G2.com.

What do you dislike?

Number of transformations available in the cloud are limited Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Informatica Cloud can be used particularly when reading/writing from other cloud applications. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

An easy way to connect to other cloud applications. No Software updates required and no additional hardware required Review collected by and hosted on G2.com.

Show More
Show Less
Salesforce Software Engineer
Higher Education
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Is a nice interface for scheduled integration jobs Review collected by and hosted on G2.com.

What do you dislike?

Would like a more user friendly look for error logging Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Passing data from source to associated dbs Review collected by and hosted on G2.com.

Show More
Show Less
AC
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

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. Very easy learning curve with a point and click interface. Regular business analysts who are not very technical can setup jobs as needed. Review collected by and hosted on G2.com.

What do you dislike?

No real ability to report on what jobs you have setup 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. Don't understand why they don't just make that available as another endpoint. Incremental jobs can run VERY slowly on large table updates. Incremental does not work at ALL for salesforce.com history tables. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Is very good for high volume, low-complexity. Replication is really their sweet spot, especially if working with cloud systems like salesforce.com. Of the ETL, they are good at E and L. There is limited transform capabilities, but if you are really looking to do major tranformation in transit, look at something more complicated like Talend or even Informatica PowerCenter. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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 (equivalent of batch jobs in SF or stored procedures in SQL) on a schedule without consuming those resources on the target or source systems. Review collected by and hosted on G2.com.

Show More
Show Less
UB
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Informatica Cloud ETL , Real time Guides and Real time process builder hosted in Informatica cloud Review collected by and hosted on G2.com.

What do you dislike?

Some time P3 tickets take a longer time to resolve Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Faster data load, more reliability and robust tracking of the jobs Review collected by and hosted on G2.com.

Show More
Show Less
AC
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Performance and new features . This tool is simple to use, efficient, flexible and also had the data security which is the best product that needs to helps customers Review collected by and hosted on G2.com.

What do you dislike?

Connecting, applications and process with onsite systems yo the cloud system Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Etl business. Speed in processing the data Review collected by and hosted on G2.com.

Show More
Show Less
CR
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

It has a really good user interface, hence easy to use for most of my ETL work.

Informatica provides a good customer support in case of any issues.

In case some one wants to learn this tool lot tutorial and videos available online. Some of which is provide is Informatica organization itself.

Due to its cloud based platform, it has an efficient backup system. Review collected by and hosted on G2.com.

What do you dislike?

There is a scope of improvement in user security Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Informatica cloud fully automats the salesforce system Review collected by and hosted on G2.com.

Show More
Show Less
EI
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

Improving their ETL functionality is what I'm most interested in Review collected by and hosted on G2.com.

What do you dislike?

at the mercy of their upgrades is what I dislike Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data Warehousing. Review collected by and hosted on G2.com.

Show More
Show Less
Sr. Technical Architect / Account Manager
Information Technology and Services
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

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 Cloud Review collected by and hosted on G2.com.

What do you dislike?

The wizard, although easy to grasp, is very buggy. Many, many times we've lost work because of a bad page refresh or we click a certain sequence of options the UI didn't like. Very Frustrating.

One can save jobs within an environment but you can't backup your jobs locally, for example download the XML to duplicate or copy jobs around. And the feature to migrate jobs from one environment to another is unreliable and, when successful, only copies portions of the config. Almost always easier to rebuild from scratch. This makes moving from DEV to TEST to PROD difficult and, more important, undermines the QA process.

User community is not as active as one would expect with such a large customer base.

No one I have had experience with uses IOD by itself but always has a team leveraging PowerCenter to do complex work. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Informatica was recently purchased by a private equity firm. The jury is still out as to what impact this will have although it usually does not bode well. If you want to use what everyone else is using, this is your product. If you're looking for a flexible ETL suite, continue your search. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

we have driven some fairly complex ETL solutions using only Cloud Review collected by and hosted on G2.com.

Show More
Show Less
Director of Int. Software Development
Computer Software
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

One of the best Integration tools in the IPAAS space. I was happy to Implement this for Infusionsoft and resolve our point to point integration issues and streamline our business process orchestrations. Review collected by and hosted on G2.com.

What do you dislike?

Informatica lags behind Mulesoft in some areas and API management and discovery is one of them. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

none Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

One of the business problems I am trying to solve and lead for our company is reduce point to point integrations, creating single source of truth for data and provide services via creating and Enterprise Service Bus, benefitting the complete organization. Review collected by and hosted on G2.com.

Show More
Show Less
Director of Ecommerce Development
Retail
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

ease of use, we were able to implement several interfaces without the need of a trained developer Review collected by and hosted on G2.com.

What do you dislike?

the upgrades are done on saturday evenings, as a retailer this is the worse time possible Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

interfaces Review collected by and hosted on G2.com.

Show More
Show Less
Co-Founder & CEO
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Ease of use, it is easily scalable and robust in the performance. You can connect to any other systems like SAP, Oracle ERP, MS Dynamics, Sage, ServiceNow, and Workday etc. It has hundreds of connectors. It's enterprise version is really a great upgrade if you want to scale up to your enterprise wide businesses. Review collected by and hosted on G2.com.

What do you dislike?

Perhaps Informatica Cloud can develop a desktop tool to build mappings etc and a connector that can work with the development platform. Also building any customer connector could be challenging if you don't have much experience with the platform. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

make sure you have the right connectors you are buying and also make sure you have the right environment to install Informatica Cloud Agent Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

have a 360 degree view of customers Review collected by and hosted on G2.com.

Show More
Show Less
AF
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

The ease of use and documentation provided with this tool. Review collected by and hosted on G2.com.

What do you dislike?

Cost of product overall compared to return on investment thus far. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Integrating with another salesforce org Review collected by and hosted on G2.com.

Show More
Show Less
Chief Technology Officer
Information Technology and Services
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

Data replication and sync with salesforce and on premise data.

If you are like many organizations that struggle with integrating with data created in salesforce then Informatica Cloud is a must for you. One of the challenges with integrating is that salesforce is changing all the time, and many of those changes are to objects (tables) that you are trying to integrate with. Informatica Cloud’s ability to dynamically replicate not only the data but the changes to the data schema. Review collected by and hosted on G2.com.

What do you dislike?

Lack of AD security integration for user and data connectors. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you are a salesforce client, Informatica Cloud will make your life easier. Although Informatica Cloud is evolving, I would caution anyone considering Informatica Cloud as their main ETL tool. I have used Informatica Cloud successfully with both PowerCenter and Microsoft SSIS. Informatica Cloud’s integration with salesforce makes this a must have tool if only for that purpose, however it does much more. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data integration with salesforce used to tie up a full resource and always suffered from missing data due the regular changes in salesforce to meet business needs. Today using Informatica Cloud our salesforce integration is fully automated and dynamically in sync with the changes made in salesforce. What used to be one of the most problematic and time consuming process is now one of the most dependable and automated.

We have had so much success with replicating data from salesforce, we are just starting a project that will automate the replication of all of our development, testing and training salesforce sandboxes. Review collected by and hosted on G2.com.

Show More
Show Less
ETL Consultant
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Informatica cloud is very user friendly and ease of development for complex cloud based integration solutions. All data integration cloud services(i.e Data Sync, Data Replica, Migration) are designed to provide powerful integration solutions.

Inbuilt connectors for almost all of the cloud services.

Cheaper than other tools like Cast Iron and Relational Junction. Review collected by and hosted on G2.com.

What do you dislike?

Nothing much but My understanding is IC would be a great tool if it could have flexibility for transforming the data like Dell Boomi, which has lot of inbuilt functions for data transformation and it also provides Groovy and Javascript for further manipluation. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

I would definitely recommend it to other because of ease of use and powerful cloud integration solutions. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Real time Integration with On-premise database

Data Replication.

Data Sync. with salesforce.com and on-premise database Review collected by and hosted on G2.com.

Show More
Show Less
AF
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

Informatica is a complex solution that is reliable and worry free. We have multiple systems that require accurate and reliable transfer of data on a daily basis. This information is vital to business, and Informatica took the time to understand our business and design a solution that works. I plan to use informatica for future solutions. Review collected by and hosted on G2.com.

What do you dislike?

I currently don't have a dislike for this product. The service is excellent as well. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Evaluate the options, but Informatica will not disappoint. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We have been able to connect our backend software platforms seamlessly. I believe Informatica will provide a solution that will allow us to take Salesforce data and other software data and put it into the Analytics Cloud. I am excited to explore this solution. Review collected by and hosted on G2.com.

Show More
Show Less
Lead Business Analyst
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

The ease of implementation. A consultant with basic know how to can integrate legacy systems with multiple applications. We used Informatica Cloud platform with SQL Server as underlying staging layer to integrate ERP System (multi version) housed on Oracle DB with Salesforce CRM (SQL Server) for over 15 Clients Entities. The seamless way in which we could implement it was very appreciable. It's cost effective compared with other effective tools. Review collected by and hosted on G2.com.

What do you dislike?

As compared with the legacy ETL Tools, there are quite a limitations in the functionalities that we can achieve with this cloud based application. The performances of the Tasks which pushes data to the salesforce CRM takes a beating when high volumes of data are involved. We faced issues related to the batch size of the tasks. Reducing the batch size seriously deteriorates the performance of the tasks execution time, increasing the batch size gave too many sql queries issues while load, so had to play around with the batch size to optimize the performance and yet do away with the errors. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Please consider the following pointers for opting for Informatica Cloud

1) Complexity of Integration's

2) Cost Factors of Licensing

3) Cost Factors of Implementation

4) Data Volume

5) Real Time Integration's

6) Parallel Processing Requirement

7) Error Handling Requirement Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The business required integration's of Customer related information of the legacy system with the Salesforce CRM System. It wanted to cover all the EMEA entities where it had it's business. It didn't want to invest heavy in to this system as they were not too sure on the benefits that they could reap out of the implementation. So they opted for a fail safe approach, which is cost effective yet the ultimate objective of the implementation is'nt defeated. Informatica cloud is what the business opted for after the initial beta analysis. The business was content and happy with the end result, as it helped them to mitigate the costs and achieve the integration's seamlessly with lesser implementations cost. Review collected by and hosted on G2.com.

Show More
Show Less
Solutions Architect
Information Technology and Services
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

The Informatica Cloud is a true enterprise cloud integration suite. Its thin client mapping application provides functionality for your most experienced PowerCenter user as well as Wizard-driven screens for your non-technical business user. The REST API allows for tight integration with corporate portals and/or mobile devices. Review collected by and hosted on G2.com.

What do you dislike?

I'd like to see more of the advanced features of PowerCenter included in the thin client tool (Rank, Union, Java Transformation, etc.). However, these are not the main transformation blocks utilized in a mapping. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

I would highly recommend Informatica Cloud to any size business. It provides a highly flexible development model as well as cost model. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

On-Premise -> Cloud Integration (Database<->Salesforce.com)

Cloud -> Cloud Integration (Salesforce.com <-> Salesforce.com/Google) Review collected by and hosted on G2.com.

Show More
Show Less
Salesforce Lead Consultant
Telecommunications
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

Powerful integrations at the click on a button, went from 0 to 100 jobs in the first month.

Now running close to 300 jobs per week, never let us down. Review collected by and hosted on G2.com.

What do you dislike?

UI can be slow at times, inability to open tabbed view is disappointing Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Dont underestimate you connection requirements. You will always need more than you thing Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Archiving data, deleting historic, data cleanse.

Significantly reduced development timescales and cost Review collected by and hosted on G2.com.

Show More
Show Less
Project Lead Data Warehousing
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Salesforce integration it provides is the best part of it.

Also the custom mappings which are available Review collected by and hosted on G2.com.

What do you dislike?

Scheduling and unix interactions are not extensive.

Also in comparison to Powercenter it doesn't have File Watcher, Event Wait or Command Task which could have been helpfull Review collected by and hosted on G2.com.

Recommendations to others considering the product:

The Scheduling options need to be increased Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are planning to have a CRM solution with Salesforce.

We have some traditional Data Feeds available.

Informatica Cloud helps us to push the data into Salesforce.

The Upsert functionality is a blessing as its helpful o handle CDC . Review collected by and hosted on G2.com.

Show More
Show Less
Data Migration Specialist
Information Technology and Services
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Have used Informatica Cloud extensively for data migration from Global org to Domestic org (Salesforce) with ease...Love the application for its easy set up and use options. Was very helpful to automate data integration process from different source(flat files) to Salesforce. The best and cheap way to migrate/integrate data accurately with no experience on the tool. With the Informatica Cloud, companies can unify Salesforce data with the rest of your enterprise and ensure data accuracy, improve business decisions and operations, and derive maximum value from your CRM and force.com investment Review collected by and hosted on G2.com.

What do you dislike?

Not face any issues so far but compared to Informatica Powercenter there are some limitations to data filters and its functionalities. The process took little bit more time when compared DMAMPS and Data loader when dealing with large volume of the data. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data migration from Salesforce to Salesforce is easier compared to any other tool and Integration made simple using Informatica cloud from any source. Review collected by and hosted on G2.com.

Show More
Show Less
Do you work for Informatica?

Informatica Categories on G2