Search Forums:

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.
further...

Change the KETTLE_HOME variable, see:
http://infocenter.pentaho.com/help/topic/pdi_user_guide/concept_pdi_usr_changing_the_pdi_home_dir.html

Cheers,
Jens

It's a known issue: http://jira.pentaho.com/browse/PDI-8857
and fixed in the upcoming 4.4.1 / 5.0

Cheers,
Jens

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

Cheers,
Jens

FYI: http://jira.pentaho.com/browse/PDI-9152

Thanks for the bug report!
Jens

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.

Cheers,
Jens

Quick FYI: Have a look at
http://jira.pentaho.com/browse/PDI-7924
As an ETL developer I want to have built-in support for load balancing in Kettle transformations

Thanks & best regards,
Jens

FYI: The below code works with and without Lazy conversion, mode details can be found on
http://jira.pentaho.com/browse/PDI-8290




import org.pentaho.di.core.row.ValueMetaInterface;
...

FYI: JIRA case is over here:
http://jira.pentaho.com/browse/PDI-8222

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

Hi Guys,

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?

Thanks,
Jens

Have a look at
http://wiki.pentaho.com/display/EAI/Synchronize+after+merge

HTH,
Jens

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.

HTH,
Jens

Have a look at http://wiki.pentaho.com/display/EAI/Modified+Java+Script+Value

HTH,
Jens

A workaround is to cast into a string or other numeric data type.
See also feature request: http://jira.pentaho.com/browse/PDI-7103

Cheers,
Jens

Have a look at:
http://infocenter.pentaho.com/help/topic/pdi_user_guide/topic_scheudling_scripting.html

HTH,
Jens

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...

CDC: http://wiki.pentaho.com/display/EAI/Change+Data+Capture+%28CDC%29
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.

Kaggle hosts...

See "Trigger-Based CDC" over here: http://wiki.pentaho.com/display/EAI/Change+Data+Capture+%28CDC%29

HTH,
Jens

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

Cheers,
Jens

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):
http://wiki.pentaho.com/display/EAI/Pan+User+Documentation
http://wiki.pentaho.com/display/EAI/Kitchen+User+Documentation
...

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.

Thanks,
Jens

It simply depends if it is signed or not :-)

A Java long is always signed, so a MySQL bigint signed will fit into this. But an unsigned will not fit into this, this is why we map to a BigDecimal /...

I assume you mean BigNumber (what is internally a BigDecimal).

Have a look at http://azagorneanu.blogspot.com/2011/07/javamathbigdecimal-performance.html
there are numbers for tests of Double...

Looks similar to http://jira.codehaus.org/browse/JANINO-128
but this one is supposed to be fixed in Janino 2.5.16 (what is distributed by PDI 4.2.x) http://dist.codehaus.org/janino/changelog.html
...

FYI:
Good background: https://community.jboss.org/message/178158?_sscc=t
Another good web find: https://issues.apache.org/jira/browse/IBATIS-535

I created a feature request for this:...

Looks like http://jira.pentaho.com/browse/PDI-5595
Feel free to follow up on the mentioned JIRA case.

Cheers,
Jens

Thanks for filing the JIRA case.

Is there any change to get more information to reproduce or nail this down, e.g. is there a special sequence of open/closing dialogs, open/closing...

Have a look at http://jira.pentaho.com/browse/PDI-7081

Cheers,
Jens

Thanks all for the great insights. In combination from the customer feedback we got, we will go with supporting SNMP at first and see if the JMX user stories come in the future.
Feel free to add...

Please see http://jira.pentaho.com/browse/PDI-6518

We need a better repro path.

For the new release we will add a couple of monitoring features and we would like to get your feedback to the following questions.

These questions apply most to larger enterprises, but feel free...

see also http://jira.pentaho.com/browse/PDI-6677