Skip navigation
Log in to follow, share, and participate in this community.

Recent Activity

Aleksander Gulchin
Click to view contentHello everyone,   I have such a excel sheet How can I create several excel sheets from this sheet, 1 sheet (file) per 1 project (there are ~40 projects). Is there anything like SQL query select * from PID where PID = 111 but for excel?   Thank you in advance!
in Data Integration
Giovani Stefani
I have the following problem when trying to connect to an Oracle database:   Error connecting to database [DWH] :org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database   Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) no dbjodbc16 in java.library.path  … (Show more)
in Data Integration
Callian Dutra
Hi everyone, I need to comunicate with a WebService trhough "XML HTTP Request". For that, i used a HttpPost component. The first step it's working. My problem is the response, that I get a "compressed file". Inside this compressed file, there is a XML that i need consume to get the information.   I tried save the "response" on disk by two… (Show more)
in Data Integration
Daniel Lee
Click to view contentUsing Kettle 8.1, I'm piloting a MongoDB migration of collections via MongoDB Input/Output steps as below:     Since the keys of the documents are variable, I checked the "Output single JSON field" as below:   The MongoDB Output step simply reads the "json" output field from the source step.   Then, the migrated collection added a wrapper… (Show more)
in Data Integration
diego apugliese
Is it possible to run a SQL Server stored procedure on DATA SOURCE WIZARD? When I tried to do this on PUC (Pentaho User Console), the following message is displayed when I run the stored procedure: EXEC "Query validation failed: Query validation failed: {0}"
in Data Integration
B167W1XV
I'm working on a Transformation which selects from an Oracle database, inserts into a mapping table, performs a couple of lookups and mappings, then inserts into an PostgreSQL database. When I tested with a handful of mocked up records, it worked as expected.   Now I'm running against a Test data set. When I preview the Oracle table input… (Show more)
in Data Integration
Ken Wood
Easy to Use Deep Learning and Neural Networks with Pentaho By Ken Wood and Mark Hall   Hitachi Vantara Labs is excited to release a new version of the experimental plugin, Plugin Machine Intelligence version 1.4. Along with several minor fixes and enhancements is the addition of a new execution engine for performing deep learning and… (Show more)
Daniel Lee
Click to view contentI have an HTTP step (in Job) that connects to a web to download a file via a basic authentication, which works great on Mac OS-X. However, it does not work on Windows with the following error:   ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: Server… (Show more)
in Data Integration
Clifford Grimm
I have a transformation that uses a "streaming" input step.  That is the input step is always listening for incoming messages to process, thus never finishes.  Because of some complications with the transformation w.r.t. creation of temporary files, the best solution we have found to help avoid the issues was to use a Single Threader step to call… (Show more)
in Data Integration
Jose Barrioss Barrios
Good morning, I need the file "oracle.rdb.jdbc.rdbthin.driver" and I can not find it on the oracle website.   Can u share me?   Thanks!
in Data Integration
Load more items