I recommend Maiora's - ZARUS Data Suite for your ETL requirement. With Zarus you can process your data without any codes. It is designed keeping in mind the non-tech persons using an ETL tool.
Kindly share your available time slots to discuss this further.
For those with a
greater focus on the cloud, there is the AWS Athena service, which is
also very interesting and worth studying:
https://aws.amazon.com/athena/?nc1=h_ls
Enterprise Data Architect at a manufacturing company with 201-500 employees
Real User
2023-08-22T12:03:30Z
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.
Data Strategist, Cloud Solutions Architect at BiTQ
Real User
Top 5
2023-08-22T01:20:09Z
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
What is data integration? Data integration is the process of combining data that resides in multiple sources into one unified set. This is done for analytical uses as well as for operational uses.
Hi Ornit,
I recommend Maiora's - ZARUS Data Suite for your ETL requirement. With Zarus you can process your data without any codes. It is designed keeping in mind the non-tech persons using an ETL tool.
Kindly share your available time slots to discuss this further.
Write back to vijayraj.amin@maiora.co
Regards,
Vijayraj Amin
In WSO2 Enterprise
Integrator 7 there is a very interesting and performant ETL
capability that is worth studying:
https://ei.docs.wso2.com/en/latest/streaming-integrator/guides/performing-etl-tasks/
For those with a
greater focus on the cloud, there is the AWS Athena service, which is
also very interesting and worth studying:
https://aws.amazon.com/athena/?nc1=h_ls
Qlik
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.
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
I recommend SSIS especially if you have already the license for MS SQL Enterprise edition