Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Export KJB and KTR with no connection info

  1. #1
    Join Date
    May 2006
    Posts
    167

    Default Export KJB and KTR with no connection info

    Hi,
    my problem is that a very complex job with tens of transformations are exported and deployed as files.
    All those files contain a lot of <connection> written in kettle's XML.

    I'd like to export them as files without those connection info, but only with the name ot the connection used inside steps.

    A shared.xml file will contain the connection info (only one single point where to change).

    How can I export (if ti's possible), please?

    Thank you in advance.
    Best regards.
    Nicola

  2. #2

    Default

    Hi you can do this by using a single properties file . And define the connection variables in the properties file and call the properties file in the job using SetVariables step ,use the connection variables in place of dbconnections and share that connection so that the connection will be available in other Jobs.
    Hope the below image helps it contains kettle properties file where you can define database connection variables.

    Name:  conn.jpg
Views: 120
Size:  15.1 KB
    Last edited by nagarjuna.kommineni; 05-14-2014 at 12:01 PM. Reason: Sorry after uploading the image it became blur ..

  3. #3
    Join Date
    Apr 2008
    Posts
    4,684

    Default

    In Tools -> Options, one of the options listed is:

    Only save used connections to XML

    This will strip out any DB connections that are not being used in this Transformation.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

Tags for this Thread

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.