B2B Integration

 View Only
  • 1.  Using IBM Transformation Extender 10 maps to insert/query data from a MongoDB database

    IBM Champion
    Posted Thu August 13, 2020 04:13 AM
    Using IBM Transformation Extender 10 maps to insert/query data from a MongoDB database, a new video on my YouTube channel:youtu.be/P3OpIRxTJWE

    Enjoy!

    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------


  • 2.  RE: Using IBM Transformation Extender 10 maps to insert/query data from a MongoDB database

    Posted Tue June 08, 2021 04:32 AM
    Hi Paul,

    These examples are only for query and insert, we are looking for options to update MongoDB document, if it exists otherwise create a new doc. could you please help?

    ------------------------------
    Rajesh Kumar
    ------------------------------



  • 3.  RE: Using IBM Transformation Extender 10 maps to insert/query data from a MongoDB database

    IBM Champion
    Posted Tue June 08, 2021 05:14 AM
    Please review the documentation here:

    https://www.ibm.com/docs/en/ste/10.0.0?topic=SSVSD8_10.0.0/com.ibm.websphere.dtx.adapmongo.doc/mongodb_commands.htm

    -UPDATE
    • Updates the documents that match the query with the data in the third argument of the GET function, then returns the documents to the map for further processing.
    • Updates the documents that match the query with either the data in the output card or the data in the third argument of the PUT function, then adds the documents to the collection.


    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------



  • 4.  RE: Using IBM Transformation Extender 10 maps to insert/query data from a MongoDB database

    IBM Champion
    Posted Tue June 08, 2021 05:44 AM
      |   view attached
    Revised map source file with an 'Update' example attached.

    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Attachment(s)

    zip
    StockControl.zip   5 KB 1 version