Data Warehouse Analyst at a insurance company with 1,001-5,000 employees
Real User
Top 5
2025-09-25T18:59:03Z
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 solutions harmonize data from different sources, ensuring smooth data flow throughout an organization. They are essential in enabling consistent data analysis, fostering better decision-making, and driving efficiency.Data Integration empowers organizations by connecting disparate data systems, reducing duplication, and enhancing data quality. This process involves combining data from various sources and providing users with a unified view. Users benefit from reduced...
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.