pentahodashboardcda

Pentaho CDE how use my database

I'm trying to create a Penaho Dashboard using CDE and I have problems accessing my Data. I have found tutorials but they always use SampleData or Steel Wheels. I have managed to do that myself, but I need to access my own database.

I was able to connect with my oracle database from the Data Source manager and created my own Data Source. But now I don't know how to access those tables from CDE. If I chose "sql datasource" I see the SampleData datasource and can do queries on it, but not the one I created with my database.

So, once I create a connection with my orcale database, how do I access my tables from CDE?

Thanks

Solution

  • There are two options:

    SQL over JDBC: you define the db host, port, name, username and password; SQL over JNDI: it'll use a registered JNDI from the Pentaho platform.

    The JNDI field is an auto-complete field and fills in the various available options. However, if your newly created connection doesn't show up there, don't worry. Just type it in, it'll work.