Skyvia vs IDMC

Last Updated:

Our analysts compared Skyvia vs IDMC based on data from our 400+ point analysis of ETL Tools, user reviews and our own crowdsourced data from our free software selection platform.

Product Basics

Skyvia is a cloud-based data integration solution from Devart. Hosted on Azure, it has query, connect and backup capabilities. Automated workflows and a visual query wizard simplify ETL and data pipelines.

Users can set it up to accept data when a user clicks on a website or makes a selection in an application. It’s called event-based data ingestion. The vendor offers monthly subscriptions based on the volume of processed data.

  • Pros
  • Easy to use
  • Visual data pipelines
  • User-friendly interface
  • Balance of features & ease
  • Cons
  • Limited coding options
  • Fewer integrations compared to some
  • May not be ideal for complex needs
read more...
Informatica IDMC is a cloud-based ETL (Extract, Transform, Load) tool designed to simplify data integration for businesses of all sizes. It excels in user-friendliness, offering a drag-and-drop interface and visual mapping tools, making it accessible to users with limited coding experience. This ease of use positions it well for mid-sized and larger companies looking for a scalable solution to manage complex data pipelines. IDMC boasts robust data integration capabilities, seamlessly connecting to diverse sources like databases, cloud applications, and file formats. Its built-in data cleansing and validation features ensure data accuracy and reliability, crucial for data-driven decision-making. Users also appreciate its collaboration tools, facilitating teamwork and knowledge sharing among data professionals. However, IDMC's strengths come with caveats. Its cloud-native nature, while convenient, can lock users into the Informatica ecosystem, potentially hindering migration to other cloud providers. Additionally, its pricing follows a consumption-based model, making it difficult to pinpoint a fixed cost. While potentially cost-effective for high-volume users, smaller organizations might find the upfront IPU purchase and ongoing consumption fees prohibitive. Ultimately, IDMC's user-friendliness, comprehensive data integration, and collaboration tools make it a compelling choice for mid-sized and larger businesses seeking a cloud-based ETL solution. However, its pricing model and potential vendor lock-in require careful consideration before adoption.

Pros
  • User-friendly interface
  • Handles complex ETL tasks
  • Robust data integration
  • Scalable for large datasets
  • Strong support community
Cons
  • Can be expensive
  • Steep learning curve
  • Limited customization
  • Occasional performance issues
  • Vendor lock-in concerns
read more...
$7 Monthly
Get a free price quote
Tailored to your specific needs
$1,000 Monthly
Get a free price quote
Tailored to your specific needs
Small 
i
Medium 
i
Large 
i
Small 
i
Medium 
i
Large 
i
Windows
Mac
Linux
Android
Chromebook
Windows
Mac
Linux
Android
Chromebook
Cloud
On-Premise
Mobile
Cloud
On-Premise
Mobile
GE
Globaldata
Hyundai
Medecins Sans Frontieres
Telenor
we're gathering data

Product Assistance

Documentation
In Person
Live Online
Videos
Webinars
Documentation
In Person
Live Online
Videos
Webinars
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support

Product Insights

  • Stay Competitive: Get excellent performance with high fault tolerance, thanks to the Azure cloud. It can scale by adding resources and can manage workloads efficiently.
  • Improve Decision-Making: Make informed decisions with accurate data, thanks to automatic updates, scheduled refreshes and incremental loading. Export reports to CSV files and FTP/SFTP servers.
  • Gain Timely Insights: Get accurate data from a single source of truth — a unified data store. Trust automated workflows to deliver data on time. Uncover new information with filters, joins, and string and date-time functions.
  • Act: Hit the ground running with pipeline templates or build new ones with the data flow designer. A visual query builder makes data access easy, while a code editor serves developers who want more control.
  • Secure Data: Encrypt data at rest and in motion and prepare record-wise logs for easy troubleshooting. GDPR, HIPAA and SOC compliance and access controls (MFA, SSO, RBAC) ensure that only authorized users see the necessary information.
  • Stay Connected to Data: Access from anywhere with an internet connection. It’s software-as-a-service, so it avoids the expense of on-premise infrastructure and software installation.
read more...
  • Unified Data Platform: Consolidate data from diverse sources into a single, accessible repository.
  • Streamlined Workflows: Automate data extraction, transformation, and loading processes for improved efficiency.
  • Enhanced Data Quality: Ensure data accuracy and consistency through validation and cleansing routines.
  • Flexible Data Manipulation: Apply a wide range of transformations to prepare data for analysis.
  • Visual Mapping Tools: Design and implement data flows with intuitive drag-and-drop interface.
  • Scalable Processing Power: Handle large datasets efficiently with parallel processing capabilities.
  • Empowered Business Users: Provide self-service data access and analysis tools for informed decision-making.
  • Advanced Reporting & Visualization: Generate insightful reports and dashboards to communicate data effectively.
  • Improved Collaboration: Foster data-driven collaboration across departments and teams.
