I reviewed multiple Bi stacks while on a path to get off of Business Objects. A lot of my comments are preference. Both tool sets are excellent. Some things are how I prefer chocolate fudge brownie ice cream over plain chocolate. Pentaho has some really smart guys working with them but Microsoft has been on … Read more
Try something like: SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on FROM News WHERE CreatedDate >= DATEADD(day,-7, GETDATE())
I just came across the same issue while trying to query a MySQL Database from Pentaho. Error connecting to database [Local MySQL DB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver Expanding post by @user979331 the solution is: Download the MySQL Java Connector / Driver that is … Read more