Try our new research platform with insights from 80,000+ expert users
2017-07-25T10:31:00Z

Ask Our Consultant Anything- Are you afraid of ODI?

RG
  • 9
Published:Jul 25, 2017
Search for a product comparison in Data Integration
PeerSpot user
3

3 Comments

RG
Consultant
Top 20
2017-07-26T14:36:48Z
Jul 26, 2017
RG
Consultant
Top 20
2017-07-26T18:04:41Z
Jul 26, 2017
Vendor
2017-07-25T14:08:42Z
Jul 25, 2017
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: November 2024.
816,636 professionals have used our research since 2012.
Related Questions
OP
Oct 18, 2024
Oct 18, 2024
IBM DataStage. Run all over the world - the only solution that can scale to meet massive data needs with its parallel processing engine.
2 out of 6 answers
Sarath Boppudi - PeerSpot reviewer
Aug 22, 2023
Hi Ornit, My preffered would be Informatica, SSIS, Wherescape. Informatica because it's a mature product that has been outfor a while with minimal development effort required. SSIS for SQL Server based solutions. Wherescape for ETL automation. Wherescape enables SQL users to write etl code in SQL using templates built into the product
DP
Aug 22, 2023
Good morning, Ornit. We are using the enterprise edition of Hitachi Vantara's Pentaho Data Integration (PDI) (it also has a community edition that is free to use but lacks some of the automation features that the enterprise edition has) for over a decade now and it will do just about anything we throw at it.  We use if not only for ETL but also to generate reports that are burst out to the business.  I've used Informatica in the past and the thing that impressed me about Pentaho was it was much easier to build transformations.  That may have improved since then (this was back in the early 2000s) but having to link each and every field between each step was super tedious.  PDI does it by name with the option to change the mapping manually if needed.  
AD
May 31, 2023
May 31, 2023
Abe,The first thing that you should understand to set expectations properly is that there is no magic bullet. As a former partner of mine wisely said, the biggest V of data is "V-Integration." =). Every single integration tool that we have reviewed or worked with has a significantly incomplete inventory of integrations, although they will never admit that. Why is this? Quite simply because in...
2 out of 5 answers
Vijayraj Amin - PeerSpot reviewer
Apr 11, 2023
Hi Abe, I would require a few more details on your requirements. However, with your current request, I would like to recommend Maiora's DO IT RIGHT (DiR) which is a lightweight ETL tool.  DiR helps you to integrate data from various sources and departments. Also, perform data quality checks, standardization checks, check for data duplication and transform data. You can extract the required results in any file format, such as Excel, SAS, JSON, and many more. DiR is a user-friendly ETL tool that does not require much technical knowledge to perform any activity. Also, it has a good user interface that can be further simplified as per your requirements and usage. Considering you are a university, this tool is efficient and very cost-effective.
reviewer2009835 - PeerSpot reviewer
Apr 17, 2023
Hi Abe,  before talking about the integration tools , i would recommend  you to prepare a source system understanding document. This to cover : i. type of source system  ( ie rdbms / nosql/api/etc) ii. nature of data that you plan to pull along with the volume iii. frequency of data pull...... these questions will form the baseline for your selection process and then you can start with your integration journey. Next step will be do feature comparison per tool . Do let me know if you need more information. Thanks
Download Free Report
Download our free Data Integration Report and find out what your peers are saying about Microsoft, Informatica, Talend, and more! Updated: November 2024.
DOWNLOAD NOW
816,636 professionals have used our research since 2012.