O'Reilly logo

Pentaho for Big Data Analytics by Feris Thia, Manoj R Patil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating data connections

To finish the chapter, we will show you how to create a MySQL data connection both in PAC and PUC. Follow these steps to create a new data connection from PAC:

  1. Click on the Administration tab in the left-hand pane.
  2. Click on the Database Connections tab in the center pane. You will see that there is already one connection defined, SampleData. The following screenshot shows the Database Connections tab:
    Creating data connections
  3. Click the plus (+) button in the title pane to add a new connection.
  4. Fill in the database connection details. The following configurations are taken from my local setup:
    • Name: PHIMinimart
    • Driver Class: com.mysql.jdbc.Driver
    • User ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required