Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    0
    Views
    569

    Best Linux + install instructions

    Which Linux distribution is best to install Pentaho (community, everything = BI server + PDI)? And where are clear and complete install instructions for community edition on Linux?
  2. Anybody knows why on Sourceforge the folder 'Data...

    Anybody knows why on Sourceforge the folder 'Data Integration' only goes to 7.1 and the 8.0 and 8.1 folders don't contain a separate 'data integration' folder?
  3. Originally I am going through...

    Originally I am going through community.pentaho.com and then I end up here:
    https://community.hitachivantara.com/docs/DOC-1009931-downloads
    When I click 'all OS' for PDI, then I get the [*&%$]...
  4. I think I find the answer myself? Sourcforge:...

    I think I find the answer myself? Sourcforge:
    https://sourceforge.net/projects/pentaho/files/ ?
  5. How to download Pentaho Community anonymously?

    I notice that when I want to download the community edition of Pentaho BI server, suddenly I am forced to give my information. I and my employees don't want to do this. Also I think it's against the...
  6. Replies
    1
    Views
    506

    Does the BA Server include PDI?

    Since the new Vantara Community site to me is one of the most terrible and unusable sites ever, I fail to find a clear overview of what is in the BA Server package. So far I have been using only PDI,...
  7. I have the same question. I have a server with...

    I have the same question. I have a server with CentOS, but that seems to be more because my hosting provider is basically into web hosting and CentOS is popular with web hosting. I look for some...
  8. Replies
    10
    Views
    2,154

    Thanks Sparkles for the suggestion. You mean...

    Thanks Sparkles for the suggestion. You mean these as steps in the transformation?

    What I see it often stops at the end of the transfomation. I appears as if Pentaho fails to process the result...
  9. If you get this as a valid date, perhaps you...

    If you get this as a valid date, perhaps you should look into parsing dates without time zone info? Basically each time exists in GMT and any related time zone without Winter Time / Summer Time...
  10. Replies
    1
    Views
    661

    This sounds like an issue I have on a Windows box...

    This sounds like an issue I have on a Windows box with PDI 7. What does the logging of individual transformations say?
  11. Replies
    10
    Views
    2,154

    gutlez, thank you for the useless comment. I...

    gutlez, thank you for the useless comment. I can't do anything with the "(t)here it runs perfectly" smugness. Here it's UNstable and I am looking for people that make a constructive contribution to...
  12. Replies
    2
    Views
    478

    I have different issues with running jobs. Your...

    I have different issues with running jobs. Your error message suggests you have an authentication issue somewhere.
  13. Replies
    10
    Views
    2,154

    How much data are we talking about with you? The...

    How much data are we talking about with you?
    The cient just chose to go to SSIS after months of this issue. For me it is if I can decently promote PDI when it is this unstable.
  14. Replies
    10
    Views
    2,154

    Jobs stop for no reason

    My client has a Windows Server 2012 R2 box with SQL Server 2016. We use PDI 7. The loads are run from Windows scheduler. It happens quite often that PDI stops somewhere in a job for no apparent...
  15. Replies
    15
    Views
    1,257

    The steps are the code, I really don't see your...

    The steps are the code, I really don't see your point. When I use a lookup step, I add 3-4 variables and I'm done. I think you just have an issue letting go of coding. I see no point in trying to...
  16. Replies
    15
    Views
    1,257

    Sorry, but what advantage does object orientation...

    Sorry, but what advantage does object orientation have with shared (e.g. conformed) dimensions? Typically you lookup the data warehouse key of your dimension with the business key from your stream....
  17. PDI keeps complaining about data type conflict

    I am doing a database join in PDI 7 on SQL Server 2016. It keeps whining about a type conflict between the field from the database that is used for the lookup in relation to the string field. I have...
  18. I already have sub jobs already. This is no...

    I already have sub jobs already. This is no longer sustainable as I have 30+ hubs, links and sats (per type). And I have about 90 staging tables of one source to fill. Is there a way to get a list of...
  19. Replies
    15
    Views
    1,257

    Which similarities do they share?

    Which similarities do they share?
  20. Never mind, it is a join clause issue. Ignore...

    Never mind, it is a join clause issue. Ignore this thread of shame.
  21. Merge join step messes up with left outer join?

    I use PDI 7 on SQ ver 2016. When I run a merge join with a left outer join where the sorted list 'right' starts earlier in the sort than 'left', it totally messes up and fails to make any successful...
  22. Anybody from the 100 viewers?

    Anybody from the 100 viewers?
  23. Replies
    15
    Views
    1,257

    I can't comment on the debug and testing part as...

    I can't comment on the debug and testing part as I am not a Java developer. As for object oriented, I see no added value for working with data to fill data warehouses. I think from the problem I have...
  24. Amazing! I can run a fresh PDI install after this...

    Amazing! I can run a fresh PDI install after this one magic command on my MacBook!
  25. Best way to handle many parallel transformations in a job

    I am building a Data Vault load with PDI. Since Hubs first, and then Links and Satellites can be loaded in parallel or at least in random order, I have jobs that contain a START and SUCCESS with a...
  26. Replies
    15
    Views
    1,257

    If you are a coder, rebuild all yourself. When...

    If you are a coder, rebuild all yourself. When you want an understandable and optimised solution, including its limitations, take a tool. For me I wouldn't want to code the more complex steps. I find...
  27. No, it's the sort step that gives the errors. The...

    No, it's the sort step that gives the errors. The GUI is right, there is a different amount of fields. I failed to drop one field that I thought would be dropped because its value is used to replace...
  28. In my style of use of Kettle, the SQL button has...

    In my style of use of Kettle, the SQL button has little use. I usually map the fields from the stream that I need to the columns in the database. The SQL button works when you end up with a stream...
  29. Don't you just want to truncate the table? If...

    Don't you just want to truncate the table?

    If you want to make changes to the table, how do you want to do that in ETL? If it doesn't know beforehand which changes you want, you have to define...
  30. Transformation runs fine from Windows command line or scheduled job, fails from GUI

    I am debugging some issue in a transformation. When I run it in Spoon GUI, it fails because one step is getting different amount of fields from 2 input streams. This happens on both my Test and...
  31. I see that the Mac issues are still there? I keep...

    I see that the Mac issues are still there? I keep being amazed that at Pentaho / Vantara they don't get that also, or even more, on the Mac, PDI should run out of the box. Fiddling with configuration...
  32. Replies
    3
    Views
    1,057

    Thank you, this one works indeed the way I need....

    Thank you, this one works indeed the way I need. I see I have to add a dummy entry for 'error' as well for a job success result.
  33. Replies
    3
    Views
    1,057

    How to end transformation after a condition?

    I want to have a check on if a table is filled. Since I miss a step that checks on that (I can check on if a table or column exists, not if it's filled?), I do a Table Input with a count on the...
  34. Replies
    12
    Views
    4,593

    I went to this new 'forum'... Doesn't look like a...

    I went to this new 'forum'... Doesn't look like a forum to me. Is this also a great new Atlassian / Jira 'innovation'? I miss any topic list like real forums. I stick to this forum for now, with all...
  35. Replies
    33
    Views
    15,622

    I find the repositories.xml in the hidden...

    I find the repositories.xml in the hidden directory .kettle. Anybody know what to change so it works again?
  36. Replies
    33
    Views
    15,622

    I have a brand new MacBook Pro with a fresh PDI...

    I have a brand new MacBook Pro with a fresh PDI 7.1 install and also I can't connect now that somebody else is using the repository. This is a huge bug and I don't understand why they are doing so...
  37. What is the change to do for PDI 7? This section...

    What is the change to do for PDI 7? This section is missing from the current info.plist
  38. Replies
    33
    Views
    15,622

    It seems only one user can connect to the...

    It seems only one user can connect to the repository at once? It turns out my colleague is logged in...
  39. This is the default behaviour? Password is also...

    This is the default behaviour? Password is also admin?
  40. Replies
    33
    Views
    15,622

    And now on our development environment, for my...

    And now on our development environment, for my user, PDI also refuses to connect to the repository, without apparent reason. This in the crucial phase of a difficult migration. NOT...
  41. Replies
    33
    Views
    15,622

    Maybe that means that IE is blocking something?

    Maybe that means that IE is blocking something?
  42. Replies
    33
    Views
    15,622

    Will you please share your tweaks? My colleague...

    Will you please share your tweaks? My colleague can't connect to repository anymore also, the same issue. Since PDI is just new here at this client, it will seriously harm the use of PDI when she...
  43. Replies
    1
    Views
    725

    Anybody?

    Anybody?
  44. Replies
    1
    Views
    725

    PDI7 fails to start with missing SWT class

    I am trying to get PDI 7 to work on my old Mac beasty running Mac OS X 10.9.4. I have gotten it to see the latest official Oracle Java 8 (131), but now it complains it can't find the eclipse SWT...
  45. I guess it's a bug, so I reported it in Jira.

    I guess it's a bug, so I reported it in Jira.
  46. Sounds very plausible. Then how can I change the...

    Sounds very plausible. Then how can I change the transformation to use more memory? CPU is pretty much maxing out now. Is it effective to use more memory? Or is it a good sign that memory is stable...
  47. Thanks again for the feedback! I now run the...

    Thanks again for the feedback!

    I now run the transformation with Pan because Spoon seems to start to choke after 5-6 million rows or so. Memory use of the Java process now stays at roughly 1.461...
  48. I update the index and also change the number of...

    I update the index and also change the number of copies of the lookup step to 5. Now I see that input/output of most steps goes to something like 150/150 instead of 10000/10000. Speed (r/s) is...
  49. Now the performance drop stays with the link...

    Now the performance drop stays with the link lookup step. It uses 11 fields to retrieve the unique key. It's a data vault link, so the index is only used for ETL performance. It's also the only index...
  50. I just changed the max value to 2.560 Mb and that...

    I just changed the max value to 2.560 Mb and that seems to help. Now the performance drop goes back to the lookup of the link key. I doubled the copies of that step from 2 to 4, the other steps have...
Results 1 to 50 of 60
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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