I work as a research assistant for a university.
I am currently researching SSIS and Pentaho. What is the biggest difference between the two? Which would you recommend?
Thanks! I appreciate the help.
Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection :
1) License cost
2) Type of data to be handled and integration with source database
3) Are we looking for cloud implementation or on-premises
4) Volume of data that we are looking at with possible transformations
5) Data Quality framework
7) Customer experience ie support.
I am from MS background and have worked both on cloud version and on-premises version. I was able to achieve my solution using MS.
MS SQL Server Integration Services (SSIS) is a part of the commercial MS SQL Server product.
It is not a freeware. Probably Pentaho offers an open source/ freeware edition.
Below may be useful:
Nowadays SSDT (SQL server data tools) is also getting popularity:
Hello, I'm working at a company with more than 5000 employees.
We have multiple sets of dashboards and we're looking to migrate them from TIBCO Spotfire to Microsoft Power BI. I'm trying to make a case study before kick-starting the work.
What challenges should I expect while migrating the dashboards from TIBCO Spotfire to Microsoft Power BI? Are you aware of any tool (or a set of tools) that could help?
Otherwise, if this migration is done manually, what functionality will potentially be missing in Microsoft Power BI after this migration?
Thanks and I appreciate your help!
Which BI tools are the best out of the box for basic calculations that all SaaS businesses need to track to survive?
Are some tools better for startups vs enterprise?