Questions tagged as 'pentaho'

1
answer

Problems 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 data in Excel looks like this: WhenItryt...
asked by 10.10.2018 / 00:15
2
answers

Generate PivotTable 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 too. If I set it to get the data and put it directly into the PivotTable, it does not restrict the 1 million records, becaus...
asked by 27.01.2017 / 17:41
0
answers

Get rows from result PENTAHO

I would like to know how I pass the data from a "Copy rows to result" to the "Get rows to result". I'm using 1 job with 2 transforms to perform such a process, so it's process 1 using copy rows and process 2 get rows, but it does not pass the da...
asked by 29.09.2017 / 21:23
0
answers

How to execute a select in pentaho

I would like to know how I execute sql commands in pentaho, I need to search for certain data by giving select but I already used table input and sql query and it did not work.     
asked by 26.04.2017 / 17:15
1
answer

Pentaho 4.8 - Importing a Schema (Cube)

I'm using Pentaho 4.8 with Saiku, and would like to know how I set up a cube (xml file created in Schema Workbench). Previously I was using Pentaho 5, it was enough for me to add Datasource and Analysis to DataSource Manager, but in Pentaho 4...
asked by 03.09.2014 / 16:20
1
answer

Inserting foreign keys by Kettle

I need to load some data that is in spreadsheets into a relational database, but I have been facing some challenges with regard to inserting foreign keys. In these images you can see that I enter the project data first, the auto increment of...
asked by 27.08.2018 / 00:37
1
answer

Pentaho Data Integration repository does not appear in POI

Good evening. I have a constant problem with the POI. Sometimes when I open spoon.bat it does not load the repository or even enable the option to connect to a repository. I have already researched in several forums and so far the past soluti...
asked by 06.11.2018 / 21:51
0
answers

Comp remove Special characters?

I have a problem with a report from Pentaho, prd. It does not generate the PDF report because of the amount of special characters. I wanted a way in the sqlserver to remove the characters without losing the formatting of the text. Because the te...
asked by 16.09.2018 / 19:14
0
answers

Spoon Kettle does not work after updating Ubuntu packages (14.04)

The spoon was working normally until an Ubuntu update was run. After updating the command ./spoon.sh nothing happens and the application is not started. I accessed the update log and saw that only postgresql stuff was updated as shown...
asked by 17.08.2018 / 19:19
1
answer

Tomcat using all colors

Good morning! Is there any configuration to be made for Tomcat to use all the colors on the machine? I'm asking because I realized that tomcat here does not use all the colors. Hugs,     
asked by 11.06.2018 / 16:23