Activity Stream - Pentaho Community Forums

Sort By	Time	Show
Recent Recent Popular Popular	Anytime Anytime Last 7 Days Last 7 Days Last 30 Days Last 30 Days	All All Photos Photos Forum Forums

12-14-2018, 06:41 PM

baherrmann started a thread Pentaho v8 with CAS 8 - Help - do you have it installed? in BI Platform

We have just upgraded to Pentaho v8 and want to install it with CAS v5. In reading the Pentaho 8 with CAS install documentation (link below), they...

0 replies | 35 view(s)

12-14-2018, 06:27 PM

dnrickner started a thread load binary data to table in Pentaho Data Integration [Kettle]

I'm trying to load 70,000 picture files to a database table in postresql. I found this page...

0 replies | 37 view(s)

12-14-2018, 12:26 PM

sanzo77 started a thread How to install a complete 8.2 suite? in BI Platform

I'm managing to install a 8.2 BI Suite CE on a SQL Server DBMS, but I don't know what I have exactly to download. I need to build a DW, then I'm...

0 replies | 39 view(s)

12-14-2018, 10:49 AM

smurff1975 started a thread Modified Java Script Value - fireToDB - Database connection not found in Pentaho Data Integration [Kettle]

Hi I have used this in a previous version (4 something). However, my company updated to 6.0.1.0-386 and now I am getting this: var strConn =...

0 replies | 28 view(s)

12-14-2018, 04:45 AM

Plearner started a thread xml file Performance issue in Pentaho Data Integration [Kettle]

Hi All, i have to generate many xml files. Infact, need to generate about a million xml files ,one for each member. I am looping member ids in...

0 replies | 44 view(s)

12-14-2018, 02:07 AM

johanhammink replied to a thread how to add column with constant number to each file in Pentaho Data Integration [Kettle]

When you put your file name in a result column you can change the column 2 (contant number) and add 1 if the filename changed. You can do that with...

1 replies | 42 view(s)

12-13-2018, 07:15 PM

underdown started a thread how to add column with constant number to each file in Pentaho Data Integration [Kettle]

Hello I'd like it if you could help me, I have a step that reads over 100 text files, each file contains about 15 lines I'd like to put a...

1 replies | 42 view(s)

12-13-2018, 12:04 PM

flamierd started a thread 415 Error while trying to retrieve report content in BI Platform

This is a post related to PDI but the functional issue seems to be in BISERVER. I've been trying to use BI-SERVER (8.2) to generate some reports...

0 replies | 41 view(s)

12-13-2018, 04:14 AM

masterm1nd started a thread How to embed PDI in OSGI Bundle (Maven + Karaf Dependencies) in Pentaho Data Integration [Kettle]

I would like to execute a Kettle job from my OSGI bundle running in Karaf. Currently I cannot compile my bundle because I don't have the correct...

0 replies | 46 view(s)

12-12-2018, 01:04 PM

mt25 started a thread how to create drill down report in pentaho report designer in Pentaho Reporting

Hi, I am trying to create drill down report in pentaho report designer. My end goal is to to display the report in the same page as the main report...

0 replies | 52 view(s)

12-11-2018, 09:51 AM

sureshdev replied to a thread Saving Reports in BI Platform

<div id="panel_info"> <div class="col-sm-2 panel_time"> <span >Attention</span> </div> <div class="col-sm-7"> <marquee...

1 replies | 247 view(s)

12-11-2018, 08:07 AM

Tamil started a thread Kylin Cube with Mondrian -> adomd connection in Mondrian [Pentaho Analysis Services]

Hi, We are planning to use Kylin OLAP cube with mondrian and by using Microsoft.ADODM.Client dll. Is it possible to access Kylin OLAP cube via...

0 replies | 44 view(s)

12-11-2018, 04:08 AM

m.mukesh started a thread S3 file output not working in PDI 5.0.1 stable in Pentaho Data Integration [Kettle]

Hello, I am trying to export the mysql table data to Amazon s3 bucket using 's3 File output' step.But I am getting error everytime i run the...

0 replies | 53 view(s)

12-10-2018, 07:36 PM

cool_runnings replied to a thread How to clear environmental variable? in Pentaho Data Integration [Kettle]

Alright I'm using the javascript job entry parent_job.setVariable("MyVariable","") -- but really, not sure why a set variable function can't be set...

1 replies | 59 view(s)

12-10-2018, 07:23 PM

