Most voted "pentaho" questions
Pentaho is an open-source solution for Business Intelligence, developed in Java. The solution covers the areas of ETL (Extraction, Transformation and Load), Reporting, OLAP and data mining (data-Mining).
Learn more…21 questions
Sort by count of
-
2
votes1
answer124
viewsHow to run a select on Pentaho
I would like to know how I execute sql commands on So, I need to search certain data giving select but I already used table input and sql query and it didn’t work.
-
1
votes2
answers123
viewsGenerate dynamic table in Excel from MSSQL with 8 million records
I have a table in MSSQL with currently 8 million records. I use Pentaho to analyze this data. I’m trying to use Excel as well. If I set it up to take the data and put it right on the dynamic table,…
-
1
votes0
answers41
viewsGet Rows from result PENTAHO
I would like to know how I pass data from a "Copy Rows to result" to "Get Rows to result". I am using 1 job with 2 Transforms to carry out such a process, so process 1 using copy Rows and process 2…
pentahoasked 7 years, 3 months ago Lucas Yoshida 31 -
1
votes0
answers373
viewsPentaho - Kettle - Job runs on the Spoon, but does not run on the Kitchen
I have a job simple that simply runs a transformation that connects to the Oracle database via jdbc, makes a select by a database input and writes the data to another table. It turns out that in…
-
1
votes1
answer303
viewsProblems importing data with Microsoft Excel Input
I’m importing several spreadsheets into a database, but some of them are having input problems. I’ve even tried to transform the format and use CSV File Input, but the problem remains the same. The…
-
0
votes1
answer1049
viewsPentaho 4.8 - Importing a Schema (Cube)
I am using Pentaho 4.8 with Saiku, and would like to know how I configure a cube (xml file created in Schema Workbench). Previously I was using Pentaho 5, it was enough to add Datasource and…
-
0
votes0
answers26
viewsSaiku and CDE are not providing specific data
Good afternoon, everyone, I have the following problem: In my Saiku and CDE are not bringing data from the day '19/02/2017'. In the source file (excel), database and OLTP, show normally (there are…
pentahoasked 7 years, 9 months ago Leandro A Anjos 1 -
0
votes1
answer184
viewsMDX - Monthly Average Open by Date
I need a lot of help. I am working with MDX for graphics generation in Pentaho - CDE / Ctools. And I need to perform a series of filters that will be set by the user. The chart is a daily evolution,…
-
0
votes1
answer16
viewsTomcat using all colors
good morning! Is there any configuration to be made for Tomcat to use all colors on the machine? I’m asking because I realized that Tomcat here doesn’t use all colors. Hug,
-
0
votes1
answer117
viewsJenkins - Pentaho execute script as logged in user
Good afternoon gentlemen, I’m using Jenkins to run a job in Pentaho, this job runs a script, which simulates user interaction, but as Jenkins runs in the background, it does not associate with any…
-
0
votes1
answer472
viewsPentaho - Error running bat by Windows Task Scheduler
Follows the code of .bat: @echo off TITLE MeuProcessoAutomatico SET currentdir=%~dp0 SET kitchen=C:\pdi\data-integration\Kitchen.bat SET logfile="%currentdir%main.txt" echo. >> %logfile% echo.…
-
0
votes0
answers5
viewsDenormalization of data with Pentaho
Suppose I have a table like this below in a CSV file, there is some command in PDI that I can turn the table into a dimensional model without I need to manually create columns with the relationship…
-
0
votes1
answer287
viewsInsertion of foreign keys by the kettle
I need to load some data that are in spreadsheets in a relational database, but I have been facing some challenges regarding the insertion of foreign keys. In these images you can see that I first…
-
0
votes2
answers1611
viewsPentaho Data Integration repository does not appear in PDI
Good night. I’m in constant trouble with the PDI. Sometimes when I open Spoon.bat it doesn’t load the repository and it doesn’t enable the option to connect to a repository. I’ve searched several…
-
0
votes1
answer84
viewsReturn a JSON block within another block
Hello! I am using Pentaho Data Integration to return a JSON from the Twitter API, but I have an error in processing JSON and return only the values I want. I’m trying to return block values…
-
0
votes1
answer51
viewsError while trying to load excel tabs in Spoon Pentaho
I am in need of help, I started to study the tool of the PDI I am doing several tests to learn how to use the tool, but when I try to load an EXCEL file. I cannot load the tabs from the archive. I…
-
0
votes0
answers27
viewsJavascript to remove an attribute from AD (Pentaho - modified Java Script Value)
I am trying to remove an attribute from an AD record using Pentaho, so I have this script below. It is returning the error: Can’t find method…
-
0
votes0
answers96
viewsError in connection to SQL Server database using Pentaho PDI and BA Server
Personal I am with error in the connection of Pentaho PDI and BA Server. I configured the drivers according to this link:…
pentahoasked 3 years, 6 months ago Igor Silva 661 -
-2
votes1
answer1331
viewsSpoon.bat does not work with windows 7 and java 1.8
After unzipping the Pentaho PDI. I try to run Spoon.bat and get this message below and do not open the IDE I’m using java 1.8 and windows 7 64bit Error message: DEBUG: Using JAVA_HOME DEBUG:…
-
-3
votes2
answers319
viewsGet all the content I don’t want via Regex
Guys, I need to pull from a string, by Regex, all content that is not equal to CNPJ. Ex: Flap1 -> 123 - EMPRESA CICLANO101 30.589.587/0001-87 Line2 -> 4567 - FULANO LTDA28.819.917/0001-31…
-
-3
votes1
answer90
viewsRemove all before the last occurrence of a - (dash) regex
This is so simple but I can’t find the answer! I would like to delete everything before the last occurrence of the "-" symbol in a sentence: I’m using a Pentaho step, Replace in String: Regex…