Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Find Transformations Using Any Particular Connection

  1. #1
    Join Date
    Nov 2016
    Posts
    25

    Exclamation Find Transformations Using Any Particular Connection

    Hi All,

    I have 100-150 transformations and I need to find how many of them are using any particular connection manager.

    Eg. I have a SQL server connection manager pointing to A.B.C.D server which is shared across the solution. I want to find all transformations that use this connection anywhere like Table input, Table output, DB lookup etc.

    Can someone please suggest how to do this ?
    TIA,
    Sanket Kelkar.

    PDI CE 6.1
    Oracle 11g
    Windows Server 2012

  2. #2
    Join Date
    Jan 2015
    Posts
    107

    Default

    Transformations and jobs are just XML files, so you can search them for text fragments. If you use a Database repository, you can export the repository to one big xml file.

    Connections exist in two forms in the files:

    1. Connection definition objects.

    These have the form of <Connection> <Name>MyConnectionName</Name> ... more elements ... </Connection
    Search for <Name>MyConnectionName</Name> and you should find them all.
    Chances are you'll find them in EVERY transformation and job file in the repo. The only way to prevent that is to check "Only saved used connections to XML" in the Spoon options.

    2. Connection references in steps

    These look like "<connection>MyConnectionName</connection>" and are only present in steps that actually use the connection, so they are much more useful.

    Please note that jobs can also reference connections in any number of steps or configuration.

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.