Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: sboden; Keyword(s):

Page 1 of 98 1 2 3 4

Search Forums: Search took 0.07 seconds.

  1. Replies
    6
    Views
    2,003

    Start by reading...

    Start by reading http://wiki.pentaho.com/display/EAI/JavaScript+Values
    At the end is an example using the "old style".

    Regards,
    Sven
  2. Replies
    5
    Views
    6,287

    Sure... you can use full java capability in...

    Sure... you can use full java capability in javascript, look under samples/transformations for the javascript samples... there are some that do some more complex stuff.

    But I wouldn't suggest to...
  3. Replies
    3
    Views
    4,539

    I made a small test.kjb on the root of d:\......

    I made a small test.kjb on the root of d:\... Then this works:

    kitchen /file:d:/test.kjb /level:basic

    Whether to use / or - you can know by running the script without arguments. One thing I can...
  4. Replies
    6
    Views
    4,900

    "Problem" is in the 3rd party library PDI uses to...

    "Problem" is in the 3rd party library PDI uses to read/write excel files. It's not provide a 100% solution for all Excel functionality.

    Regards,
    Sven
  5. Replies
    3
    Views
    1,321

    Is the userid to ftp the same in PDI as the one...

    Is the userid to ftp the same in PDI as the one you use to manually ftp?
    Maybe the access rights on the files are causing your problem.

    Regards,
    Sven
  6. Replies
    3
    Views
    2,352

    Logging changed quite recently. Regards, Sven

    Logging changed quite recently.

    Regards,
    Sven
  7. From the wiki:...

    From the wiki: http://wiki.pentaho.com/display/EAI/Oracle

    Regards,
    Sven
  8. Replies
    3
    Views
    1,104

    You can raise a JIRA for it. I remember once that...

    You can raise a JIRA for it. I remember once that there were encoding problems with excel on unix.

    Regards,
    Sven
  9. Replies
    6
    Views
    1,348

    To the log file there is a job entry for it. ...

    To the log file there is a job entry for it.

    In general ETL runs unattended somewhere in the middle of the night and people check the logs. In all cases (if you would run manually as well) the...
  10. Either a bug or you're doing something weird......

    Either a bug or you're doing something weird... Try to describe it in a repeatable way and make a JIRA for it.

    Regards,
    Sven
  11. Thread: C code

    by sboden
    Replies
    2
    Views
    964

    You can add c but it's not for the faint of...

    You can add c but it's not for the faint of heart... the PDI database classes contain a list of valid keywords per database type and if you add yours there, you should be fine.

    Alternatively you...
  12. Replies
    5
    Views
    2,118

    Which documentation did you look at it? For...

    Which documentation did you look at it?

    For the rest: open up in PDI the transformation samples/transformation/Stream lookup - basics.ktr from within the spoon installation. And additionally use...
  13. not really I think: ORA-12519: TNS:no...

    not really I think:



    ORA-12519: TNS:no appropriate service handler found
    *Cause: The listener could not find any available service handlers that
    are appropriate for the client connection.
    ...
  14. To do restarting in a general way is too complex....

    To do restarting in a general way is too complex. You want to do restarting you need to do it yourself :D

    Regards,
    Sven
  15. Replies
    2
    Views
    2,152

    Kettle supports any language in UTF8, which is...

    Kettle supports any language in UTF8, which is ... well... about everything ;)

    For MySQL you need to set the encoding to UTF8 ... search this forum for MySql and UTF8, it came up a "couple" of...
  16. Replies
    2
    Views
    2,888

    It doesn't work like that.... you put the jar...

    It doesn't work like that.... you put the jar files right.

    Then select generic database from the list and fill out the details on the right.

    Regards,
    Sven
  17. 1) "recursive" ftp is problematic, ftp is not an...

    1) "recursive" ftp is problematic, ftp is not an explorer session in which you can copy and paste
    2) works for me. anymore messages? can you ftp manually from the same computer on which PDI runs on....
  18. Replies
    4
    Views
    3,684

    Test and let us know :D ... personally I like...

    Test and let us know :D ... personally I like landing data (making files out of them) and starting from there, but in theory your option 2 should be faster.

    Another options is to write an oracle...
  19. Replies
    13
    Views
    2,841

    The future is not fixed ;) ... haven't seen an...

    The future is not fixed ;) ... haven't seen an intention to build it in yet.

    The problem is not in the dynamic meta-data itself, the problem is in how steps after that should react... most of the...
  20. Replies
    13
    Views
    2,841

    Not for the faint of heart... you can execute...

    Not for the faint of heart... you can execute dynamic queries but the problem is in the meta-data. PDI likes static meta data (v3.2). So if you always want to extract the same columns of data from a...
  21. Replies
    1
    Views
    1,837

    Why decompile when you have the source code......

    Why decompile when you have the source code... this should solve the last error you got.

    For the first error... what about an english translation of the error. First guess would be that you...
  22. Replies
    3
    Views
    1,038

    For the original poster... The "test value test...

    For the original poster... The "test value test value ... " is a result of using the test script button... don't use that one (in newer version of PDI the test script button is more advanced).
    ...
  23. Replies
    7
    Views
    23,175

    It's created when you start PDI. Regards, Sven

    It's created when you start PDI.

    Regards,
    Sven
  24. Replies
    3
    Views
    1,259

    The piece in the first post doesn't work as it...

    The piece in the first post doesn't work as it only sets the local variable.... follow biuri

    Regards,
    Sven
  25. Replies
    2
    Views
    1,241

    Right click on the function in the left windows...

    Right click on the function in the left windows and click sample... you will get a small sample usage script.

    Regards,
    Sven
  26. Replies
    3
    Views
    1,314

    You can specify the target encodings, forcing...

    You can specify the target encodings, forcing MySQL to do the required code-page conversions.
    This is possible in the Options tab of the database dialog. Hit the "help" button in there to go to the...
  27. Replies
    8
    Views
    4,740

    And what do you get as trace messages? ...

    And what do you get as trace messages?

    Regards,
    Sven
  28. Replies
    1
    Views
    2,027

    The rest of PDI is not "meta-data dynamic" so it...

    The rest of PDI is not "meta-data dynamic" so it would not buy you much ;)

    Regards,
    Sven
  29. Replies
    5
    Views
    2,087

    Show us what you've got sofar... attach your...

    Show us what you've got sofar... attach your .ktr/.kjb files.

    Regards,
    Sven
  30. Replies
    2
    Views
    1,153

    Has been discussed a number of times on these...

    Has been discussed a number of times on these forums ;)

    If you want to use multiple types of databases this is possible through "generic driver" but then we take away the database specific...
  31. Replies
    3
    Views
    1,314

    Use the extra options in the database connection...

    Use the extra options in the database connection dialog.
  32. Replies
    1
    Views
    1,189

    For strings/numbers it's easy to visualize...

    For strings/numbers it's easy to visualize preview... no idea what kind of preview you want on binary data... the hex values?

    Regards,
    Sven
  33. If you're sure you found a bug file a report at...

    If you're sure you found a bug file a report at http://jira.pentaho.org/browse/PDI

    And version numbers are also nice of course... of PDI, of MySQL, jdbc driver version, ...

    Regards,
    Sven
  34. Replies
    2
    Views
    1,846

    On its own PDI/Kettle does not provide in...

    On its own PDI/Kettle does not provide in callabel webservices. Integrated with the Pentaho stack you can use xactions to execute transformations/jobs. But other people than me have more experience...
  35. Have a look at the source code... from memory......

    Have a look at the source code... from memory... all crammed together.

    Regards,
    Sven
  36. Replies
    7
    Views
    11,570

    And now for - An example transformation - The...

    And now for
    - An example transformation
    - The complete log file you get

    Regards,
    Sven
  37. Basically that's pretty much it... Next step...

    Basically that's pretty much it... Next step would be to parallellize stuff. Starting up e.g. your stream 2 times... each half doing half of the files. But here it usually gets tricky :) ... things...
  38. Replies
    3
    Views
    1,267

    The path fields of "get xml data"/xml input are...

    The path fields of "get xml data"/xml input are variable sensitive.

    Regards,
    Sven
  39. Replies
    4
    Views
    2,950

    One caveat ... you can't use a variable in the...

    One caveat ... you can't use a variable in the same transformation as where you set it :D
  40. Replies
    3
    Views
    3,054

    If 1 builder can make a wall in 8 hours, 2...

    If 1 builder can make a wall in 8 hours, 2 builders can make the same wall in 4 hours, 4 builders can make it in 2 hours... not :D

    The proper database connection takes some overhead, and maybe you...
  41. Replies
    4
    Views
    2,950

    That's not in. You could use the same variable...

    That's not in. You could use the same variable e.g.

    Regards,
    Sven
  42. Replies
    1
    Views
    1,035

    db lookup

    db lookup
  43. Thread: If-else

    by sboden
    Replies
    2
    Views
    1,292

    filter step e.g.

    filter step e.g.
  44. Replies
    1
    Views
    877

    Raise a JIRA for it. Regards, Sven

    Raise a JIRA for it.

    Regards,
    Sven
  45. the filenames get added to the a list, which is...

    the filenames get added to the a list, which is accessible from the job executing the transformation.

    Regards,
    Sven
  46. Replies
    5
    Views
    2,131

    db join step?

    db join step?
  47. Replies
    6
    Views
    14,465

    It's not encryption, but obfuscation. But apart...

    It's not encryption, but obfuscation. But apart from that... no. Although it's pretty easy to make.

    Regards,
    Sven
  48. Thread: Throttling Step

    by sboden
    Replies
    5
    Views
    1,503

    There's one in construction, but don't hold your...

    There's one in construction, but don't hold your breath until then :D

    Sven
  49. Replies
    3
    Views
    1,533

    How do you set the variable... via a parameter in...

    How do you set the variable... via a parameter in spoon?

    Regards,
    Sven
  50. Replies
    2
    Views
    2,059

    There's not really a good way. PDI assumes that...

    There's not really a good way. PDI assumes that meta-data is "static".

    Regards,
    Sven
Results 1 to 50 of 4898
Page 1 of 98 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.