Data Warehouse Analyst at a insurance company with 1,001-5,000 employees
Real User
Top 10
Sep 25, 2025
We've been setting up IBM DB2 for a long time; we've joked about it since it was DB1. I cannot speak to its setup complexity; we have two data centers and entire teams, hundreds of people who set these systems up. We have failover, and everything we have is run on development, testing, and QA before it goes live. Regarding their real-time data integration, the ETL, the setup, that whole logic is done on a desktop environment and then it's uploaded to a server that runs and can schedule them. IBI has led the way for many years because they can read and write any data set. Now, as people are going more vendor-specific, aside from IBM and Microsoft, there are all these big data queries. For proprietary files such as Tableau Hyper files or SAP's data sets that are proprietary, you don't write out to those, and that's SAP's decision. Microsoft is moving off of reading there into what they call the Fabric and the Lake, so if it's published data, then it works. However, if it's their secret thing, and you don't know the secret handshake, they are working toward that. They've always had 200 or 300 different adapters, so they can read and write anything. My overall rating for ibi DataMigrator is 9 out of 10.
Data Integration facilitates the combination of data from diverse sources into a unified view, crucial for businesses to make informed decisions and enhance operational efficiency. With comprehensive solutions available, organizations can streamline their data workflows. Data Integration solutions are vital for businesses aiming to handle large volumes of data efficiently. These solutions help in synchronizing data from multiple sources, ensuring consistent data across platforms, and...
We've been setting up IBM DB2 for a long time; we've joked about it since it was DB1. I cannot speak to its setup complexity; we have two data centers and entire teams, hundreds of people who set these systems up. We have failover, and everything we have is run on development, testing, and QA before it goes live. Regarding their real-time data integration, the ETL, the setup, that whole logic is done on a desktop environment and then it's uploaded to a server that runs and can schedule them. IBI has led the way for many years because they can read and write any data set. Now, as people are going more vendor-specific, aside from IBM and Microsoft, there are all these big data queries. For proprietary files such as Tableau Hyper files or SAP's data sets that are proprietary, you don't write out to those, and that's SAP's decision. Microsoft is moving off of reading there into what they call the Fabric and the Lake, so if it's published data, then it works. However, if it's their secret thing, and you don't know the secret handshake, they are working toward that. They've always had 200 or 300 different adapters, so they can read and write anything. My overall rating for ibi DataMigrator is 9 out of 10.