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

Recent Activity

Roman Friedman
Getting test result: core-site-xml has no configuration entered. My Hadoop cluster's namenode FQDN:cloud106.scisvlab.local. Also, why hop has It is my first project and pentaho docs are very contradicting.
in Data Integration
Daniel Polistchuck
Any MongoDB aggregation Query using the MongoDB Input node is broken if the query runs against the (latest) 3.6 version of MongoDB.   The usage of cursors is now a requirement in aggregation pipelines and this is implemented in the latest 3.6 MongoDB Java drivers.   Here's the current stacktrace if someone tries to use the included (old, 3.2.2)… (Show more)
in Data Integration
Rob Burgess
What is the best way to list the files in an AWS S3 bucket using a Job or Transformation?
in Data Integration
Brian Hoover
Specifically - PDI 8.0 CE using PostgreSQL and driver version 42.2.2, I need to specify the option of `stringtype=unspecified`.  This is used to avoid casting issues from varchar to uuid.   Related background: ERROR: column "guid" is of type uuid but expression is of type character varying   If I switch from JNDI to JDBC in my connection type… (Show more)
in Data Integration
Alex Bitz
Hello, I'm not sure if this is the right place for this I am trying to connect to a Rest API through Pentaho Data Integration. Using API Tester I can connect and get a proper response body quite easily so I know it works, but I can't for the life of me get it to work in Pentaho. I keep getting a "Error finding field [Authorization] in incoming… (Show more)
in Data Integration
Rob Burgess
How do you return a ResultSet from a SQL Server stored procedure with multiple parameters?   I understand you can use the Table Input step but I am unsure of the syntax to execute the stored procedure with more than 1 parameter.
in Data Integration
Lucas Goncalez
Hello!   I want to take only a part of .txt, its possible? For example, i want just the three lines in the image:     Remember that in .txt the lines will not always be in the same position. Someone can help?   Thanks!
in Data Integration
Maciej Wanicki
I'm trying to use spoon for some data transformations. The imput file I need to work on is a complex xml file with multiple nodes that have multiple child nodes. The first step of the process I want to do is to just map it into a 2d table. For example:   <product>      <id>1</id>      <name>car</name>      <attributes>           <attribute>… (Show more)
in Data Integration
Isha Lamboo
Does the active/running job/transformation exist as an object that can be used in java/javascript code?   I have an existing set of template-style jobs and transformations (made by someone else) that makes heavy use of parameters and variables that are loaded from databases at runtime (often in multiple steps). For debugging and analysis purposes… (Show more)
in Data Integration
Lucas Goncalez
Hello!   I'm trying to get a daily email with attachment, but the email attachment comes in mime type. Does anyone know if pentaho does not interpret the mime type attachment? In this case, the step does not return any attachments, even if there is one.   --> This is how the attachment looks in webmail.   --> his is how the attachment looks… (Show more)
in Data Integration
Load more items