Badges
75 Points
11 Years
User Activity
Over 9 years ago
We connect to Google Analytics, EverHour, Asana, Authority Labs, and Google Docs. EverHour does not even have an API and we managed to automate ETL from it. All this in one month. Our client is, needless to say, very satisfied.
Over 10 years ago
Contributed a review of Jira: Pros: Flexible, Open-ended, Useful default values and fields. Cons: Deep and complex, it takes a while to familiarize
Over 10 years ago
Commented on It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need
I see what you mean now
One of the ways you can use this is by specifying a user-defined function in the Modified Javascript Value step.
Pentaho uses Javascript as the scripting language.
You can define this once within a tab that is marked as Start only (executed only once…
Over 10 years ago
Commented on It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need
Do you mean something like an ORM layer that would allow your code to be database agnostic
Pentaho ETL could run custom Java code (implemented as a user-defined Step) that has access to an ORM layer.
We've done something similar when we need to access OpenERP (before the…
Over 10 years ago
Commented on It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need
We frequently call Python scripts from within Kettle. So we have the best of both worlds
Kettle's ETL scripts are no harder to maintain than source code. They are just text files that can easily be maintained within a version control system. The benefit is the visual…
Almost 11 years ago
Commented on Very capable suite of BI, reporting, and data mining tools with sophisticated functionality
Excuse me? Good for Windows but not for other operating system?
I built 3 Data Warehouses so far using Pentaho on servers running Ubuntu and Debian Linux OS and one on Windows. There is nothing that can be said about Pentaho is better for either Operating Systems.
About 11 years ago
Contributed a review of Pentaho Business Analytics: Pentaho BI Suite Review: Pentaho Reporting – Part 3 of 6
Over 11 years ago
Contributed a review of Pentaho Business Analytics: Pentaho BI Suite Review: Pentaho BI Server – Part 2 of 6
Projects
Almost 11 years ago
Application Development ProjectA new service: Automated report and dashboards for businesses that is not yet ready for a full-blown Data Warehouse
Reviews
About 11 years ago
Pentaho Business Analytics
Comments
Over 10 years ago
BI (Business Intelligence) Tools
Over 10 years ago
BI (Business Intelligence) Tools
Over 10 years ago
BI (Business Intelligence) Tools
Almost 11 years ago
BI (Business Intelligence) Tools
About me
I solve data management problems for companies in various sectors of industry: Airline Travels, Energy Bill Management, Manufacturing, Commercial Printing/Publishing, Transportation and Logistics, Health Care, and Software Development.
Specializing in building Data Warehouses, designing and implementing BI tools and processes, Change Management, OLAP database schemas, and ETL transformations, I also provide ERP solutions to businesses and organizations.
Specialties: Data Warehouse design and implementation, Business Data Management, BI System Optimization and Training, SDLC, Change Management, Team Building, ETL, Pentaho, OpenERP
Interesting Projects and Accomplishments
Almost 11 years ago