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
1
vote
0 answers

MySQL Bulk Loader - java.lang.ArrayIndexOutOfBoundsException: -1

Hi, I am using MySQL bulk loader to dump data from Amazon services to a local table on a linux server but every time I execute it fails at the MySQL bulk loader step saying MySQL Bulk Loader - java.lang.ArrayIndexOutOfBoundsException: -1 error log…
Hussain Akhtar Wahid 'Ghouri'
  • 6,527
  • 8
  • 50
  • 85
1
vote
1 answer

Embedding/Integrating 3rd party editor in eclipse

Is there any way to embed or integrate a 3rd party editor in eclipse. We are trying to add Kettle's Spoon editor (java based graphical interface for ETL) to eclipse, without modifying Spoon's code. Is there a way to achive this. The basic need is -…
Kaushal
  • 665
  • 2
  • 9
  • 21
1
vote
1 answer

Kettle Join Rows - Closest Element Larger than x

Using pentaho kettle (also known as pdi), I have a "Join Rows (cartesian product)" step which merges two streams of data. Both the first and second stream have a numeric value attached. For example, Stream 1 - Values 1, 3, 5 Stream 2 - Values 2, 4,…
David
  • 1,097
  • 5
  • 20
  • 34
1
vote
2 answers

How to embed pentaho report designer in web?

I am trying to figure out how to embed a Pentaho Report Designer report on a web page. I don't simply mean printing out the results of a PRD report--I want to actually still design the report using PRD, but within a web framework. Is it possible to…
Andiyono
  • 11
  • 1
  • 4
1
vote
1 answer

How to avoid failure if a folder doesn't exist in Kettle ETL?

Using Pentaho's Kettle tool, I have a transformation set up that starts with a Get File Names step to grab all XML files from a directory. The step is configured like this: File/Directory: "c:\DataFolder" Wildcard (RegExp): ".*xml" This works…
Mike
  • 5,560
  • 12
  • 41
  • 52
1
vote
1 answer

Starting Pentaho BI Server as a windows service?

I am new to Pentaho BI , I am using 'Peantho BI community edition'. please guide me on how to starting BI Server as a windows service. Currently, I am starting Pentaho server manually, however, I want to start BI server as a Windows service. Please…
suresh
  • 41
  • 9
1
vote
1 answer

Pentaho Data Integration - Pass dynamic value for 'Add sequence' as Start

Can we pass any dynamic value (which is the max value of another table column) in "Start at Value" in ADD Sequence step. Please guide me.
vissu
  • 1,921
  • 7
  • 37
  • 52
1
vote
0 answers

How can I connect pentaho to SQL Server 2008 R2 Analysis Service without using Mondrian schema using Driver org.olap4j.driver.xmla.XmlaOlap4jDriver

How can I connect to SQL Server 2008 R2 Analysis Service without using Mondrian schema using Driver org.olap4j.driver.xmla.XmlaOlap4jDriver? I can connect with SSAS and getting data using preview option at Spoon >> Transformation I am following this…
Maneshwar Meel
  • 31
  • 1
  • 3
1
vote
1 answer

In pentaho reports how can I create a report with multiple queries?

I have three tables each one has a date field and some statistics saved in a number of other fields. I want in a single report, side by side, to disply for each day the statistics data found in each table. Table 1 Table2 …
Yazan Jaber
  • 2,068
  • 25
  • 36
1
vote
0 answers

CDE Chart aware of selector for data source

I have a chart and a table which I want to make them aware of a selector option, then selecting the corresponding data source. That will avoid me to put in three tables and three charts to display the same information, but grouped and ordered…
Martin Ocando
  • 914
  • 2
  • 8
  • 18
1
vote
1 answer

"Wait For File" operation in PDI does not recognize windows network drives

In PDI 4.5 the "Wait for File" operation in a job does not seem to recognize windows network drives, i.e. using a path like Z:\stuff\watch\test.txt where Z: is network drive and not on the local machine. Has anybody had this problem? Is there a…
MacBrave
  • 58
  • 5
1
vote
2 answers

Pentaho server is not accessible

I am using pentaho 4.5 , but whenever i install it and try to access the server , it raises some issue like JVM_bind , but i am not running any server , recently i changed my tomcat port no , then it raises this issue Pentaho Initialization…
Hussain Akhtar Wahid 'Ghouri'
  • 6,527
  • 8
  • 50
  • 85
1
vote
4 answers

Is it possible to process and query mondrian cubes without deploying to pentaho bi-server?

If yes, please give a reference. I did a little googling with no result. I want to use olap4j to query the cubes and use the result in a web application. But, I don't need any of the features of bi-server. According to tutorials, the olap schemas…
Farshid Zaker
  • 1,960
  • 2
  • 22
  • 39
1
vote
4 answers

Accessing non-public schema in PostgreSQL with Pentaho

Let me start by saying, what I know about Pentaho wouldn't fill up a single paragraph. I'm more knowledgeable about PostgreSQL. I'm working with some contractors that are building a set of monthly reports in Pentaho (v. 4.5) for my company. Some…
David S
  • 12,967
  • 12
  • 55
  • 93
1
vote
1 answer

Using Pentaho as XML ETL tool

I know nothing about Pentaho and I just want to know whether it can do my job before I commit a lot of time to learn it. Can Pentaho be used as an XML ETL tool? Can it achieve arbitrary transformation? A typical transformation would be to collapse…
user788454
1 2 3
…
99 100