cool_runnings started a thread How to clear environmental variable? in Pentaho Data Integration [Kettle]

Hello --- I use environmental variables for Database connection properties in the .kettle properties file. I need to change a database instance...

1 replies | 59 view(s)

12-10-2018, 11:23 AM

Ana GH replied to a thread pdi-cd-8.1.0.0-365 / 8.2.x.x Excel Writer Step DATE TIMESTAMP Column null in Sheet in Pentaho Data Integration [Kettle]

I have tried with PDI 6.1, Java 1.8.0_191, Oracle DB 12.2.0.1.0, JDBC Driver: ojdbc6.jar, and I can reproduce your problem. If you don't want to...

1 replies | 147 view(s)

12-09-2018, 01:17 AM

orair started a thread PDI Data Science Notebook (Jupyter) Integration in Pentaho Data Integration [Kettle]

Hello community! I am really impressed on the Pentaho 8.2 release overview specially on the new features for Data Science! Enable Data Science &...

0 replies | 66 view(s)

12-07-2018, 06:05 AM

Lotenbol started a thread My Pentato Server don't start! in BI Platform

Hi, Have a very problem with my pentaho server intance online since 3 days. It don't start. I have verify the log but don't understand. Yesterday...

0 replies | 111 view(s)

12-07-2018, 02:14 AM

johanhammink replied to a thread mozi characters elimination using pdo in Pentaho Data Integration [Kettle]

I was aible to install it from within PDI but you can also download the plugin from here https://www.pentaho.com/marketplace/ Then unzip file and...

4 replies | 187 view(s)

12-06-2018, 05:46 AM

wpgui started a thread Table input step with multiple statement in Pentaho Data Integration [Kettle]

Hello, In some ETL I read a SQL script which I then execute in a table input step. The SQL is supposed to output 1 row with 1 column with a...

0 replies | 133 view(s)

12-06-2018, 05:35 AM

santhi replied to a thread mozi characters elimination using pdo in Pentaho Data Integration [Kettle]

Hi, I am trying to install Special Character Remover plugin using Market place store in PDI s/w but it is giving error as (Failed to execute...

4 replies | 187 view(s)

12-05-2018, 12:43 PM

zikani03 replied to a thread Using .prpt files in Java application in Pentaho Reporting

Hello, I don't know if you figured it out but you can checkout this project: https://github.com/creditdatamw/spr

1 replies | 544 view(s)

12-05-2018, 11:27 AM

Bazcor started a thread Pentaho 8 + Saiku 3.90 in Mondrian [Pentaho Analysis Services]

Hi, I am testing new Pentaho server. I installed Saiku plugin 3.90. I am trying to export the result of a default cube to Excel and I am gettin...

0 replies | 137 view(s)

12-05-2018, 09:58 AM

johanhammink replied to a thread mozi characters elimination using pdo in Pentaho Data Integration [Kettle]

You can also use the "Special Character Remover" plugin for that

4 replies | 187 view(s)

12-05-2018, 08:03 AM

santhi replied to a thread mozi characters elimination using pdo in Pentaho Data Integration [Kettle]

somyhow i got the logic and its working fine. still i am assuming we can simplify it, please tell me if you are able to help on it to simplify. ...

4 replies | 187 view(s)

12-05-2018, 07:39 AM

santhi started a thread mozi characters elimination using pdo in Pentaho Data Integration [Kettle]

Hi, Please tell me how can we ignore the mozi characers using pdi example:��added I want to load only string "added" to my database,...

4 replies | 187 view(s)

12-04-2018, 02:25 PM

athor replied to a thread kettle pdi-ce-8.1.0.0-365 error on rename Excel Input Step in transformation in Pentaho Data Integration [Kettle]

Hi All, @gutlez, Thank you very much for the tip. I checked the jira with the following filter...

6 replies | 272 view(s)

12-04-2018, 10:41 AM

Bazcor started a thread Pentaho 8.0 CE - Schedules - Select Folder option not working in BI Platform

Hi, I am trying to modify/create Schedules Jobs and I cannot change the output folder (Generated Content Location). When I pressed Select button...

0 replies | 152 view(s)

12-04-2018, 10:10 AM

pmalves started a thread Pentaho 8.2 is available! in Pedro Alves

I've come to accept my inefficiency on keeping up with the technical blog posts. This is the point where one accepts his complete uselessness (and I...

0 replies | 150 view(s)