Can I use JDBC driver to connect Pentaho with HPCC
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.
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.
- wei xu
- Posts: 8
- Joined: Fri Mar 29, 2013 1:52 pm
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?
- joe.chambers
- Posts: 21
- Joined: Wed Apr 27, 2011 1:07 pm
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
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
- Posts: 9
- Joined: Tue Feb 12, 2013 2:48 pm
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.
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.
mnaweed wrote: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
- Posts: 8
- Joined: Fri Mar 29, 2013 1:52 pm
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
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
wei xu wrote: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.
mnaweed wrote: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
- Posts: 9
- Joined: Tue Feb 12, 2013 2:48 pm
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 wrote: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.pdfwei xu wrote: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.
mnaweed wrote: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
- [email protected]
- Posts: 22
- Joined: Fri Oct 07, 2011 2:24 pm
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.
[email protected] wrote: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'.
- Attachments
-
no fields.PNG
- screenshot of 'not seeing fields'
- (112.4 KiB) Downloaded 1472 times
- wei xu
- Posts: 8
- Joined: Fri Mar 29, 2013 1:52 pm
Pentaho User Console.
mnaweed wrote:What tool are you using?
- wei xu
- Posts: 8
- Joined: Fri Mar 29, 2013 1:52 pm
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.
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.
wei xu wrote:Pentaho User Console.mnaweed wrote:What tool are you using?
- mnaweed
- Posts: 9
- Joined: Tue Feb 12, 2013 2:48 pm
15 posts
• Page 1 of 2 • 1, 2
Who is online
Users browsing this forum: No registered users and 1 guest