B2B Integration

 View Only
  • 1.  SQL Map Examples - SQL to EDI

    Posted Wed March 11, 2020 11:26 AM
    ​Does anyone have an SQL to EDI map example I could review?  I need to convert outbound JDE F47 table data to EDI.

    ------------------------------
    Karen Gallello
    ------------------------------

    #B2BIntegration
    #SupplyChain


  • 2.  RE: SQL Map Examples - SQL to EDI

    Posted Thu March 12, 2020 09:28 AM
    Hi Karen,

    You can use the SI Map Editor tool to do it, however I will advise to use the IBM Sterling Transformation Extender (formerly known as WTX) to perform the DB to EDI and EDI to DB maps.

    For SI Map editor, you will require to create a ODBC connection with database on your Windows Laptop/Workstation and then choose that ODBC connection in you SI Map Editor to load the table schema.

    Probably you may visit this link https://www.ibm.com/support/pages/setup-sql-map-sterling-b2b-integrator to quickly get an handle on the SQL maps.

    Regards,
    Bharat

    ------------------------------
    BHARAT BALOTHIA
    ------------------------------



  • 3.  RE: SQL Map Examples - SQL to EDI

    Posted Thu March 12, 2020 12:16 PM
    Hello Karen,

    Sterling Integrator SQL maps have a limitation that it does not support dynamic queries. That means we cannot specify a query with where clause having variable such as PO Number. If you do not want to use the WTX map, then you can extract data from the table by either using the LWJDBC adapter or SQL map in flatfile or delimited records and then run it through docExtract to separate it and then run map for EDI translation.

    _Dhiraj Patil

    ------------------------------
    Dhiraj Patil
    ------------------------------