---
title: Pentaho configuration for MySQL
description: Pentaho configuration for MySQL
---

[![e-Zest logo\_An accion lab company\_Colour](https://blog.e-zest.com/hubfs/images/Logos%20with%20Tagline/Corporate/SVG/e-Zest%20logo_An%20accion%20lab%20company_Colour.svg "e-Zest logo_An accion lab company_Colour")](https://www.e-zest.com/)

- [WORK](https://www.e-zest.com/our-work)
- [SERVICES](https://www.e-zest.com/our-services) 
    - [Product Engineering](https://www.e-zest.com/digital-product-engineering-services)
    - [Enterprise Data Services](https://www.e-zest.com/enterprise-data-services)
    - [Digital Commerce](https://www.e-zest.com/digital-commerce-services)
    - [Digital Operations](https://www.e-zest.com/digital-operations)
    - [Digital Consulting](https://www.e-zest.com/digital-transformation-consulting-services)
    - [Digital Experience Design](https://www.e-zest.com/digital-experience-design)
- [INSIGHTS](https://blog.e-zest.com/)
- [CAREERS](https://www.e-zest.com/careers)
- [ENTERPRISE DATA SERVICES](https://www.e-zest.com/enterprise-data-services)
- [GENERATIVE AI](https://www.e-zest.com/generative-ai)
- [Healthcare](https://healthcare.e-zest.com)
- [Contact Us](https://www.e-zest.com/contact-us)

- ![Elevating Product Engineering with AI and ML](https://blog.e-zest.com/hubfs/Elevating%20Product%20Engineering%20with%20AI%20and%20ML.jpg)

  [BLOGS](https://blog.e-zest.com)
  
  #### Elevating Product Engineering with AI and ML

  As technology evolves and customer choices broaden, there is an increasing ...

  [Read more](https://blog.e-zest.com/elevating-product-engineering-with-ai-and-ml)
- ![e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024](https://blog.e-zest.com/hubfs/e-Zest%20%E2%80%93%20An%20Accion%20Labs%20Company%20-%20Gets%20Recognition%20as%20a%20Contender%20in%20the%20ISG%20Provider%20LensTM%20Study%20on%20Digital%20Engineering%20Services%202024.jpg)

  [NEWS](https://blog.e-zest.com/news)
  
  #### e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024

  We are delighted to announce that e-Zest – An Accion Labs Company has been ...

  [Read more](https://blog.e-zest.com/news/e-zest-an-accion-labs-company-gets-recognition-as-a-contender-in-the-isg-provider-lens-study-on-digital-engineering-services-2024)
- ![e-Zest Solutions supports Digital Pune Mission](https://blog.e-zest.com/hubfs/blog-files/Digital%20Literacy%20Bus%20e-Zest.png)

  [CSR](https://blog.e-zest.com/csr)
  
  #### e-Zest Solutions supports Digital Pune Mission

  **Pune, India:** e-Zest Solutions, a leading digital technology innovation ...

  [Read more](https://blog.e-zest.com/csr/e-zest-solutions-supports-digital-pune-mission)

- [Work](https://www.e-zest.com/our-work)
- [Services](https://www.e-zest.com/our-services)
- [Insights](https://blog.e-zest.com)
- [Careers](https://www.e-zest.com/careers)
- [Enterprise Data](https://www.e-zest.com/enterprise-data-services)
- [Generative AI](https://www.e-zest.com/generative-ai)
- [Innovations](https://www.e-zest.com/innovations)
- [Healthcare](https://healthcare.e-zest.com)
- [About](https://www.e-zest.com/about-us)
- [Contact](https://www.e-zest.com/contact-us)

- [Blog](https://blog.e-zest.com/)
- [News](https://blog.e-zest.com/news)
- [CSR](https://blog.e-zest.com/csr)

- [![Linkedin Icon](https://blog.e-zest.com/hubfs/icons/linkedin_icon_white.svg)](https://www.linkedin.com/company/e-zest-solutions/)
- [![Twitter Icon](https://blog.e-zest.com/hubfs/twitter-logo-silhouette%20(5).svg)](https://twitter.com/ezest)
- [![Facebook Icon](https://blog.e-zest.com/hubfs/facebook-app-logo%20(4).svg)](https://www.facebook.com/61259256638)
- [![Instagram Icon](https://blog.e-zest.com/hubfs/instagram-logo%20(4).svg)](https://www.instagram.com/ezestsolutions/)
- [![Youtube Icon](https://blog.e-zest.com/hubfs/icons/youtube_icon_white.svg)](https://www.youtube.com/user/ezestcorporate)

[![Go to top icon](https://blog.e-zest.com/hubfs/AA%20Assets/top%20button.svg)](https://blog.e-zest.com/pentaho-configuration-for-mysql/#top)

Hit enter to search or ESC to close

Insights

e-Zest members share technology ideas to foster digital transformation.

- [Blog](https://blog.e-zest.com)
- [News](https://blog.e-zest.com/news)
- [Podcasts](https://www.e-zest.com/podcasts)
- [Healthcare](https://blog.e-zest.com/healthcare)
- [CSR](https://blog.e-zest.com/csr)
- [Whitepaper](https://blog.e-zest.com/whitepaper)
- [Playbook](https://blog.e-zest.com/playbook)
- [Media Kit](https://www.e-zest.com/media-kit)

# Pentaho configuration for MySQL

[Shailesh Kulkarni](https://blog.e-zest.com/author/shailesh-kulkarni)  Dec 26, 2012

[Pentaho Liferay Integration](https://blog.e-zest.com/topic/pentaho-liferay-integration) [business intelligence](https://blog.e-zest.com/topic/business-intelligence-2) [MySQL](https://blog.e-zest.com/topic/mysql) [pentaho](https://blog.e-zest.com/topic/pentaho) [Technology](https://blog.e-zest.com/topic/technology)

- <https://www.linkedin.com/shareArticle?mini=true&url=https://blog.e-zest.com/pentaho-configuration-for-mysql/&title=&summary=&source=>
- <https://twitter.com/intent/tweet?source=https://blog.e-zest.com/pentaho-configuration-for-mysql/&text=Pentaho%20configuration%20for%20MySQL>
- <https://www.facebook.com/sharer/sharer.php?u=https://blog.e-zest.com/pentaho-configuration-for-mysql/>
- <https://www.instagram.com/ezestsolutions/?u=https://blog.e-zest.com/pentaho-configuration-for-mysql/>

**Steps to change Pentaho preconfigured hypersonic database to MySQL**

Recently I integrated Pentaho with Liferay and Mysql. The open source Pentaho Pre-Configured Install (PCI) uses hypersonic as its sample data source, I want to remove this hypersonic dependency and want Pentaho to point to mysql5 database. I have searched for exact steps on Pentaho’s official site ([http://wiki.pentaho.com/](http://wiki.pentaho.com/)) but did not find easy steps to follow. In this blog I have explained the exact steps to remove hypersonic dependency and use mysql5 database.

I have used the following steps to achieve this objective

1. Extract pentaho-data.zip in \[drive name\]liferay-portal-5.2.3 folder.
2. Extract pentaho-solutions.zip in \[drive name\]liferay-portal-5.2.3 folder.
3. Execute the SQL Scripts from the "pentaho-data/mysql5" folder.

```

create_quartz_mysql.sql
create_repository_mysql.sql
create_sample_datasource_mysql.sql
migration.sql
```

4. Copy Pentaho.war file in \[drive name\]liferay-portal-5.2.3tomcat-6.0.18webapps
5. Copy pentaho-portal-layout.war file in \[drive name\]liferay-portal-5.2.3tomcat-6.0.18webapps
6. Copy pentaho-style.war file in \[drive name\]liferay-portal-5.2.3tomcat-6.0.18webapps
7. Open server.xml file from \[drive name\]liferay-portal-5.2.3tomcat-6.0.18conf folder and add following \<context\> entries after \<Host\> tag entry.

```

<Context path="/pentaho" docbase="webapps/pentaho/">
<Resource name="jdbc/SampleData" auth="Container" type="javax.sql.DataSource" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="root" factory="org.apache.commons.dbcp.BasicDataSourceFactory"  driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/sampledata" />

<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="root"driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hibernate" />

<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="root"driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz" />

<Resource name="jdbc/Shark" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="root" password="root"driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/shark" />
```

Please provide the correct MySQL database URL, **username and password** in above  tags. The fields are highlighted with a yellow background.

8. Configure database username, password and driver information in mysql5.hibernate.cfg.xml, hibernate-settings.xml file from **pentaho-solutionssystemhibernate** folder.

Edit file **applicationContext-spring-security-hibernate.properties**

```

jdbc.driver=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate
jdbc.username=hibuser
jdbc.password=password
hibernate.dialect=org.hibernate.dialect.HSQLDialect
```

**Changed to**

```

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3309/hibernate
jdbc.username=<<database user name>>
jdbc.password=<
<password>>
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
```

Edit file **applicationContext-spring-security-jdbc.xml**

```

<!--  This is only for Hypersonic. Please update this section for any other database you are using -->
    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url"
	    value="jdbc:hsqldb:hsql://localhost:9001/hibernate" />
<property name="username" value="hibuser" />
<property name="password" value="password" />
    </bean>
```

**Changed to**

```

<bean id="dataSource"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url"
        value="jdbc:mysql://localhost:3306/liferayreport" />
<property name="username" value="<<database user name>>" />
<property name="password" value="<<password>>" />
</bean>
```

Edit file **mysql5.hibernate.cfg.xml**

change user/password

```

<property name="connection.username"><<database user name>></property>
<property name="connection.password"><
<password>>/property>
```

9. Restart the tomcat, now Pentaho will use mysql as its database

- <https://twitter.com/intent/tweet?source=https://blog.e-zest.com/pentaho-configuration-for-mysql/&text=Pentaho%20configuration%20for%20MySQL>
- <https://www.facebook.com/sharer/sharer.php?u=https://blog.e-zest.com/pentaho-configuration-for-mysql/>
- <https://www.linkedin.com/shareArticle?mini=true&url=https://blog.e-zest.com/pentaho-configuration-for-mysql/&title=&summary=&source=>

### Similar Blog

[![Ensuring Accessibility & Inclusivity in Technology with Conversational AI](https://blog.e-zest.com/hubfs/Ensuring%20Accessibility%20%26%20Inclusivity%20in%20Technology%20with%20Conversational%20AI.jpg) Ensuring Accessibility & Inclusivity in Technology with Conversational AI The fact that the technology landscape is evolving is not breaking news, but the emergence of Conversational AI represents a ... By Shailesh Kulkarni Apr 08, 2024](https://blog.e-zest.com/ensuring-accessibility-inclusivity-in-technology-with-conversational-ai)

[![Generative AI: The Future of Product Engineering](https://blog.e-zest.com/hubfs/Home%20New%20Images/Home%20Images%202020/Banner%20Desktop/Generative%20AI%20The%20Future%20of%20Product%20Engineering.png) Generative AI: The Future of Product Engineering In today's fast-paced technological landscape, the role of Artificial Intelligence (AI) in reshaping product engineering is ... By Shailesh Kulkarni Sep 14, 2023](https://blog.e-zest.com/generative-ai-the-future-of-product-engineering)

[![DevOps for improving productivity and software reliability](https://blog.e-zest.com/hubfs/%5E9FD7331E997F4F5D2AC9EE1D30FD640B1AC5033E0CE9C5EA41%5Epimgpsh_fullsize_distr.png) DevOps for improving productivity and software reliability Now-a-days, DevOps is very popular buzzword in the IT industry and is gaining good traction by companies to adopt DevOps culture ... By Shailesh Kulkarni Jul 31, 2017](https://blog.e-zest.com/devops-for-improving-productivity-and-software-reliability)

[![SaaSification for Big Data application](https://blog.e-zest.com/hubfs/sonal-saasification-for%20big-data-application.png) SaaSification for Big Data application “Products as a Service” or “Software as a Service” models have innate abilities to potentially scale and be cost effective for ... By Shailesh Kulkarni Jul 05, 2017](https://blog.e-zest.com/saasification-for-big-data-application)

[![Distributed public data made easy by Satori](https://blog.e-zest.com/hubfs/ipsita-distributed-public-data-made-easy-by-Satori.png) Distributed public data made easy by Satori One common problem that we face every day is the availability of open/public data distributed on thousands of silos websites ... By Shailesh Kulkarni Jun 21, 2017](https://blog.e-zest.com/distributed-public-data-made-easy-by-satori)

## Helping Organizations Thrive in the Digital Age

[Contact Us](https://www.e-zest.com/contact-us)

- [About](https://www.e-zest.com/about-us)
- [Services](https://www.e-zest.com/our-services)
- [Work](https://www.e-zest.com/our-work)
- [Insights](https://blog.e-zest.com/)
- [Healthcare](https://healthcare.e-zest.com/)
- [Accion Labs](https://www.accionlabs.com/)

- <https://www.linkedin.com/company/e-zest-solutions/>
- <https://twitter.com/ezest>
- <https://www.facebook.com/eZest/>
- <https://www.instagram.com/ezestsolutions/>
- <https://www.youtube.com/user/ezestcorporate>

- Dallas
- Detroit
- Hannover
- Vienna
- London
- Pune

 © 2025 e-Zest Solutions

- [Privacy Policy](https://www.e-zest.com/privacypolicy)
- [Cookie Policy](https://www.e-zest.com/cookie-policy)

 Contact us

 Contact us

e-Zest is a leading digital innovation partner for enterprises and technology companies that utilizes emerging technologies for creating engaging customers experiences. Being a customer-focused and technology-driven company, it always helps clients in crafting holistic business value for their software development efforts. It offers software development and consulting services for cloud computing, enterprise mobility, big data and analytics, user experience and digital commerce.