Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    0
    Views
    621

    ACTIVE = 'iDLE' in Spoon when running KTR

    PDI 5.01 (I know...its old) - Oracle RAC 12C R1

    Moving years of work from MSSQL and MySQL to Oracle... when running specific transformations I often, not always, get Active = Idle for Status for...
  2. Replies
    1
    Views
    469

    DB Lookup step to table on linked server

    Hi -

    I can access table on a database on a sql server (2008) linked server in a [table input] step by "select * from linkedserver.dbname.owner.table"... how can lookup in the same table using a...
  3. Replies
    0
    Views
    657

    jtds and mssql linked servers

    Hope I'm missing something...

    Using JTDS connection to SQLServer 2008 server "Server B". "Server A" is a linked server to "Server B".

    I can use a Table Input step to select from a table in a...
  4. Replies
    2
    Views
    505

    thank you! that did it

    Thanks!
  5. Replies
    2
    Views
    505

    nasty problem.... possible?

    have a file with a multiple variable lines per record. the first two lines (line types l1 and l2) exist for each record, lines 3,4 and 5 (l3, l4, l5) may or may not exist (3 and 5 may exist on one...
  6. just saved my butt - thank you!

    just saved my butt - thank you!
  7. Replies
    2
    Views
    1,275

    another wildcard/regex issue

    I have a directory (on a win2.3k server) with multiple files, (1 per day) e.g.:

    \\myserver\mydir\a20100417bcdef.txt
    \\myserver\mydir\a20100418bcfgh.txt
    \\myserver\mydir\a20100419zbdef.txt

    or...
  8. Thread: PDI challenge

    by dogfuel
    Replies
    4
    Views
    1,442

    PDI challenge - thanks

    I am standardizing the dates using 00:00:00 as you suggest ... is the ordinal number what the "Add line number, restart in each group" intended to do? This does not seem to work (though it may be...
  9. Thread: PDI challenge

    by dogfuel
    Replies
    4
    Views
    1,442

    PDI challenge

    I have a table with a few million transactions, datetime, item and quantity attributes:

    2009-05-23 03:20:06; Shoes; 2
    2009-05-23 06:15:02; Shoes; 3
    2009-05-23 09:37:03; Gloves; 4
    2009-05-23...
  10. Replies
    1
    Views
    1,071

    help ... please help - Text File Input

    I am reading in large text files (logs) ... my first step reads a file listing input files and then the second step reads in the file lines - in some files, not all, the lines are truncated from 600...
  11. Replies
    0
    Views
    805

    scared - lines from text file chopped off

    I am reading in large text files (logs) ... my first step reads a file listing input files and then the second step reads in the file lines - in some files, not all, the lines are truncated from 600...
  12. What would be done to Kettle with a $3 million infusion of cash?

    Talend seems keyed up about their 12m round of financing. guessing 75% will go to marketing, what would be done to Kettle with 3m in development?

    (I thought Talend was an ok product - didn't...
  13. Replies
    20
    Views
    6,441

    competitors?

    There are several mentions of competitors of Pentaho in this thread ... as a user of commercially supported and os Jasper and Pentaho over the last few years, I have a slightly different vantage ......
  14. Help for those challenged ....

    Sorry to ask such a petty question, but what is wrong with the below?


    //Wed, 21 Jan 2009 02:41:31 +0000
    var dte = str2date(myDate.getString(), "EEE, d MMM yyyy HH:mm:ss Z");when I go to test...
  15. Replies
    1
    Views
    1,011

    is it me? 3.1 issues

    Hello -

    I am having problems with new installs of 3.1 on two different machines (debian and gentoo) ... on both machines, saving hangs up spoon (but the save does work). I have bumped up the ram...
  16. Replies
    4
    Views
    2,664

    perhaps against the law, but like speeding,...

    perhaps against the law, but like speeding, everyone feels they must occasionally do it.

    I'll play with the group by step.

    Thanks
  17. Replies
    4
    Views
    2,664

    ?

    I know a little SQL (borrowed the dummies book for a weekend) .... but I really prefer to just use the query builder in Excel and pull a giant dataset over the network so I can filter it to a few...
  18. Replies
    4
    Views
    2,664

    Count Rows that meet condition?

    When running a transformation, I need to count the number of rows that meet a condition. What is the most efficient way of doing this?

    Currently, I am outputing the rows to a database then...
  19. OK ... I'm slow (and still hunting for the best way to pass a connection)

    What is the best (simplest) way to select a connection name from a table and the use that connection in a transformation downstream? Would I be better off to store the parameters to use a generic...
  20. Replies
    1
    Views
    959

    Access Input - error

    I am trying import data from Access and receive an "Unrecognized data type: 89" error when I try to browse tables.

    Any ideas? Thanks
  21. Thread: Wierd one ....

    by dogfuel
    Replies
    1
    Views
    1,048

    Wierd one ....

    I have a job with a 'mail' step. the body of the mail is a variable.

    going in the value of the variable looks like "...ServletBroker&timestamp=Thu+Mar+16+10..." - I have confirmed this by writing...
  22. Replies
    4
    Views
    2,062

    I have an ongoing issue with "new" zip format

    The unzip functionality normally works fine for me - I do have one client who receives password protected files created with winzip 10.

    My problem is not with pentaho - wizip 9+ uses proprietary...
  23. Replies
    5
    Views
    5,892

    where each stands out (my limited exposure)

    DataStage - If you're into websphere or are deep in from the pre-IBM days good product but ...
    SSIS - if you're a .NET shop (even with non-sql server databases)
    Informatica - if you write...
  24. Replies
    0
    Views
    1,980

    PDI/Kettle wish list

    In 18 months, Kettle has grown from a cool tool for Edge Integrations to a world class integration tool. Ignoring economics, it is my choice over Informatica for ETL in every situation I can...
  25. Replies
    5
    Views
    1,371

    Thanks but ...

    Will this work if I need to store the the contents of the html file as a string? I am getting an error:

    Couldn't execute this script! Error on position (4:0) :
    Wrapped...
  26. Replies
    5
    Views
    1,371

    read entire file to field (ignoring lines)

    Hi -

    I am trying to read an entire html file, including line breaks, into a a field and cannot seem to do so with a text input ... it always breaks by line/row ... am I missing something?

    Thank...
  27. Replies
    0
    Views
    841

    Parsing XML String (not an XML Doc)

    Hello -
    I have a field coming through that contains an XML string. It is the message payload from a transaction processing system. The string looks a bit like:
    ...
  28. Replies
    2
    Views
    2,087

    Pentaho 3.0.1 on RHEL

    2.5.2 has been running fine on RHEL 4. I just installed 3.01 and get an error on an attempt to start spoon.

    Any suggestions? Thanks

    [xxxx@prdpentbi01 kettle.3.0.1]$ ./spoon.sh
    find:...
  29. Something like jedox worksheet server for limited mdm?

    Hi -

    Anyone know of a open source project with functionality similar to Jedox Worksheet-Server?

    I'm looking for a simple solution for user-maintained reference data to be picked up by Kettle...
  30. Replies
    1
    Views
    1,171

    Command line parameters for job

    I have had success and fun using PDI but have strugled with command line parameters.

    I need to pass a short string in and use this string in the where clause of a table input in the first...
  31. Replies
    1
    Views
    2,067

    Graphical enhancements

    even better if you could see some detail of the transformations in a job while viewing a job - but is just a wish list item ... even without it, PDI is a better solution than Informatica or...
  32. Replies
    0
    Views
    1,956

    join up, conquer the world, split the spoils

    The Pentaho vision and architecture continually amaze me with their depth.
    Kettle/PDI is unmatched in the commercial and open source domains
    The XACTION concept and Design Studio are the coolest,...
  33. returning results

    RE:
    "About passing information through, you can also get at the result of a transformation, if you use the "copy rows to result" as last step in the transformation."

    How would I then access the...
  34. one answer and same questions

    I'm working through a similar situation - I am evoking the job with an Pentaho xaction but also have questions about retuning the results (to an ESB tool) ... how is the return (a single record) most...
  35. Replies
    1
    Views
    1,524

    about after N failed attempts

    Hi -

    I need to exit a looping job after 5 failed attempt run the job inside the loop.

    The inner job succeeds or fails based on a touch file's existence.

    Before entering the loop I set a...
  36. Replies
    2
    Views
    1,201

    Thanks! I was ...

    ... suprised this works as well as it does - resource usage is minimal and I have continius integration!
  37. Replies
    2
    Views
    1,201

    launch kitchen with MySQL trigger???

    I have a MySQL 5 database with a table that receives records with a unique sequential key from a procedure beyond my control (an odbc insert).

    The insert volume is around 10 records per second...
  38. Replies
    1
    Views
    1,058

    parsing XML-like field

    I have a text field in my source that looks something like:
    "<f1>iVal1</f1><f2>iVal2</f2><f3>sVal3</f3>"

    I'm parsing the data (iVal1, iVal2 and sVal3) and putting them in fields f1, f2 and f3.
    ...
  39. Replies
    2
    Views
    1,384

    Thanks

    Thanks! Looks like it'll work well
  40. Replies
    2
    Views
    1,384

    enterprise job scheduler?

    Can anyone reccomend a job scheduler to use for kitchen and non-kettle jobs that share dependancies?

    Thanks
  41. Replies
    1
    Views
    1,879

    job as web service???

    Any plans to allow access to integrated data through an generated web service?

    Thanks for a great tool!
  42. Replies
    1
    Views
    1,130

    Stumped on transformation

    I've been doing this in the SQL for the source but would really rather push the logic to the Kettle transformation ...

    Source:
    Field / Value
    MyKey / 1
    MyString /...
  43. Replies
    0
    Views
    1,601

    'pet' presentation

    I'm stumped (nothing new) ...
    We have a very senior executive whose favored presentation of information is a small table with drilling and filtering controlled by drop down lists.

    This is pretty...
  44. Replies
    1
    Views
    1,273

    ItemPercentageFunction

    Seems like the logid to divide by 100 is missing ... Value on a row of 75, column totals to 250 and I get 3000%. Is this in my formatiing or a bug?

    thanks!
  45. Replies
    8
    Views
    3,648

    Poll: anxiously waiting

    Not using it in production yet but (like others, I'm sure), waiting on a GA release. This will be very valuable - After I overcame my notion that it was a semantic layer for reporting, I realized how...
  46. Replies
    1
    Views
    2,062

    'throttled' jdbc driver

    seems like it wouldn't be too difficult to build a JDBC driver that accessed any/most other JDBC driver providing an additional layer abstraction.

    The new driver would allow throttling of data...
  47. Surely this can be done ...

    How would one pass a parameter to be used as "command line argument 1" in a transformation from td linehe command lne?

    What if the Trans is in a job and the job is called from the command...
  48. Passing parameters to jobs on kitchen command line

    This may be obvious but I'm stumped ...

    using kitchen.sh and kitchen.bat, how can I pass a parameter to be used as "command line argument 1" used in a transformation T in job J that is scheduled...
  49. Replies
    1
    Views
    1,661

    2 questions - remember I'm slow ...

    I have a physical table - some rows should not be visible in a business view. There is a single attriubte that determines this. How can I constrain the data in a BT with a where clause?

    Is...
  50. Replies
    3
    Views
    1,489

    DS Volume

    you mention the volume of data but not the type of decision support functions that will be used - the complexity and frequency of queries and the size of the result sets.

    I don't THINK SQL Server...
Results 1 to 50 of 66
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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