Pentaho Data Integration Data Source Failed to preview the Query

Asked By 0 points N/A Posted on -
qa-featured

Hello,

When I try to use data source of Pentaho Data Integration in Pentaho BI Suite 4.5 to have a preview of some query, an error message appears. And the message says that the query could not be previewed.

Could some expert advice what I shall do to fix this error? Any solutions are welcome. Thank you very much.

Pentaho Data Integration Data Source Failed to preview the Query.

Pentaho Data Integration Data Source

Failed to preview the Query.

SHARE
Answered By 0 points N/A #175224

Pentaho Data Integration Data Source Failed to preview the Query

qa-featured

Hi there Megan H Madison,

The problem you're facing is a well known bug caused by badly written drivers. The problem is that the original ODBC driver doesn't work well with the JDBC-ODBC bridge.

In order to make things work you will need to look for some commercial drivers that will allow you to access the database.

Drivers that are checked and are working can be found on the following link: 

http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html.

Best regards,
Drake Vivian

Login/Register to Answer

Related Questions