Top 8 Data Integration Tools
Informatica PowerCenterSSISAzure Data FactoryTalend Open StudioIBM InfoSphere DataStageOracle Data Integrator (ODI)SAP Data ServicesOracle GoldenGate
Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.
The product provides good data handling.
The interface is very user-friendly.
I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot.
I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields. It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.
As a data integration platform, it is easy to use. It is quite robust and useful for volumetric analysis when you have huge volumes of data. We have tested it for up to ten million rows, and it is robust enough to process ten million rows internally with its parallel processing. Its error logging mechanism is far simpler and easier to understand than other data integration tools. The newer version of InfoSphere has the data catalog and IDC lineage. They are helpful in the easy traceability of columns and tables.
The scalability is great. It's one of the reasons we chose the solution.
All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.
The most valuable feature is the ETL functionality.
Its integration capabilities and the data migration capabilities are the most valuable. It is very good for SAP and non-SAP tools. It has very good integration with SAP, but it also has the capabilities to connect to other systems. We find it very helpful and stable.
It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality.
Advice From The CommunityRead answers to top Data Integration Tools questions. 502,335 professionals have gotten help from our community of experts.
See more Data Integration Tools questions »
Ariel LindenfeldDirector of Content at IT Central Station
Question: When evaluating Data Integration, what aspect do you think is the most important to look for?
Let the community know what you think. Share your opinions now!