read more...
  • Event-Based Data Ingestion: Pull data from several sources using Skyvia Automation. Set up ingestion tasks to trigger per a schedule or after an event happens.
  • Bulk Loading: Loads large volumes or full data dumps from a source into a database. The vendor provides a Use Bulk Import checkbox with every connection popup.
  • Bidirectional Updates: Tracks the latest modifications with change data capture (CDC). It keeps data updated in both directions—from the source to the target and from the target to the source.
  • Functions: Convert data to a usable format with string and mathematical functions. The vendor provides date-time, lookup, join and filter functions. Map a single table to several related tables and create new values as desired.
  • Audit Trails: Stores logs of successfully loaded records for specific integrations and connections. It also retains records of failed integration attempts.
  • Data Encryption: Use AES 256-bit encryption to hide sensitive data at rest and when it's on the move. Additionally, the TLS protocol secures the data end-to-end.
  • Role-Based Access Control: Set up role-based users — admin, developer, member and supporter — at the workspace level. Administrators can create custom roles if they want.
read more...
  • Visual Data Mapping: Drag-and-drop interface for intuitive design of data flows.
  • Codeless Transformations: Apply data transformations without extensive coding knowledge.
  • Cloud-Native Architecture: Scalable and flexible deployment on major cloud platforms.
  • AI-Powered Data Integration: Automated pattern discovery and data lineage tracking.
  • Hybrid Data Integration: Connect to both on-premises and cloud-based data sources.
  • Data Quality Management: Built-in tools for data profiling, cleansing, and validation.
  • Metadata Management: Comprehensive catalog of data assets for better visibility and governance.
  • Data Security & Compliance: Role-based access control, encryption, and audit trails.
  • Real-Time Data Integration: Capture and process streaming data for instant insights.
  • Self-Service Data Access: Empower business users with data exploration and analysis tools.
  • Collaboration & Integration: Seamless integration with other Informatica products and third-party tools.
read more...

Product Ranking

#33

among all
ETL Tools

#37

among all
ETL Tools

Find out who the leaders are

Analyst Rating Summary

63
98
84
100
27
100
65
98
Show More Show More
Platform Security
Data Delivery
Data Quality
Metadata Management
Performance and Scalability
Platform Capabilities

Analyst Ratings for Functional Requirements Customize This Data Customize This Data

Skyvia
IDMC
+ Add Product + Add Product
Data Delivery Data Quality Data Sources And Targets Connectivity Data Transformation Metadata Management Platform Capabilities Workflow Management 84 27 65 68 16 79 71 100 100 98 96 100 100 96 0 25 50 75 100
80%
0%
20%
100%
0%
0%
23%
8%
69%
100%
0%
0%
64%
4%
32%
100%
0%
0%
71%
0%
29%
96%
0%
4%
10%
10%
80%
100%
0%
0%
86%
0%
14%
100%
0%
0%
70%
0%
30%
90%
0%
10%

Analyst Ratings for Technical Requirements Customize This Data Customize This Data

83%
0%
17%
100%
0%
0%
91%
0%
9%
100%
0%
0%

User Sentiment Summary

Excellent User Sentiment 430 reviews
Great User Sentiment 596 reviews
96%
of users recommend this product

Skyvia has a 'excellent' User Satisfaction Rating of 96% when considering 430 user reviews from 5 recognized software review sites.

84%
of users recommend this product

IDMC has a 'great' User Satisfaction Rating of 84% when considering 596 user reviews from 2 recognized software review sites.

4.8 (14)
n/a
4.8 (220)
4.2 (282)
4.8 (67)
n/a
4.8 (104)
4.2 (314)
4.8 (25)
n/a

Awards

Skyvia stands above the rest by achieving an ‘Excellent’ rating as a User Favorite.

User Favorite Award

SelectHub research analysts have evaluated IDMC and concluded it deserves the award for the Best Overall ETL Tools available today and earns best-in-class honors for Data Sources and Targets Connectivity.

Analysts' Pick Award
Data Sources and Targets Connectivity Award

Synopsis of User Ratings and Reviews

