Can I use JDBC driver to connect Pentaho with HPCC

[wei xu]

Thank you for your help. And I tried Pentaho Spoon and I can see the tables. Do not know where is the data source wizard. I wonder if I want to draw pictures out of the table output by HPCC, is there a way to do it in Spoon. What kind of document I should check?

Thank you very much.

Actually, I was trying to replicate what you are doing on my side. I use Pentaho(Spoon) but I am not seeing the Database wizard you are using. Let me know how to get to it in Spoon.

One thing that we noticed. On the Wizard, the image seems to indicate that Pentaho will show the 'Keys' in the box's. If so, HPCC dont define Primary/forign keys hence they'll be blank.

Check the log files for any errors being returned by the JDBC driver and let us know if you see any.

Pentaho User Console.

What tool are you using?

[mnaweed]

On Spoon UI, Click on 'Tools' menu item. you have the Wizards and other database options available.

Google 'getting started with pentaho data integration' for good documentation.

[wei xu]

Hi, I wonder if I can use spoon to create a dashboard? I use pentaho console because it can help to create a dashboard.

Here is the screen short I get when use pentaho user console to connect HPCC. Do you have any idea that what the schema called HPCC System means? And why there seems one file name repeats twice under the available table ?

On Spoon UI, Click on 'Tools' menu item. you have the Wizards and other database options available.

Google 'getting started with pentaho data integration' for good documentation.

[mnaweed]

What name did you give to the Database Connection?

Hi, I wonder if I can use spoon to create a dashboard? I use pentaho console because it can help to create a dashboard.

Here is the screen short I get when use pentaho user console to connect HPCC. Do you have any idea that what the schema called HPCC System means? And why there seems one file name repeats twice under the available table ?

On Spoon UI, Click on 'Tools' menu item. you have the Wizards and other database options available.

Google 'getting started with pentaho data integration' for good documentation.

[wei xu]

The name is hpcctry. The screen shot is showed below. And also the problem is that I can not get the table. The pentaho seems updateing data source and then runs forever.

What name did you give to the Database Connection?

Hi, I wonder if I can use spoon to create a dashboard? I use pentaho console because it can help to create a dashboard.

Here is the screen short I get when use pentaho user console to connect HPCC. Do you have any idea that what the schema called HPCC System means? And why there seems one file name repeats twice under the available table ?

On Spoon UI, Click on 'Tools' menu item. you have the Wizards and other database options available.

Google 'getting started with pentaho data integration' for good documentation.