Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: does connection closes after each transformation?

  1. #1
    Join Date
    Mar 2007
    Posts
    158

    Default does connection closes after each transformation?

    Hi all,


    I want to know that after each and every transformation doeas kettle close the database connection with the server?

    because there are sometimes when we run the task on the very secured database servers so just let me know that using Kettle is safe or not?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    When the transformation ends the database connections are closed.

    Regards,
    Sven

  3. #3
    Join Date
    Mar 2007
    Posts
    158

    Default

    Can u pls tell me that what is the security assurance in Kettle?
    how much it is secure?

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    There is no security assurance.

    Security is only as good as the environment you run Kettle in. Passwords are only obfuscated so if you have someone with access to Kettle and you store the passwords in the .ktr files themselves he will be able to decrypt them if he really wants.

    There's no encryption in most of the JDBC drivers for data transport, ...

    Regards,
    Sven

  5. #5
    Join Date
    Mar 2007
    Posts
    158

    Default

    ok.
    Is there any don't and don'ts for this tool in the production?
    I mean any major issues?

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    TEST... TEST... TEST...

    In any software product there will be some bugs, so test before you put anything in production test.

    And then for the rest it depends. What I do/suggest (but it's personal, others may disagree):
    - Use the latest GA version (2.5.1 as we speak).
    - Have 3 kind of environments:
    a) development: per developer his pc probably (maybe with shared databases on a server)
    b) model-office/integration: 1 environment
    c) production
    - Don't use a repository for production and model office.
    - Use variables for server, userid, passwords.
    - Have a well-specified file system structure.
    - Prefer text files (ASCII) as input if possible (over direct database access).
    - Stage all files before really processing them.
    - Have files pushed to your environment, and push output files from your environment.
    - When used for Datawarehousing, use "Kimball"
    - ...

    Regards,
    Sven
    Last edited by sboden; 08-27-2007 at 07:07 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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