Stack Overflow
Stack Overflow

Questions tagged [pentaho]

The Pentaho BI Suite is an open source business intelligence suite with integrated reporting, dashboard, data mining, workflow, and ETL capabilities. It is primarily written in Java.

The latest GA release of Pentaho Suite has four primary downloadable products.

PDI - Pentaho Data Integration is a graphical extract, transform, and load (ETL) solution that uses an innovative metadata-driven approach. PDI includes the DI Server, a design tool (aka Spoon), three utilities, and several plugins.

PBA - Pentaho Business Analytics formally known as Pentaho Business Intelligence (BI) is mainly used for dashboard development.

PRD - Pentaho Report Designer is used for developing business (B2B and B2C) reports.

PSW - Pentaho Schema workbench is used for developing OLAP cubes and schemas.

3854 questions
12
votes
9 answers

Connect Pentaho to MS SQL Server (Native)

I am very new in using PENTAHO. I need to connect this software to MS SQL Server (Native). I already try to connect it many time but every time I test the connection, failed. This is the error message that occur every time I test the…
crystal
  • 195
  • 2
  • 3
  • 14
11
votes
3 answers

Multiple SQL query not working with delimiter on DBeaver

I can't execute MySQL statement when using delimiter (default ';'). I mean, when I run query like: select * from mdw.dim_date dd limit 10; select * from mdw.dim_order do limit 5; I've got such error: SQL Error [1064] [42000]: You have an error in…
user14261502
  • 121
  • 1
  • 1
  • 5
11
votes
5 answers

Maven Dependency for PDI(Pentaho Kettle) Jar files

I have written Java code to execute my transformation and Jobs and I have manually added all the Jar files present in the data-integration/lib folder to my class path and evrything is working fine. Now I want to mavenize my project and looking for…
sun_dare
  • 1,146
  • 2
  • 13
  • 33
11
votes
3 answers

Production architecture for big data real time machine learning application?

I'm starting to learn some stuff about big data with a big focus on predictive analysis and for that I have a case study I would like to implement: I have a dataset of servers health information that is polled every 5sec. I want to show the data…
AlfaTeK
  • 7,487
  • 14
  • 49
  • 90
10
votes
4 answers

Connect R to a SQL Server database engine

At my work I have R-Studio (Microsoft R Open 3.2.5) installed and would like to connect to a Microsoft SQL Server database, to run scripts using the tables I have. Is there any chance that I can connect to a SQL Server database using Pentaho and…
D.Roca
  • 487
  • 2
  • 5
  • 7
9
votes
2 answers

Use JSON Input step to process uneven data

I'm trying to process the following with an JSON Input step: {"address":[ {"AddressId":"1_1","Street":"A Street"}, {"AddressId":"1_101","Street":"Another Street"}, {"AddressId":"1_102","Street":"One more street", "Locality":"Buenos Aires"}, …
rsilva4
  • 1,915
  • 1
  • 23
  • 39
9
votes
4 answers

Duplicating a job in Pentaho Data Integration for different connections

I've generated a job via the Copy Tables wizard in Spoon UI, that copies some tables from an oracle database source to an SQL Server one, and made some changes to the job as well. Now I want to duplicate the same job (same tables and same…
mounaim
  • 1,132
  • 7
  • 29
  • 56
9
votes
3 answers

Can we compare saiku with Pentaho Analyzer?

I'm currently in an internship and i have to create a whole BI application. I think i'll use pentaho, and I have to use just open source component. I know that Pentaho Analyzer is not free My question is: Is saiku an equivalent of analyzer? If yes,…
joris
  • 435
  • 1
  • 7
  • 18
8
votes
2 answers

.NET ETL Process

First some background; we are developing a datawarehouse and doing some research on what tools to use for our ETL process. The team is very developer centric, everyone is knowledgeable with C#. So far I have looked at RhinoETL, Pentaho (Kettle),…
Matt
  • 257
  • 3
  • 9
8
votes
3 answers

Pentaho: How to dynamically add Field (= Column) to OutputRow?

I would like to dynamically add fields (or a new columns) to the resulting output row in Kettle. After spending hours reading through froum posts and he not so well done scripting documentation, I wondered if Stackoverflow would be of any help.
chris polzer
  • 3,219
  • 3
  • 28
  • 44
8
votes
3 answers

How do you reference the root key using JSON Path?

I have data like so: {"key": {"name":"hi", "size":10}} "key" is a dynamic value. It isn't fixed. I can access name and size using this JSON Path: *.name *.size How can I get the value of "key" itself with JSON Path? * gives me the entire row of…
gdm
  • 905
  • 1
  • 15
  • 21
7
votes
2 answers

Pentaho-kettle: Need to create ETL Jobs dynamically based on user input

In my application, user can specify the format of their file. Based on user input we dynamically create SSIS package. http://lakshmik.blogspot.com/2005/05...eate-ssis.html Dynamically created SSIS package is used for processing user's files. We…
Arnav
  • 1,008
  • 1
  • 10
  • 12
7
votes
2 answers

How to run a pentaho job from Command Line

Have a job which takes around 1/2 minutes to finish, now trying to run this job through the command line just goes on forever and doesn't finish. It doesn't look like I get any errors from this either. So the job seems to be starting and I know the…
OCTAVIAN
  • 336
  • 5
  • 18
7
votes
1 answer

Pentaho/POI throws InvocationTargetException

I am trying to upgrade all my java application to openJDK11 ( from Oracle 8 ). and I notice one problem in my reporting server which use Pentaho. It seems that the Excel autosize feature requires libfontconfig.so in openJDK11, however I can find the…
Rudy
  • 7,008
  • 12
  • 50
  • 85
7
votes
5 answers

Unable to start blueprint container for bundle pdi-dataservice-server-plugin due to unresolved dependencies

I am using windows batch file to call a Pentaho Data integration job, intermittently, the job gets hung indefinitely. The error message in Pentaho logs is as below : 06:43:37,951 ERROR [BlueprintContainerImpl] Unable to start blueprint container…
Sarang Manjrekar
  • 1,839
  • 5
  • 31
  • 61
1
2
3
…
99 100