IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  WTX - SAP

    Posted Mon February 09, 2015 10:41 PM

    Originally posted by: Karthik12r


    My requirement is to transform files from SAP to target system flat file. From our understanding we would receive an IDOC file from SAP which WTX would convert to required output flat file. To achieve this we would need an .ido file or xml dtd file from SAP which we can make use to import in to type tree to get the IDOC structure in the input.  

    Can anyone help me in explaining how to get this importer file from SAP?

    and how do we import this to make a type tree? Do we need a SAP pack installed along with WTX? (my Client does not have this pack installed).

    I am using WTX 8.4.1 version.


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: WTX - SAP

    Posted Tue February 10, 2015 06:36 AM

    Originally posted by: GKearney


    Hi,

    You can use transaction WE60 to create an .ido file.

    The following link contains an example of how to create an .ido file using transaction WE60.

    http://help-sap.blogspot.co.uk/2011/10/ido-file-for-idocs.html

    You need a WTX SAP Pack installed to be able to use the WTX IDOC importer to create a Type tree using the .ido file.

    Hope that this information is of help to you.


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: WTX - SAP

    Posted Tue February 10, 2015 06:53 AM

    Originally posted by: Karthik12r


    Hi,

    Thanks for your response. 

    1. Regarding the WTX SAP pack, are there specific versions to be considered? We work on WTX 8.4.1,  when I search for WTX SAP pack, i could see multiple versions. Not sure which one I should download.

    2.  .ido file once imported as type tree, it should work fine to validate the IDOC file? Would not require manual corrections or any?

     
    3. If SAP IDOC is the output of WTX, how do we use ALE adapter to send the output from WTX directly to SAP system.

    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: WTX - SAP

    Posted Tue February 10, 2015 07:10 AM

    Originally posted by: GKearney


    1. The WTX SAP Pack 8.3.2 is the latest WTX SAP Pack available. It's normally best to install the latest SAP Pack available to avail of all the latest fixes available.

    The following link is for the Release notes for WTX SAP Pack 832

    http://www-01.ibm.com/support/docview.wss?uid=swg27024492

    2. It should validate.

    3. There are examples of SAP inbound and SAP outbound maps using the WTX ALE adapter included in the WTX SAP example directories when the WTX SAP PAck is installed.  The example maps are in the following directory.

    C:\IBM\WebSphere Transformation Extender 8.4.1\examples\sap\r3\ERP\ALE

    I hope that this information is of help to you.


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 5.  Re: WTX - SAP

    Posted Tue February 10, 2015 07:38 AM

    Originally posted by: Karthik12r


    Hi,

     

    That was very very valuable.

     

    SAP IDOC Importer window has few options to be selected. Looks like each for specific cases. Can you give me an introduction to it?

    For Outbound from SAP, instead of directly accessing the SAP we can also feed the IDOC through file adapter right? that also works?


    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 6.  Re: WTX - SAP

    Posted Tue February 10, 2015 07:49 AM

    Originally posted by: GKearney


    When you install the WTX SAP Adapter there is documentation installed in the C:\IBM\WebSphere Transformation Extender 8.4.1\docs\en\enterprise_app_integration\sap directory which contains information about using the WTX SAP IDOC Importer.

     


    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: WTX - SAP

    Posted Fri February 27, 2015 02:35 AM

    Originally posted by: Karthik12r


    Hi,

     

    The IDoc from SAP would be in UNICODE format,as I am told.

    How can I create a type tree for that Idoc structure in unicode format?  What are the options to download the .ido file in unicode format and the options to import the .ido format to unicode type tree.


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 8.  Re: WTX - SAP

    Posted Wed February 11, 2015 04:44 AM

    Originally posted by: Karthik12r


    Hi,

     

    I was able to import the .ido file to generate type tree. When i try to parse the IDoc file through the input card, it fails with one or more input was invalid. Are there any points to keep in mind while IDoc is extracted form SAP?  


    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender