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
------------------------------
Original Message:
Sent: Wed March 11, 2020 11:26 AM
From: Karen Gallello
Subject: SQL Map Examples - SQL to EDI
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