Managed File Transfer

 View Only
  • 1.  SFG- MFT - More SQL Questions about tables to find.......

    Posted Fri May 08, 2020 02:55 PM
    we have a Partner with an SMTP Protocol:
    wanting to get the email address>
    what would the SQL statement be?

    ++++++++++++++++++++++++++++++++++++++++++++++

    Where can I find resources about the tables?

    i googled but only found limited info stuff good but not the level I am looking for.


    Thanks again everyone for teh help with the other SQL question 


    ------------------------------
    Jeff Endres
    ------------------------------

    #filetransfer
    #DataExchange


  • 2.  RE: SFG- MFT - More SQL Questions about tables to find.......

    Posted Mon May 11, 2020 09:27 AM

    Jeff,
    Can you provide more details about how you are creating trading partners and what type of delivery solution you are using, such as "is this for a custom delivery protocol"?  If so, I find details about my trading partner configurations in tables SCI_DOC_EXCHANGE and SCI_ENTITY_EXTNS

    Example (for SQL Server)

    SELECT REPLACE( sde.OBJECT_NAME, '_CONSUMER', '' ) partner, see.EXTENSION_VALUE addr  
    FROM SCI_ENTITY_EXTNS see 
    JOIN SCI_DOC_EXCHANGE sde ON see.ENTITY_ID = sde.ENTITY_ID
    WHERE see.EXTENSION_KEY = '<key value assigned by your custom protocol>'
    ORDER by see.OBJECT_NAME



    ------------------------------
    Michael Geier
    IT Engineer 3
    Enterprise Holdings, Inc
    St. Louis MO
    ------------------------------



  • 3.  RE: SFG- MFT - More SQL Questions about tables to find.......

    Posted Mon May 11, 2020 10:34 AM
    Looking for the Table where Receiver data is stored  in this case it is Email address,   thanks for the other Info any and all Table info is helpful for me


    N/A


    ------------------------------
    Jeff Endres
    ------------------------------



  • 4.  RE: SFG- MFT - More SQL Questions about tables to find.......

    Posted Tue May 12, 2020 05:30 PM
    From the looks of your screenshot, it appears that you're using a custom delivery protocol.  I believe the values should be found in SCI_ENTITY_EXTNS.
    Try the following query and see what it returns.  Then, you can use my previous query to enhance the information.

    SELECT * FROM SCI_ENTITY_EXTNS WHERE EXTENSION_VALUE LIKE '%genpt.com%'


    ------------------------------
    Michael Geier
    IT Engineer 3
    Enterprise Holdings, Inc
    St. Louis MO
    ------------------------------