#1 most frequent
United States of America
61.6%249 installations of 404
What is Informatica Cloud Data Integration?
Informatica Cloud Data Integration, for Cloud ETL and ELT, enables users to ingest, integrate and cleanse data within Informatica's cloud-native ETL and ELT solution. Users can link source and target data with thousands of connectors that recognize metadata, to make it easier to run complex integrations.
Categories & Use Cases
Videos
Top Performing Features
Connect to traditional data sources
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Category average: 8.9
Connecto to Big Data and NoSQL
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Category average: 7.6
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.8
Areas for Improvement
Complex transformations
Complex data transformations are data normalization, advanced data parsing, etc.
Category average: 7.4
Collaboration
Collaboration is enabled by a shared repository of project information and metadata
Category average: 7.9
Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7.2
Who Buys & Uses Informatica Cloud Data Integration
#2 most frequent
India
9.7%39 installations of 404
#3 most frequent
France
4.5%18 installations of 404
Informatica is a powerful ETL tool
Use Cases and Deployment Scope
We use Informatica Cloud Data Integration for a number of things. We use it to retrieve files from and SFTP and import records into our CRM. We use it to create reports that combine data from multiple systems that are otherwise not connected. We also use it to update records within our CRM based on criteria. Most of the processes are executed by automated jobs running on a schedule.
Pros
- Transform and format data
- Match and merge data
- Very flexible scheduling options for automated tasks
Cons
- There is a moderately steep learning curve
- Has some idiosyncrasies
- Can be finicky with date formats
Return on Investment
- Informatica allows our system administrators to perform numerous data tasks without having to engage developers.
- Scheduling functionality is a huge time saver. Email notifications alert us to any errors encountered.
- Reduces duplicate records and manual cleanup
Usability
Alternatives Considered
DemandTools
Other Software Used
FormAssembly, Salesforce Sales Cloud, TargetX, from Liaison, DemandTools
The Intelligent Cloud
Use Cases and Deployment Scope
We are transforming on premise data into cloud by using Informatica Cloud Data Integration. The primary problem was transferring data like from where to how. We made it possible by making sure all the datas are transferred using mapping which is logical aspects that have pipelines in it. Even it can be parameterized.
Pros
- Data synchronisation
- Data replication
- Data integration
Cons
- Glitches are noticed often.
- Kafka support is really low.
Most Important Features
- Data integration
- Application integration
Return on Investment
- Really greatest than any other conventional application.
Alternatives Considered
Apache Kafka and Red Hat Enterprise Linux (RHEL)
Other Software Used
Apache Kafka, Atlassian Jira Product Discovery, Red Hat Enterprise Linux (RHEL)
