IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
  • 1.  Automating the Map Execution with Command Server.

    Posted 09/23/08 03:07 AM

    Originally posted by: SystemAdmin


    Hi Guys,
    Can anybody help me in making a map to execute after every specified time interval without the intervention of the User with the help of CommandServer...?

    Situation:: I have one Enterprise System which used to push the data(input) to the WTX System. We have installed WTX Command Server in the Production Environment which will take care of transformations. But I need to automate the flow. The Enterprise System pushes the Data after every 15 mins.

    Please help me in solving this issue......

    Thnx in advance.

    With Regds,
    Sandeep.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: Automating the Map Execution with Command Server.

    Posted 09/23/08 03:40 AM

    Originally posted by: residium


    Not sure what you mean but have you tried the good ol Scheduled Task in Win2003 or Cron in linux? Put your commands in a cmd file..
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: Automating the Map Execution with Command Server.

    Posted 09/23/08 06:17 AM

    Originally posted by: SystemAdmin


    Hi,
    Can I have commands for batch file.....?
    Please help me for archieving the output file also, unable to specify what command to use in batch file.. :(
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: Automating the Map Execution with Command Server.

    Posted 09/23/08 08:14 AM

    Originally posted by: residium


    If you have the Command Server I take it you are familiar with running maps from the command line?
    By putting the same commands in a file (.cmd file) you can call the file from Windows task scheduler and it will execute your .cmd file which will run all the commands you have in there.

    This is pretty basic stuff, I think it is documented in the docs. Search for "Command Line" and you will see what I mean.
    If you still dont get it. Google for "batch files" or similar in windows first.

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


  • 5.  Re: Automating the Map Execution with Command Server.

    Posted 09/24/08 12:32 AM

    Originally posted by: jvanboga


    You must define the path for the command server exe unless it is defined in the path.

    Value '-b' will close the command server execution window when the map completes. Look in the pdf docs for more detailed information.

    Two basic commands below. You can do a lot more depending on your version, machine config and requirements.

    path\cmd_srvr_executable path\map.mmc -ie1 'data to echo in' -ae=path\log_file -b

    path\cmd_srvr_executable path\map.mmc -if1 'path\input_file' -ae=path\log_file -b
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 6.  Re: Automating the Map Execution with Command Server.

    Posted 09/23/08 05:01 AM

    Originally posted by: LaurentB


    Hi,

    depending on your requirement, and the way the data is pushed to WTX, you could also use WMQ triggering (provided you use WMQ, of course) to trigger a script each time some data is received, and the script would run the map.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 7.  Re: Automating the Map Execution with Command Server.

    Posted 09/23/08 05:05 AM

    Originally posted by: janhess


    Using Launcher would solve all your problems as you could use the input file as the trigger.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 8.  Re: Automating the Map Execution with Command Server.

    Posted 09/25/08 01:06 AM

    Originally posted by: SystemAdmin


    Hi Janhess,
    I am using the Launcher for making the map to run automatically after each and every 15mins. But, it is unable to run.
    Please have a look at the options what I set:
    Time Event
    Switch --->ON
    Trigger -->Every
    Interval -->15Mins.

    Will you let me know what other options to set and any changes to be done...?
    Do we need to set any properties in Launcher Administration page(http://localhost:80/admin). I didnt got the use of this page properly.

    Help me in running the map after each and every 15mins.

    Thnx in advance.

    With Regds,
    Sandeep.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 9.  Re: Automating the Map Execution with Command Server.

    Posted 09/25/08 04:28 AM

    Originally posted by: janhess


    What errors do you get in the map log or the launcher log or does the map not run at all? Have you got any other triggers set?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange