1 2 Previous Next 16 Replies Latest reply on Oct 17, 2019 6:05 AM by vishwakumar Palamadai

    Repository Query to get all SOurce & target connections including source & target flat file

    vishwakumar Palamadai Guru

      Hi,

       

      I was able to get hold lots of repository query to get a list of source and target DB connections but what i also require is a list that provides me any type of connections and their values - Ex: IF I have a flat file source, i need the flat file name parameter value or actual file name and the source path directory parameter value or the actual directoy/path details -  depending on how the session are configured.

       

      These are the information am looking for:

       

      1. FOlder name

      2. Workflow name

      2. Session NAme

      4. MApping name

       

      5. SOurce connection type [ DB/Flat FIle]

      6. SOurce connection name [ COnnection/DB name if database]

      7. SOurce file name[ IF flat file]

      8. SOurce file path[ If flat file]

       

      9. TArget connection type [ DB/Flat FIle]

      10. Target connection name [ COnnection/DB name if database]

      11. TArget  file name[ IF flat file]

      12. target  file path[ If flat file]

        1 2 Previous Next