Questions tagged [pentaho]
Pentaho is a set of tools for data integration, analysis and reporting.
24
questions
1
vote
1
answer
337
views
Is it secure to store connection password on Pentaho Spoon?
I'm gonna use Spoon to transfer data from Postgres to MSSQL. I see that when we create connection its data is stored and we don't need to type password anymore.
But I can't find where it stores this ...
- 1,533
0
votes
1
answer
251
views
Pentaho does not read sql script (csv)
I was trying to use a different sql script for one job. For doing this i need to pass the script by file csv, so i set the script like a variable and then i make a transformation that "copy to ...
1
vote
0
answers
704
views
Insert/Update table on Pentaho when the table has a TYPE defined by user
I'm trying to make a remote connection from computer A to computer B where they have the same database but computer B doesn't have data in the table PERSONA_Y_ESTADOS, the goal is to get 3 rows from ...
- 111
1
vote
0
answers
17
views
Date getting truncated on PDI 7.1 for salesforce DB - Need workaround
We are working on transformation which inserts date into a salesforce DB and are seeing issues.
Below are the issues: A transformation working in PDI CE 6.1 do not work in CE 7.1 or CE 8.3.
Error :
...
- 15
0
votes
1
answer
702
views
Pentaho Data Integration - Kettle- Update Identity Column in Microsoft SQL Server
For migration purposes I need to migrate existing ID's from my old database to my new table in MS SQL Server.
I can truncate my table in MS SQL Server and then adjust my database connection in ...
- 17
-1
votes
1
answer
493
views
ERROR [XulParser] handler not found: W?NDOW
PDI(spoon.bat) crashes 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]
***************...
- 99
3
votes
2
answers
985
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 ...
1
vote
1
answer
3k
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 ...
- 5,957
1
vote
1
answer
3k
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 ...
- 5,957
3
votes
1
answer
1k
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)....
- 131
3
votes
1
answer
465
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 ...
- 141
0
votes
1
answer
2k
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 ...
- 117
0
votes
2
answers
1k
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 ...
Stephen Brewster
0
votes
1
answer
21k
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.
2
votes
1
answer
3k
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 ...
- 201
1
vote
0
answers
836
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 ...
- 11
0
votes
0
answers
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 ...
- 220
2
votes
1
answer
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 ...
- 121
-1
votes
2
answers
8k
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
0
answers
486
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:
...
- 41
3
votes
1
answer
338
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 ...
- 41
0
votes
2
answers
471
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 ...
- 101
1
vote
1
answer
3k
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 ...
- 111
2
votes
2
answers
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 ...
- 121