Questions tagged [pentaho]

Pentaho is a set of tools for data integration, analysis and reporting.

Filter by
Sorted by
Tagged with
0
votes
1answer
207 views

ERROR [XulParser] handler not found: W?NDOW

PDI(spoon.bat) crushes on startup. Here's /logs/spoon.log: 09:59:04,793 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled 09:59:08,932 INFO [KarafInstance] **************...
1
vote
1answer
171 views

How do I run a database heavy query over jdbc without timing out (Oracle)?

For one of our applications (Pentaho Data Integration), we need to run queries through the oracle jdbc. Some of these queries are computation expensive and can take an hour or more to return any rows ...
0
votes
0answers
430 views

How to extract and store errors from Pentaho PDI

I'm using Pentaho PDI 'Spoon' version 7.1 to build an ETL package. The existing version of the package (built in SSIS) uses the built in variable @[System::ErrorDescription] to store an error ...
1
vote
1answer
1k views

How can I prevent Pentaho DI/Spoon from deadlocking?

I have a transformation with four steps: Read a pipe-delimited text (a text file input step) Write to a staging table, with truncation (import table) Run a stored procedure against the table ...
1
vote
1answer
746 views

How can I control how Pentaho DI formats integers coming from a text file?

I have a simple pipe-delimited text file with integers recorded as a sequence of numbers: 012345|00678 |various|text|fields There are some leading zeros, and some trailing white space, but no ...
3
votes
1answer
613 views

How SQL Server determines the data transfer rate

We are having some issues with the data transfer rate when extracting data from SQL Server. Our scenario is as follows: SQL Server 2008, in a Windows Server 2003 with 32 GB RAM (located in Guatemala)....
3
votes
1answer
133 views

PostgreSQL batch inserts fail silent randomly

I have been using Kettle to import data from a SQL Server to PostgreSQL on AWS RDS and when I was enabling all of my foreign key constraints I realized that data was missing, often in the even ...
0
votes
1answer
830 views

Extract data from Oracle DBF files

I'm completely new to Oracle and I was provided with what appears to be an Oracle database backup (170 DBF files and 3 CTL files). I'd like to extract the information using SSIS or Pentaho's Kettle ...
0
votes
2answers
980 views

Pentaho Kettle - Unable to connect to virtual Oracle Database

I'm attempting to connect to a virtualized Oracle database but I am receiving the following error: Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) Listener refused the ...
0
votes
1answer
15k views

How to convert timestamp to string in Pentaho Kettle?

I have a timestamp field in my input table like this: yyyy-mm-dd hh24:mm:dd, I want output sting like this: yyyymmdd.
1
vote
1answer
1k views

Pentaho Data Integration: 'Execute SQL statement' to create trigger

I'm trying to create a mysql trigger via an Execute SQL Statement step in my transformation. Below are the commands I'm attempting to run. DROP TRIGGER IF EXISTS ...
1
vote
0answers
657 views

Pentaho Kettle (Data Intergration) MongoDB Aggregation

I'm using kettle v5.2 which support the aggregation pipleline in MongoDB when using MongoDB input the query works for small data set but I need to use option allowDiskUse to the query can't figure ...
1
vote
0answers
205 views

Pentaho design reporter: Parameter error

I am new to Pentaho platform. i have created view using Mysql workbench. Now i want to design a report for output. Running this error " Parameters for this report are not valid". How do i solved this ...
0
votes
0answers
3k views

Communications link error with MySQL

I have a process which runs via Pentaho on a Unix server against MySQL 5.6.19. and using 5.1.32 of the MySQL jdbc driver. We actually found this driver helped with this error in some cases compared ...
2
votes
1answer
2k views

date dimension OLAP cube design

I have a sales reporting system with incoming data like this date,editionID,outletId,Measure1,Measure2 2013-01-01,2,532,11,24 etc... I am new to designing data cubes (for the pentaho BI suite) and ...
-1
votes
1answer
6k views

How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?

This error shows up when I try to connect to database string host:port/servicename.
1
vote
0answers
462 views

OLAP Advanced custom filters date

How do i filter, in a Mondrian MDX Query, just the FACTS that have ocurred in a Range of Months over last 3 years? I need to make it dynamic so i can use parameters latter, so i need the following: ...
3
votes
1answer
327 views

BI - Cube Concept and MDX Query Help [closed]

In a Mondrian Schema, I have a fact table for Sales, a dimension table Time and a dimension table Client. I need to create a Saiku report where i can show how many clients joined per year. I have a ...
0
votes
2answers
391 views

Daily snapshot fact table

I have a list of products per costumer. Costumers can delete or add products to their list. I want to know in each day what is the list of products (and count) by costumer. My first approach is to ...
1
vote
1answer
2k views

How do I get Pentaho Reporting/Kettle to produce PDF reports by business entity?

We use Kettle/PDI to handle usage records from legacy systems and feed them to an analysis database/DWH and also we report to our customers their activity and a backend commission report on a monthly ...
2
votes
2answers
1k views

How to perform ETL from RDBMS to Neo4j

I have a mature 50+ tables web application based on mySQL. In order to do some advanced data mining I want to use Neo4j and the goodnes of cypher. However I'm having a hard time migrating my data from ...