Data Integration Tools Forum

Rhea Rapps
Content Specialist
IT Central Station
Aug 22 2018
One of the most popular comparisons on IT Central Station is Oracle GoldenGate vs Quest SharePlex. One user says about Oracle GoldenGate, "It's very simple to configure and implement. In addition, it can capture data and transmit it with incredible speed, which is better than any other product out there. It's extremely powerful."Another user says about Quest SharePlex, "Performance is crucial, and SharePlex is by far the fastest. The way it handles replication to multiple targets along with basic filtering, as well as from multiple sources to a single target, is very efficient."In your opinion, which is better and why?
M Almasii think it depends on what you want from technology. i prefer, Oracle GoldenGate because of its incredible speed for data ingestion or data transmit. in other words, ETL tasks and real time tasks are performed in an efficient manner by Oracle GoldenGate. however, whenever i deal with BI or analytic tasks, i prefer Quest SharePlex.
Stephen BirdI would recommend StreamSets, it is OpenSource, far more cost effective, extremely easy to use and when our client tested it against Oracle, StreamSets out performed Oracle.....
Rhea Rapps
Content Specialist
IT Central Station
Jul 20 2018
One of the most popular comparisons on IT Central Station is Oracle Data Integrator (ODI) vs SSIS. One user says about Oracle Data Integrator (ODI), "It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."Another user says about SSIS, "In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc." In your experience, which is better and why?
Hien DoanI believe SSIS is only working with Microsoft SQL server but it's free. Anyway, the best ETL tools on the market are Informatica and Oracle ODI. The distinction about these two products are: For Informatica: It's been there for a long time. However it is architect as Extract, Transform, and Load. You need separate server for the tool. For Oracle: It is Extract, Load, and Transform -> You can run everything on the database servers. This setup is more current (same as Hadoop).
Ariel Lindenfeld
Sr. Director of Community
IT Central Station
Jun 12 2018
Let the community know what you think. Share your opinions now!
it_user219864Data Quality, Data governance, Data profiling, and advanced ETL functions embedded, multiples and native connectivity with structured and unstructured data.
it_user229764Less code more productivity
Birsen Tunç YazarData profiling, easy to use, connectivity capabilities to different kind of sources (unstructured data, flat files, common rdms, soap and json ) advanced data transform capabilties
Rhea Rapps
Content Specialist
IT Central Station
May 07 2018
One of the most popular comparisons on IT Central Station is Informatica PowerCenter vs SSIS. In your opinion, which is better and why? Thanks! --Rhea
etlsolut192060Hands down Informatica. I've used both. Informatica is system and DB agnostic and can run on any platform. If set up correctly like I do in my architecture moving from the platform (Windows) to Linux or AIX would take less than a day. Also, Informatica is highly parameterizable and easier to develop in. The shared objects ability is a huge time-saving advantage. Also, Informatica has built-in version controls.
Mark BennettInformatica is the more capable tool on paper whilst SSIS is more widely used, less expensive and there is an abundance of expertise available. However, it all comes down to which tool better aligns to a customer's requirements.
Michael LuryeLike any other technology there is no universal answer to which tool is better, it all depends on your requirements, budget, skill set and other considerations. Having said that if your DW/BI environment is based on the SQL Server stack I would go with SSIS unless there is a good reason to bring in another ETL tool.
Christiana Steves
Business Analyst at
I have a compoents input record format with a field set to NULL, like, record string(3) INPUT = NULL; end; Comp A -----FlowAtoB---------> Comp B The above record format is the FlowAtoB. I can understand that this sets the value of INPUT to null. But, In case I have value for this from previous component A, how will this behave?<a href=>Ab Initio</a> I'm not able to clearly understand the use of this from the help document.

Sign Up with Email