View Only

 Pentaho 9.4 CE mysql connection

Ame Diphoko's profile image
Ame Diphoko posted 12-02-2023 01:39

We have a CE installation of pentaho server 9.4 and we have setup a generic database connection defining custom mysql url and driver class. The connection is successful but when trying to create a data source for reporting and analysis, when we get to the "define joins" step pentaho tries to use the wrong syntax to query the mysql tables and no field keys are displayed. Is there a way to define the correct sql dialect for pentaho to use? if not, how can we resolve this?