Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    3
    Views
    1,397

    Database Migration

    Hello,

    Am looking for some expert tips on data migration using Kettle.

    With reference to http://wiki.postgresql.org/wiki/Migrating_from_one_database_to_another_with_Pentaho_ETL, migration...
  2. Replies
    4
    Views
    1,050

    Any Pointers ?? Regards, Neuron

    Any Pointers ??

    Regards,
    Neuron
  3. Replies
    4
    Views
    1,050

    Thanks Buachaille! Regarding kettle using VFS,...

    Thanks Buachaille!

    Regarding kettle using VFS, is there any sample to refer files on remote servers? That will definitely help.

    Regards,
    Neuron
  4. Replies
    4
    Views
    1,050

    Processing Unstructured Data (Flat Files)

    Hi Experts,

    Looking for a requirement to read unstructured data basically from flat files and process that data in a format (csv format) so that it gets loaded in server database.

    Also...
  5. Replies
    2
    Views
    1,600

    Hi Slawo, Great help! CAST did work. JFI, I...

    Hi Slawo,

    Great help! CAST did work.

    JFI, I also tried JCONNECT driver and the same kettle transformation without CAST worked.
    But with IANYWHERE driver CAST was explicitly required.

    Many...
  6. Replies
    2
    Views
    1,600

    Exceptions while executing SQL query

    Hi Experts,

    Need some help.
    I am writing a kettle transformation in which I am querying the Sybase ASA database using ianywhere driver. The step before "Table Input" step I am selecting some...
  7. Hi Again, Is this issue really not having any...

    Hi Again,

    Is this issue really not having any resolution or any pointer?

    Regards,
    Neuron
  8. Hi Again, I know i was quite late in...

    Hi Again,

    I know i was quite late in responding back.

    Please refer the transformation file which I attached in my last post.

    Please let me know some comments or any other pointer which can...
  9. Sorry guys, couldn't reply back earlier. Does...

    Sorry guys, couldn't reply back earlier.

    Does the registry setting sCountry" under “HKEY_CURRENT_USER\Control Panel\International” would have an impact. In one scenario when it was set non-English...
  10. Hi Matt and others, Please let me know some...

    Hi Matt and others,

    Please let me know some comments, any registry settings or any other pointer which can resolve this. Hope I was able to explain the issue.

    Regards,
    Neuron
  11. File output generates incorrect data for columns with precision settings

    Hi Experts,

    I am facing one issue wherein I am creating a csv file from the database table.

    Issue is for some columns with floating values, data is garbled wherein it is not able to understand...
  12. For me I get this INFO message when I execute...

    For me I get this INFO message when I execute 'Kitchen' and also when SharedObjects constructor is called.

    I checked log4j.xml in kettle-engine.jar and this file has INFO, maybe when i change to...
  13. Thanks pstoellberger, this really helps. Could...

    Thanks pstoellberger, this really helps.

    Could you tell me exactly what I need to do in log4j configuration to skip the INFO line.

    Regards,
    Neuron
  14. Unable to find kettle engine jar file to set build date. (ignored)

    Hi,

    When I execute kitchen.sh as first lines I get following:
    INFO 30-03 19:47:49,738 - Using "/var/tmp/vfs_cache" as temporary files store.
    Unable to find kettle engine jar file to set build...
  15. Ok:) Thanks Sven. Regards, Neuron

    Ok:) Thanks Sven.

    Regards,
    Neuron
  16. Thanks Sven. Well yes that's true. Just as always...

    Thanks Sven. Well yes that's true. Just as always wanted confirmation from you.

    Well I forgot earlier in the flow of other things, as 3.1 as the requirement to have 'Name of the Job' entry...
  17. Thanks Sven for the clarification. The good...

    Thanks Sven for the clarification.

    The good thing is with both the changes as I mentioned in this thread (related to job and transformations) things are working for me.

    Well I want to clarify...
  18. Hi Mattcasters, Sven, The database connection...

    Hi Mattcasters, Sven,

    The database connection issue got resolved once I added the "-Djava.library.path" parameter in kitchen.sh while executing 'org.pentaho.di.kitchen.Kitchen'.

    Well I faced...
  19. I did not get any expert comment on: 1. If I...

    I did not get any expert comment on:

    1. If I try to run kitchen.sh with an '&' (background) towards end, I was facing exceptions. Please can you provide your comments. Well after removing '&' it...
  20. Thanks for replying. I don't know what i am...

    Thanks for replying.

    I don't know what i am missing, now when I revert back to 2.4 kettle environment on the same machine the connection is working.

    I haven't touched the 'so' file, so I guess...
  21. Yes, may be I am doing something silly here. But...

    Yes, may be I am doing something silly here.
    But just to clarify, the same job works in 2.4 and connects to DB using ianywhere.

    I have just cleared up all the 2.4 jars and added 3.1 jars in...
  22. Thanks Sven. Yes correctly said, before posting...

    Thanks Sven. Yes correctly said, before posting the reply i did check and the libdbjodbc9.so is also present.
    The 'jar' and 'so' both present at correct locations.

    Can you please elaborate:...
  23. no dbjodbc9 in java.library.path

    Hi MattCasters,
    Last night I was able to proceed further with your hints, now encountering more issues:
    1. If I try to run kitchen.sh with an '&' (background) towards end, I was facing exceptions....
  24. Yeah Matt! Really fantabulous way to make this...

    Yeah Matt! Really fantabulous way to make this 30,000 post.
    And I really appreciate your timely help.

    Now I am able to proceed, although getting other exceptions as I am moving on, will need your...
  25. Replies
    2
    Views
    1,150

    Thanks MattCasters. These documents are really...

    Thanks MattCasters. These documents are really helpful.
    I look forward for fruitful discussions on this forum and with you.

    Regards,
    Neuron
  26. Ohh...sorry I missed that earlier. Now I see...

    Ohh...sorry I missed that earlier.

    Now I see most of my transformations and Jobs don't have "Name of Job" entry field but the 'Job Entry Name' has been set properly for jobs and transformations.
    ...
  27. Thanks MattCasters for the quick turn around. I...

    Thanks MattCasters for the quick turn around. I have been debugging this entire two days but no result.

    The same job works fine in kettle 2.4, I checked again each step has name.
    It gives me...
  28. Unexpected error occurred while launching entry

    Hi Experts,

    I am facing kettle exceptions while running my job in 3.1, need your comments whether am I missing anything.

    The exception says:
    ERROR - Thread[Thread-2,5,main] -...
  29. Replies
    2
    Views
    1,150

    Kettle 2.4 to kettle 3.1

    Hi Experts,

    I have some questions related to kettle 3.1

    I have written jobs and transformations in 2.4 and now I am upgrading to 3.1;
    Are there any known issues, or some some steps used in 2.4...
Results 1 to 29 of 29
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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