Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Ana GH; Keyword(s):

Page 1 of 6 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. The Append stream step will do it for you, it...

    The Append stream step will do it for you, it will ask that the incoming streams have the same structure (fields name included) so you can previously use a Select values step if you need it for that....
  2. Replies
    4
    Views
    324

    I think MongoDB is not one of the officially...

    I think MongoDB is not one of the officially supported databases, so you'll probably have to make adjustments to make it work: https://www.helicaltech.com/audit-logs-in-pentaho-data-integration-pdi/...
  3. There was a horrible bug in 8.1 and that didn't...

    There was a horrible bug in 8.1 and that didn't work, but it's working for me in 8.2 (although the Excel input/output step had some bugs in 8.2 if I remember correctly, I'm using a later version that...
  4. I don't use Pentaho repository, I use a git...

    I don't use Pentaho repository, I use a git repository external to Pentaho, so from Pentaho point of view my transformations and jobs are in a external file system and need to be referenced with a...
  5. The log isn't stating a specific error, but I...

    The log isn't stating a specific error, but I would begin testing if PDI in script mode is having trouble to find the subjob files.
    1) Build a simple job calling another job that just doing some...
  6. Your questions are about how FTP works, not about...

    Your questions are about how FTP works, not about Pentaho, maybe installing a GUI tool for FTP like Filezilla would help, so you can navigate the directories to answer your own question. Once you...
  7. Do you need to use a specific protocol? FTP/SFTP...

    Do you need to use a specific protocol? FTP/SFTP is enough? Is one of the machines the one with Pentaho Data Integration installed or are both machines remote machines? Take a look to job steps under...
  8. Replies
    1
    Views
    767

    These blog entry has the instructions to create...

    These blog entry has the instructions to create your own docker image:
    https://diethardsteiner.github.io/pdi/2016/04/21/PDI-Docker-Part-1.html
    There are a lot of docker images in hub.docker.com...
  9. I think there are some java tools to do this,...

    I think there are some java tools to do this, that perhaps you can integrate in PDI. I remember reading someone doing it in another place, but I don't know the details, I just got shock of the...
  10. Replies
    3
    Views
    435

    @cool_runnings You are not specifying it, but I...

    @cool_runnings You are not specifying it, but I suppose you are using PDI logging tables in your own database? There's this old note about solving some locking issues when using the log tables in the...
  11. It depends. Splitting the column by semicolon...

    It depends. Splitting the column by semicolon into different columns if you are going to get always the same number of parts (or at least you know the maximum number), or splitting into different...
  12. I haven't seen it, but I remember seeing some...

    I haven't seen it, but I remember seeing some strange behaviour with the save daylight changes, so I wouldn't be surprised if you reschedule after the change, everything returns to normal.
    Regards
  13. Replies
    6
    Views
    519

    Hi Sparkles, I've tested it with 8.2 and I...

    Hi Sparkles,
    I've tested it with 8.2 and I reproduce the issue, so it's a safe example for Jira.
    Regards
  14. That's a creative way to upload a ktr when we are...

    That's a creative way to upload a ktr when we are not more allowed to attach files ;)
  15. Yep, 8.1 had some nasty bugs, so beware for some...

    Yep, 8.1 had some nasty bugs, so beware for some other unpleasant surprises, maybe downgrading 8.0 would be safer if 8.2 has that bug stopping you.
    Regards
  16. The buggy version with problems with variables...

    The buggy version with problems with variables was the Pentaho 8.1 version, Pentaho 8.0 and Pentaho 8.2 should be OK in that part.
    @zxx2403, sorry, I can't help with your problem, my tests migrating...
  17. Replies
    4
    Views
    426

    Yes, it's not straight forward to find. When you...

    Yes, it's not straight forward to find.
    When you open a transformation or a job with a database connection, you go to the left part with the two tabs: View and Design. In the View tab you have a...
  18. Replies
    4
    Views
    426

    There's an option to share connections, but you...

    There's an option to share connections, but you have to mark them as shared one by one, at least that's what I think, so for each connection you have to open a transformation or job that uses it, and...
  19. It should work, and going by the icons you are...

    It should work, and going by the icons you are working with a old version on Pentaho, so the variables bug of 8.1 shouldn't affect you. Try adding different steps printing the variable, for example,...
  20. Since they "encourage" us to move to the forums...

    Since they "encourage" us to move to the forums in Hitachi Vantara, it's not possible to attach anything to the forum, you can upload things to a external source such as google drive or whatever, and...
  21. Shouldn't make more sense to control whether the...

    Shouldn't make more sense to control whether the Table input (and the rest of the transformation) should run in a job? Create a transformation or a logic control in a job to determine if the...
  22. It seems strange the Merge join step didn't work,...

    It seems strange the Merge join step didn't work, I have used it myself other times. Maybe you need to specify the keys for the join, even if they are dummy keys like 1=1. The warning about the input...
  23. Or you could just use the Merge join step without...

    Or you could just use the Merge join step without any condition, or a dummy condition like 1=1. Provided that the second step only has one row (or you set up a Unique rows step previously to get only...
  24. I have tried with PDI 6.1, Java 1.8.0_191, Oracle...

    I have tried with PDI 6.1, Java 1.8.0_191, Oracle DB 12.2.0.1.0, JDBC Driver: ojdbc6.jar, and I can reproduce your problem. If you don't want to transform the TIMESTAMP columns to VARCHAR, you can...
  25. Replies
    4
    Views
    557

    Use the filter step in a transformation to set up...

    Use the filter step in a transformation to set up the WHERE with an OR condition.
  26. Well, you have your own answer, your company has...

    Well, you have your own answer, your company has been using CE edition for 13 years and you haven't had the need for the EE edition.
    I suppose for a company with employees which doesn't have a lot...
  27. Try with Java 1.8, I don't think 1.9 is supported...

    Try with Java 1.8, I don't think 1.9 is supported with any version right now.
    Regards
  28. Replies
    5
    Views
    1,013

    The message Resource not found it's stating that...

    The message Resource not found it's stating that the object Informe Detalle Incidencias SERPA SALUD.prpt isn't where you are trying to access it, it is supposed to be in a folder in the repository...
  29. Replies
    5
    Views
    1,013

    It seems like you have report bookmarked in your...

    It seems like you have report bookmarked in your favourites and you are accessing from there, but the report has been moved to another folder or has been deleted.
    Regards
  30. Look for it in case is possible, I think I saw it...

    Look for it in case is possible, I think I saw it was possible to show sections of the report conditionally, so you could show them different sessions depending on a parameter selected when you...
  31. Replies
    4
    Views
    541

    You'll might have to transform the dates, whether...

    You'll might have to transform the dates, whether in the transformation or while reading the date columns in the Table input step, instead of doing a SELECT * FROM table or SELECT col1 FROM table,...
  32. Replies
    6
    Views
    1,513

    You could implement a previous step changing the...

    You could implement a previous step changing the null value to a value that would be max, for example, ZZZ if it's a string column, or a string of 9 large enough if it's a number value, so it never...
  33. And wouldn't it work using the "Get variables"...

    And wouldn't it work using the "Get variables" step to add columns to the "Detect empty stream" and afterwards use the "Select values" step to use the columns of the "Get variables" step instead of...
  34. Replies
    6
    Views
    865

    I would try first with the Formula step, maybe...

    I would try first with the Formula step, maybe concatenating more than one formula step to create temporary columns to help me know if I need to add an extra | and in which position, it might be done...
  35. Replies
    6
    Views
    865

    If you are getting a malformed CSV with no...

    If you are getting a malformed CSV with no consistent number of fields you are not going to be able to implement an automatic procedure to organize a coherent output, you'll have to go manually row...
  36. Replies
    1
    Views
    657

    Pentaho Data Integration is a tool thought for...

    Pentaho Data Integration is a tool thought for Bulk Loads, so my idea would be to do all the inserts into P_TABLE in one transformation, and once finished, I would do another transformation to insert...
  37. http://lmgtfy.com/?q=pentaho+google+drive

    http://lmgtfy.com/?q=pentaho+google+drive
  38. Thank you, @johanjammink, I forgot that you can...

    Thank you, @johanjammink, I forgot that you can set it up specifically.
    Regards
  39. The kettle.properties is in the...

    The kettle.properties is in the /home/user/.kettle directory or the user running kettle, regardless of the path to the kettle software.
  40. Replies
    11
    Views
    1,032

    If what you are asking is if you'll be able to...

    If what you are asking is if you'll be able to create and modify the jobs and transformations in the linux box without a GUI (still not sure if that's what you are asking, you are not being clear on...
  41. Replies
    11
    Views
    1,032

    Why can't you install Pentaho Server on the linux...

    Why can't you install Pentaho Server on the linux box? Or at least install pdi-ce in the linux box and then move your transformations and jobs to the file system and schedule jobs and transformations...
  42. Replies
    4
    Views
    631

    http://type-exit.org/adventures-with-open-source-b...

    http://type-exit.org/adventures-with-open-source-bi/2010/08/accessing-previous-row-values-in-kettle/
  43. Replies
    1
    Views
    360

    So you have some text like this: Some text...

    So you have some text like this:
    Some text 19873458987 Some 03 other text 345899874858754893 more text
    And you want to extract 19873458987 and 345899874858754893 as employee_id because they are a...
  44. Replies
    2
    Views
    680

    What do you have after the dummy step when the...

    What do you have after the dummy step when the evaluation is false? If you create a hop to the End Success step the job would not finish as failed.
    Regards
  45. You create some logic to determine which...

    You create some logic to determine which separator the file is using, and then you inject the separator as metadata.
    Regards
  46. You can make up a job to test the transformation...

    You can make up a job to test the transformation just setting the variable value and then calling the transformation, without adding all the other steps the original jobs performs, if you need to...
  47. Hi Sylvain, You have the Automatic Documentation...

    Hi Sylvain,
    You have the Automatic Documentation Output step for something you can adapt for your own needs, but I suggest you google "Kettle cookbook" for something already made that it just works...
  48. Can't help you with the error, but developing...

    Can't help you with the error, but developing jobs in a newer version of Kettle than the server doesn't seem a good idea, I know with Pentaho Report Designer doesn't work without fiddling with the...
  49. Replies
    9
    Views
    984

    That's a hard input to treat, the standard answer...

    That's a hard input to treat, the standard answer would be "reject the file or the incorrect lines at least" you need to get a proper input with a defined structure to process it.
    Anyway, if the...
  50. Replies
    4
    Views
    809

    What is the pattern/logic to get the lines? Get...

    What is the pattern/logic to get the lines? Get lines 12, 13 and 14 whatever their content? Get lines when there is more than one consecutive non-empty line?
Results 1 to 50 of 283
Page 1 of 6 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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