IBM watsonx.data integration

Score7.6 out of 10

10 Reviews and Ratings

What is IBM watsonx.data integration?

IBM watsonx.data integration works across all integration styles, data types and storage architectures to make pipeline design and optimization durable, and data AI-ready.

Categories & Use Cases

Integration with MDM tools
Integration with master data management tools to ensure data consistency across the organization
Category average: 7.2
Complex transformations
Complex data transformations are data normalization, advanced data parsing, etc.
Category average: 7.4
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.8

Collaboration
Collaboration is enabled by a shared repository of project information and metadata
Category average: 7.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
Metadata management
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
Category average: 7.5

Pros

Robust data management and governance for structured and unstructured data
Seamless integration across diverse data sources (cloud, on-premise, APIs)
Streamlines ETL/ELT processes and data pipeline management

Cons

User interface described as slow and lagging
Complex initial setup and integration with existing dataflows
Less developer-friendly, requiring significant technical expertise

Yashkumar Patel

Clinical Data Workflow Specialist in Corporate at Cliantha Research (201-500 employees)

Use Cases and Deployment Scope

I use it for consolidating clinical trial data from multiple source systems to automate data feeding, transforming it and get standardized datasets for analytics and reports. It helps to find data quality issues, improving governance and better traceability. All the statistical workflows, reutilizing it over multiple studies which benefits us to get faster access to analysis ready data.

Pros

It integrates data from databases, cloud storages to work efficiently
It handles growing data volumes without requiring any effort for workflow updation.
It is fully traceable and has monitoring capabilities which helps track down data movement and troubleshoot issues.

Cons

Some workflows configurations can feel complex, especially when managing large projects.
more hands on examples might help new users to become more productive faster
Sometimes the performance seems laggy, especially working on bulk data.

Return on Investment

It has reduced manual effort with transformative workflows.
Governance, traceability and audit readiness has been improved.
We may need to improve performance optimization for highly bulk data volume.

Usability

Alternatives Considered

IBM Aspera on Cloud and Azure Databricks

Other Software Used

IBM Aspera on Cloud, Microsoft Excel

Verified User

Engineer in Information Technology (5001-10,000 employees)

Use Cases and Deployment Scope

IBM watsonx.data addresses the challenges of data integration across different applications varying in requirements and formats. The ability to unify data across various sources and provide orchestration to enable complex workflows is important.

Pros

Data Integration
Data Cleansing
Data Transformation

Cons

Could provide more integration with legacy dataflows
More documentation on data residency requirements

Return on Investment

Better data residency
Intuitive Data Orchestration

Usability

Alternatives Considered

Azure Databricks

Other Software Used

Azure Databricks, Azure AI Search, GitHub Copilot

Verified User

Consultant in Engineering (201-500 employees)

Use Cases and Deployment Scope

This is very productive tool for managing data pipelines, it replaced my day to day monotonous work of ETL, streamings and CDC. There are various similar use case for which this tool is really helpful and saves lot of time.

Moving and transforming large datasets have become easy for which was very tiring with the old ETL and ELT process. this tool also serves as a integration tool for me.

Pros

ETL and ELT tasks
Data governance and management
Batch and realtime processing

Cons

The overall UI experience is little lagy and slow
less developer friendly
More developer access friendly UI like dbt, airlfow

Return on Investment

Return on investment is good
Costing and efficiency
faster data integrations, availability and support

Usability

Alternatives Considered

dbt, Apache Airflow and Apache Kafka

Other Software Used

dbt, Apache Kafka, Apache Flink

Verified User

Professional in Information Technology (5001-10,000 employees)

Use Cases and Deployment Scope

I am working in a customer support organization where we help our customer with their technical problems related to the product. We use IBM watsonx.data integration to extract and unifying the customer data which includes structured and non-structured data like product logs, screenshots, documents etc. Once the data is unified, IBM watsonx.data integration helps in automating the customer response to the technical queries with high accuracy. IBM watsonx.data integration has helped in improving the response and resolution time.

Pros

Unifying and extract unstructured data for RAG
Eliminates tool sprawl by collecting all the data in one place
Need no or very less programming skills

Cons

Initial integration could be much easier. Currently its little complex to setup initially
Dashboard for monitoring and health check could be improved.
It requires a great technical expertise for using/implementing advanced ETL features.

Return on Investment

Reduced MTTR
Reduced human resources, thus reducing the cost in handling per ticket.
big savings on managing multiple integration tool

Usability

Alternatives Considered

Databricks Data Intelligence Platform, Snowflake and Google BigLake

Other Software Used

Databricks Data Intelligence Platform, Snowflake, Google BigLake

Verified User

Engineer in Engineering (501-1000 employees)

Use Cases and Deployment Scope

We use IBM watsonx.data integration to unify data from multiple sources—cloud storage, on-prem databases, and third-party APIs—into a single, governed environment for analytics and reporting. The main business problem it addresses is data fragmentation, which previously led to inconsistent metrics, delayed insights, and manual data preparation. By automating ingestion, transformation, and quality checks, the platform reduces engineering overhead and improves data reliability.

Pros

Automated data pipeline orchestration.
Data quality and governance.
Scalable integration across hybrid environments.

Cons

User interface and learning curve.
Limited flexibility in advanced transformations.

Return on Investment

Reduced manual data preparation time.
Improved forecasting and decision-making.

Usability

Informatica Cloud Data Integration

Maia by Matillion

AWS Glue

IBM watsonx.data integration

What is IBM watsonx.data integration?

Categories & Use Cases