Easy to Use: Many users praised its functionality for moving data from source to target systems and building pipelines independently.
Improved Data Integration: Users said readymade connections make it easy to pull data from cloud applications and databases.
Automated Data Workflows: Users appreciated the freedom to set up pipelines to run later. It frees them up to focus on high-level tasks.
Enhanced Data Accessibility: Users who reviewed data access said common storage gives everyone the same data to work with and avoids misdirected decisions.
Show more
User-friendly interface: Intuitive drag-and-drop interface simplifies development and reduces reliance on coding expertise.
Cloud-native architecture: Streamlines deployment, eliminates infrastructure management, and offers automatic updates.
Comprehensive integration capabilities: Connects to a vast array of sources and targets, encompassing databases, cloud applications, and file formats.
Scalable performance: Handles large data volumes efficiently, ensuring timely data delivery for critical business processes.
Robust data quality features: Cleanses and validates data for accuracy, fostering reliable insights and decision-making.
Collaboration features: Enables teamwork and knowledge sharing among developers, enhancing productivity and efficiency.
Show more
Limited Coding Options for Complex Transformations: While Skyvia boasts a friendly interface, complex data manipulations require coding knowledge. If teams don't know how to code, it can block them from performing deep analysis or building pipelines.
Fewer Integrations Compared to Some Competitors: It offers over 180 connectors, but if users need to connect to other sources, they might need workarounds.
May Not Be Ideal for Highly Scalable or Complex Needs: It works best with moderate data volumes, but users might need something more for large datasets and complex needs.
Show more
Learning curve: While user-friendly, mastering its full capabilities can require a learning investment, especially for those new to ETL tools.
Cost: Can be relatively expensive compared to some alternatives, potentially limiting adoption for smaller organizations or those with tight budgets.
Limited customization: Certain features and integrations might offer less flexibility for tailored solutions compared to more open-source alternatives.
Technical support: Users have occasionally reported mixed experiences with the quality and responsiveness of technical support.
Cloud vendor lock-in: Being a cloud-native platform, migrating to a different cloud provider can involve challenges and potential data transfer costs.
Show more

Skyvia stands out for its user-friendly interface. With drag-and-drop features, anyone can connect to data sources and build pipelines, which is a big plus compared to some trickier tools that require coding.But there's a catch — the vendor keeps things simple, so it might not be the best for super complex data transformations. It has connectors for many popular apps, but some users felt the vendor should offer more options.It could be a problem for businesses that need to connect to specific data sources or want advanced functionality. Reviews also said it works great for medium data volumes.Its automatic workflows streamline data transfer and analysis while freeing workers for high-level tasks.Overall, Skyvia is a good fit for businesses that want an easy-to-use tool to integrate their data, automate tasks and gain insights without needing IT help.

Show more

User reviews of Informatica IDMC in the past year paint a picture of a powerful ETL tool with strengths in user-friendliness, cloud-native architecture, and comprehensive data integration. Its intuitive interface and drag-and-drop features make it accessible even for those with limited coding experience, a major advantage over more complex competitors like Talend Open Studio. However, its cloud-based nature can be a double-edged sword: while it offers scalability and automatic updates, it also locks users into Informatica's infrastructure, potentially hindering migration to other cloud providers. The robust data quality features of IDMC are another highlight, cited as crucial for ensuring reliable data-driven decisions. Compared to competitors like Pentaho Data Integration, IDMC's built-in cleansing and validation capabilities are seen as a significant advantage, saving time and effort. However, some users have expressed concerns about the learning curve associated with mastering IDMC's full potential, especially compared to more lightweight alternatives like Fivetran. While cost is a common concern with any enterprise software, IDMC's price tag can be particularly prohibitive for smaller companies or those on tight budgets. Users often compare it to open-source options like Apache Airflow, which offer similar functionality at a fraction of the cost. However, the lack of built-in features and steeper learning curve of open-source options can negate the cost savings for some organizations. Ultimately, user reviews suggest that IDMC is a valuable ETL tool for organizations seeking a user-friendly, cloud-based solution with robust data integration and quality features. However, its pricing and potential vendor lock-in are important considerations. Weighing these strengths and weaknesses against the needs and budget of your organization will determine whether IDMC is the right ETL fit for you.

Show more

Screenshots

Top Alternatives in ETL Tools


AWS Glue

Azure Data Factory

Cloud Data Fusion

Dataflow

DataStage

Fivetran

Hevo

IDMC

Informatica PowerCenter

InfoSphere Information Server

Integrate.io

Oracle Data Integrator

Pentaho

Qlik Talend Data Integration

SAP Data Services

SAS Data Management

SQL Server

SQL Server Integration Services

Talend

TIBCO Cloud Integration

WE DISTILL IT INTO REAL REQUIREMENTS, COMPARISON REPORTS, PRICE GUIDES and more...

Compare products
Comparison Report
Just drag this link to the bookmark bar.
?
Table settings