Can I use JDBC driver to connect Pentaho with HPCC

[wei xu]

Hi,

I wonder if I can connect Pentaho with HPCC using JDBC driver. Which database selection should I choose? Will the Generic Database work? What should the customer URL be?

Thank you very much.

[joe.chambers]

I've not used the JDBC driver but we have developed some plugins that allow you to interface Pentaho Spoon with HPCC directly. Which part of the Pentaho suite are you using?

[mnaweed]

Yes, you can connect Pentaho with HPCC using JDBC driver. To do it:

Select 'Generic database' as Connection Type

Custom Connection URL:
jdbc:hpcc:ServerAddress=<server ip address>;Cluster=default:WsECLDirectPort=8008:EclResultLimit=100:QuerySet=thor:LazyLoad=true:PageSize=100:LogDebug=true:

Custom Driver Class Name:
org.hpccsystems.jdbcdriver.HPCCDriver

[wei xu]

Thank you,mnaweed.

It works. And I wonder if there is any parameters I can control to see all the results or see the recent results output by HPCC?

Thank you for your help.

Yes, you can connect Pentaho with HPCC using JDBC driver. To do it:

Select 'Generic database' as Connection Type

Custom Connection URL:
jdbc:hpcc:ServerAddress=<server ip address>;Cluster=default:WsECLDirectPort=8008:EclResultLimit=100:QuerySet=thor:LazyLoad=true:PageSize=100:LogDebug=true:

Custom Driver Class Name:
org.hpccsystems.jdbcdriver.HPCCDriver

[mnaweed]

The driver returns the results of the requested query but It'll not store the results so you'll not be able to see the previous queries results.

You can control the some information using the parameters. I suggest you refer to the following document for more information:
http://cdn.hpccsystems.com/install/jdbc ... 2beta1.pdf

Thank you,mnaweed.

It works. And I wonder if there is any parameters I can control to see all the results or see the recent results output by HPCC?

Thank you for your help.

Yes, you can connect Pentaho with HPCC using JDBC driver. To do it:

Select 'Generic database' as Connection Type

Custom Connection URL:
jdbc:hpcc:ServerAddress=<server ip address>;Cluster=default:WsECLDirectPort=8008:EclResultLimit=100:QuerySet=thor:LazyLoad=true:PageSize=100:LogDebug=true:

Custom Driver Class Name:
org.hpccsystems.jdbcdriver.HPCCDriver

[rodrigo.pastrana@lexisnexis.com]

In particular, take a look at the EclResultLimit connection parameter. By default it is set to return the first 100 result records. You can set this parameter to 'ALL'.

The driver returns the results of the requested query but It'll not store the results so you'll not be able to see the previous queries results.

You can control the some information using the parameters. I suggest you refer to the following document for more information:
http://cdn.hpccsystems.com/install/jdbc ... 2beta1.pdf

Thank you,mnaweed.

It works. And I wonder if there is any parameters I can control to see all the results or see the recent results output by HPCC?

Thank you for your help.

Yes, you can connect Pentaho with HPCC using JDBC driver. To do it:

Select 'Generic database' as Connection Type

Custom Connection URL:
jdbc:hpcc:ServerAddress=<server ip address>;Cluster=default:WsECLDirectPort=8008:EclResultLimit=100:QuerySet=thor:LazyLoad=true:PageSize=100:LogDebug=true:

Custom Driver Class Name:
org.hpccsystems.jdbcdriver.HPCCDriver

[wei xu]

I went into this problem that when I connecting to the HPCC, I can see the available table list,but when I add it, I could not see the fields. Please see the attached screenshot.

In particular, take a look at the EclResultLimit connection parameter. By default it is set to return the first 100 result records. You can set this parameter to 'ALL'.

[mnaweed]

What tool are you using?

[wei xu]

Pentaho User Console.

What tool are you using?

[mnaweed]

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?