Mysql Connectivity in Pentaho Schema Workbench

Posted on by By Nikhilesh, in Business Intelligence, Open Source Business Intelligence, Pentaho | 0

Resolving Mysql Connectivity issue in Pentaho Schema Workbench

The issues pertaining to driver and jar files is quite common in the connectivity sector. In this blog we will concentrate on how to resolve the same with MYSQL as our selected DB. Initially when we get an error as the below screenshot shows, it simply implies that something is wrong with the JAR file which creates the connectivity between the DB and the pentaho schema workbench. Usually more often than not if the required JAR file is missing ,you’ll get an error something like the below screenshot when we try to create a connection giving all the necessary credentials required for the connection.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Grab The 30 Days Free Trail


To resolve the same download the latest JAR file for MySQL database which in our case is mysql-connector-java-5.1.18-bin. After downloading copy the JAR file to the following directory C:\Pentaho\biserver-ce\schema-workbench\drivers

Once all the above steps are completed restart the schema workbench. Try connecting now and hopefully you’ll get the connectivity issue resolved.



Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments