Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds; generated 42 minute(s) ago.

  1. I did the same with a 6.x installation....

    I did the same with a 6.x installation. Everything was running fine for me so far, except the "autosize column" feature for the Excel writer step.
  2. Replies
    3
    Views
    3,093

    Some hints; Create a job that performs your...

    Some hints;
    Create a job that performs your basic action for one channel. Use parameters (job/transformation properties) for everything that should be dynamic. Pass down those parameters (done by...
  3. Just have a look to you ktr/kjb's by using any...

    Just have a look to you ktr/kjb's by using any test or XML editor. The target path/name is stored within, and will not be updated by moving just the file.
  4. Check your security settings (system...

    Check your security settings (system preferences). Allow your system to use software from non-verified sources. Otherwise, you are not able to run any kind of java based software.

    If you are in,...
  5. This is not really a filter - its an...

    This is not really a filter - its an aggregation/grouping. If you look ahead with this keyword - you will find for example the Group By as solution, or some other step from "Statistics". Or you can...
  6. Get it working for me (5.0.1 and 4.4.0) by...

    Get it working for me (5.0.1 and 4.4.0) by replacing SWT.jar with 4.22 . See my comment in Jira.
  7. Replies
    5
    Views
    1,335

    I'm not shure how usefull a cube with this amount...

    I'm not shure how usefull a cube with this amount of measures will be or the design of your solution fits well - but thats not the point. Are these 1k base measures? Or already including calculated...
  8. Replies
    5
    Views
    2,136

    The cmdexec step entry does not allow to write...

    The cmdexec step entry does not allow to write some shell scripts. You have to redirect it trough cmd.exe as parameter /C. For example, put something like this inside: "C:\Windows\System32\cmd.exe /C...
  9. Replies
    1
    Views
    902

    Hmm, can you provide some more information? ...

    Hmm, can you provide some more information?

    What amount of data are you moving? (Example: 16 hours to copy 100TB of rdbms data is ok to me ;-) )
    How do you dump to target? Table output,...
  10. Replies
    16
    Views
    18,770

    You don't realy need to use the bulk load...

    You don't realy need to use the bulk load utility. You can load as well with the "load data infile" statement by using the execute SQL step. I think this is the way that toad runs. This is an simple...
  11. Replies
    16
    Views
    18,770

    There are multiple possibilities. Comparing a...

    There are multiple possibilities. Comparing a "bulk load" to a transactional ("table output") way of loading is not fair. Bulk loaders will normaly not update indexes during loading, loading without...
  12. Ensure that your JVM configuration (see...

    Ensure that your JVM configuration (see spoon.sh/bat) is ok for your available memory. Are you unsing the sun JRE?
  13. Replies
    16
    Views
    18,770

    With enabled "Use batch update for inserts", you...

    With enabled "Use batch update for inserts", you can usually reach a troughput of some thousend records per seconds an a basic infrastructure. Optimizing can be done with ajusting the commit size...
  14. Replies
    2
    Views
    1,588

    Poll: You have to install the JDBC driver manualy. Many...

    You have to install the JDBC driver manualy. Many JDBC drivers are no longer included in the official distriution due stupid license restrictions.
  15. Send "True" rowset to dummy step (for example),...

    Send "True" rowset to dummy step (for example), and attach your "set of transformations" to this one. Ensure that the dummy step will copy all rows - instead of distributing (right click on it to...
  16. Replies
    3
    Views
    1,138

    Salut beatrix Peut-être, c'est mieux de poser...

    Salut beatrix
    Peut-être, c'est mieux de poser ton question en anglais ici :D

    You can get what you need with one single transformation - containing for example the following steps (;
    -CSV Input...
  17. What about this one?...

    What about this one?
    http://www.pentaho.com/download/

    Linked directly from the main page as "Explore Pentaho". This way you can play with the enterprise version pentaho - and you'll get a...
  18. Some links that may interrest you:...

    Some links that may interrest you:
    http://rpbouman.blogspot.ch/2011/05/using-tidy-to-clean-webpages-with.html
    https://github.com/gkfabs/Kettle-jsoup

    One personal remark about "
    Parsing...
  19. http://forums.pentaho.com/showthread.php?128890-Go...

    http://forums.pentaho.com/showthread.php?128890-Google-Analytics-in-Penthaho-ETL-4-2-version-CE-not-working
  20. Database join step...

    Database join step should do what you are looking for. Otherwise - try stream lookup instead of the merge join step, but this can be painfull when working with huge datasets.
  21. The send mail step needs this information in the...

    The send mail step needs this information in the rowset. In other words, if you can't select the field of the rowset in the dropdown box - it will not work if you type anyting else in there. Try with...
  22. Replies
    4
    Views
    2,261

    This will normaly work fine. Are you shure that...

    This will normaly work fine. Are you shure that your target table does allow null values in those fields? And please send your log output.
  23. Why didn't you use the "mod_log_sql" module for...

    Why didn't you use the "mod_log_sql" module for your apache instance? This one will allow you to log your apache straight to a database instead of the classic logfile - in realtime.
  24. FYI; This case already exists in Jira:...

    FYI; This case already exists in Jira:
    http://jira.pentaho.com/browse/PDI-7302
    http://jira.pentaho.com/browse/PDI-7942

    There is a lot of usefull information in the comments.

    Normaly, this can...
  25. http://jira.pentaho.com/browse/PDI-7069

    http://jira.pentaho.com/browse/PDI-7069
  26. Replies
    10
    Views
    7,874

    I don't think that it worked already this way-...

    I don't think that it worked already this way- you have to set user&pw as well
  27. What kind of step is used to execute? When using...

    What kind of step is used to execute? When using the "Execute SQL script" step, tick the "execute as single statement" box. Otherwise, pdi will split your script by the "; -> seperator" and execute...
  28. Replies
    2
    Views
    1,255

    With the given information - its impossible to...

    With the given information - its impossible to answer your question.

    How did you execute pan?
    Maybe this thread may help you.
  29. Stellenausschreibung Schweiz; Open Source BI-Engineer 80 – 100%

    Weitere Informationen:
    http://www.basis06.ch/jobs.html

    Bei Interresse die auf der Seite verlinkten Kontaktdaten verwenden.
  30. Replies
    10
    Views
    7,874

    If you are working with a repository - don't...

    If you are working with a repository - don't provide the "file" argument, use dir & job (kitchen) or dir & trans (pan) instead to point to your item inside the repository.

    Further, you just need...
  31. How did you connect your logging step? Still by...

    How did you connect your logging step? Still by the error handler? If yes - change this to my suggestion by using outer join->filer->log with just the rowset (without any error handler).
  32. Do you realy want to sync - or you need just an...

    Do you realy want to sync - or you need just an external authentication against your AD?
    If you just need to authenticate, check this:...
  33. Matt is right - the current step is realy...

    Matt is right - the current step is realy outdated. Google stopped the old API at the end of june 2012. Even the link on the step to "Dimension and Metrics Reference" is no longer valid.
  34. Replies
    4
    Views
    1,519

    What is your setup? Standalone PDI without...

    What is your setup? Standalone PDI without Repository?
  35. You're close to a working solution; "do not pass...

    You're close to a working solution;
    "do not pass the row if lookup fails" flag means, that te lookup step will do a "inner join", and return only rows with a existing entry in your smaller table....
  36. Hi matt, thanks for your input. At the moment,...

    Hi matt, thanks for your input.
    At the moment, both are running as root for get shure that there are no issues with that. The target database is just a temporary storage, daily truncated and not...
  37. Magic error when running job by cron (Get XML Data Step)

    Hi all

    I'm having a magic issue when running a job nightly by cron(tab) an debian linux.


    Running the job manual by shell with kitchen works fine. But running exact the same job (same starter...
  38. Replies
    3
    Views
    1,473

    What about using a repository? This is the...

    What about using a repository? This is the "official" way for a central connection management.

    About your second point. Choosing "generic database" is a possible way to set all database properties...
  39. Replies
    11
    Views
    1,906

    Hmm, this is a nasty case. What about that...

    Hmm, this is a nasty case.

    What about that think;
    -Calculate the period in a number of days.
    -Divide the consumption by this value - you get now the daily consumption
    -Start a second rowset...
  40. Great idea, i did it right now. See PDI-8418

    Great idea, i did it right now. See PDI-8418
  41. I think this may also depend on the mysql version...

    I think this may also depend on the mysql version - they did some incompatible changes and added some internal locking in version 5.5, based on the bugs of wrong slave sync due wrong order of the...
  42. I don't think that you realy understood the...

    I don't think that you realy understood the concept. In general, a job controls your workflow, a transformation controls a rowset. The required "loop" is nothing else than a rowset inside a PDI...
  43. Replies
    3
    Views
    13,421

    Looks great! - will give it a try in the next...

    Looks great! - will give it a try in the next weeks.
    What about the support for the current pentaho releases?
  44. Execute it by using kitchen and log to file.. ...

    Execute it by using kitchen and log to file..

    But wait, with the error handler, you should be able to identify the 2 rows that are failing? Why not to filter on these two and run the...
  45. I think the "fieldname" in the error handler...

    I think the "fieldname" in the error handler depends on the jdbc driver - or in other words on the connected database type.

    Running the tranformation with the loglevel "Rowlevel" may help..
    ...
  46. Try it without the "Result Streaming Cursor"...

    Try it without the "Result Streaming Cursor" (check database connection dialog). This one is realy nasty when using the insert/update step against mysql.
  47. Writing a CSV; Enclosures are also applied to to the header row - right or wrong?

    We had a fun discussion over here today about the way the "Table Output Step" does handle enclosures, for example ".
    If you generate a CSV with PDI (in my case 4.3.0) containing a header row, the...
  48. Replies
    4
    Views
    1,738

    ..and tick the "Specify database fields" checkbox...

    ..and tick the "Specify database fields" checkbox on your table output step. This one is a little bit confusing for newbies..
  49. What about ? Can you connect to the remote...

    What about ?

    Can you connect to the remote host & port f.e. by using telnet?
  50. Replies
    1
    Views
    1,393

    What kind of installation was this? Manual...

    What kind of installation was this? Manual deployment (with ant)?
    There are several ways to redirect tomcat. The most used way is to forward from webapps/ROOT/index.jsp.

    If you choose this way,...
Results 1 to 50 of 65
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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