"Fri" cannot be parsed when not in the right locale.
Type: Posts; User: jbleuel; Keyword(s):
"Fri" cannot be parsed when not in the right locale.
we added SAP HANA support as a native database dialect in version 5.4. When you are using the trial version, please check with your representative and/or support on this topic.
FYI: Nelson created a survey to collect location preferences for the next PCM.
The exact date is still undecided but it'll probably be November 7, 14 or 21, so as to not clash with Pentaho World...
We got more and more requests of adding meta data injection functionality into further steps.
I would be interested in the use cases that drive this functionality, so we could document this...
Started basic documentation:
Added an (almost) working sample (tested on 5.0.6) to http://jira.pentaho.com/browse/PDI-12204
Thanks a lot for sharing this!
I added this information into our Wiki: http://wiki.pentaho.com/display/EAI/SAP+Input
Since this is an Enterprise Edition feature, I assume you are a customer. Please contact Pentaho customer support to follow up.
Uwe, please file a bug in JIRA. Thanks, Jens
Looks like the zip does only contain a ktr not the XML... could you double check?
I'll attach it then to the case.
FYI: bug report over here: http://jira.pentaho.com/browse/PDI-10116
FYI: Looks like a bug, see http://jira.pentaho.com/browse/PDI-10113
The Enterprise Edition of PDI has user control access in the EE Repository and since PDI 4.4 also the PDI Operations Mart for log monitoring. More monitoring features are on the road map.
Change the KETTLE_HOME variable, see:
It's a known issue: http://jira.pentaho.com/browse/PDI-8857
and fixed in the upcoming 4.4.1 / 5.0
It is still on svn://source.pentaho.org/svnkettleroot/Kettle/trunk
The move to github will be later this year. We will announce it on the Kettle developer mailing list.
see also our PDI SDK in...
Since PDI 4.4, you can also use the Concat Fields step, see http://wiki.pentaho.com/display/EAI/Concat+Fields
Thanks for the bug report!
This doesn't look like a known issue in JIRA.
Please create a bug report for this: http://jira.pentaho.com
Bug Reports and Feature Requests FAQ is over here:...
FYI: We got another case that might be related: http://jira.pentaho.com/browse/PDI-8998
FYI: This is the JIRA case: http://jira.pentaho.com/browse/PDI-8998
Quick FYI: Since PDI version 4.4 they are included in the Enterprise Edition without the need for an extra download.
Quick FYI: Have a look at
As an ETL developer I want to have built-in support for load balancing in Kettle transformations
Thanks & best regards,
FYI: The below code works with and without Lazy conversion, mode details can be found on
FYI: JIRA case is over here:
I like the idea of lightning talks and plan to have a talk about something out of the ordinary related to Kettle :-)
The working title: "I don't know, yet if it will work with Kettle"
Even when it...
We are collecting talk proposals over here: http://forums.pentaho.com/showthread.php?97707-2012-Pentaho-Community-Gathering-Talk-Proposals
the same procedure as last year: Just setting up a quick thread where people can submit proposals for talks at this years Pentaho Community Gathering in Amsterdam. Add stuff to this...
A high-level overview is here: http://www.pentaho.com/explore/packages/
Since you are EE customer, it is best to reach out to the support portal and check with Pentaho support or services....
What type of repository are you using? Database or Enterprise Edition?
How did you export / import your transformations / jobs?
Any chance of getting a sample for reproduction?
Have a look at
Have a look at the http://wiki.pentaho.com/display/EAI/Sorted+Merge
I just added the use case to the doc and put a note on the Sort rows step about your use case.
Have a look at http://wiki.pentaho.com/display/EAI/Modified+Java+Script+Value
A workaround is to cast into a string or other numeric data type.
See also feature request: http://jira.pentaho.com/browse/PDI-7103
Have a look at:
Great, thanks for the feedback.
We will add it to the doc section.
The latter is correct: "just by adding this parameter the transformation will attempt to use Passive mode for ftp when ever it is using VFS"
Try it this way: http://infocenter.pentaho.com/help/topic/pdi_user_guide/reference_vfs_params.html
in combination with http://wiki.apache.org/commons/VfsFaq
might be working with the parameter...
In the left hand tree: View/Explorer right click on database connections and select from the context menu: "New"
PostgreSQL is available by default
Neo4j: you need to use the generic driver and add...
I would check the Oracle driver version and tweak the JDBC driver properties. We are reading from the JDBC as fast as it comes in, so I believe JDBC / network / database - one of them or a...
Data Quality: http://wiki.pentaho.com/display/EAI/Data+Quality+Integration+Home
all can be found her:...
Data Profiling was already possible in an easy way with Kettle: Open the Database Explorer, chose a table and right click in the context menu on Data Profile. The result was basic information about...
The following could be interesting if you are a Data Scientist and want to work on a contest:
Kaggle was rewarded by Mashable as one of five companies to make a global impact.
See "Trigger-Based CDC" over here: http://wiki.pentaho.com/display/EAI/Change+Data+Capture+%28CDC%29
Ad 1: Use the Table Input step with the option "Insert data from step" and execute for every input row.
Ad 2: see "Trigger-Based CDC" over here:...
Just created the DB2 bulk loader step feature request: http://jira.pentaho.com/browse/PDI-7599
Just tested this with success with a transformation (PDI 4.2.1). See attachment to http://jira.pentaho.com/browse/PDI-2663
e.g. with the URL:...
The simple-jndi/jdbc.properties file is to enable JNDI at the client side (Spoon). This is normally done, when there is a plan for a deployment to an application server (e.g. the DI Server) later on....
Have a look at Pan (running a transformation) or Kitchen (running a job):
Have a look at http://wiki.pentaho.com/display/EAI/Lifecycle+Management
and links at the end of the article:
Automated Repository Export: See the job entry Export repository to XML file (this can...
It would be great to get feedback about the performance differences you got with the number of rows.