IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
Back to discussions
Expand all | Collapse all

How can I run a map after insert in a database table??

  • 1.  How can I run a map after insert in a database table??

    Posted 07/10/09 03:23 AM

    Originally posted by: heyspo


    Hello,

    I am trying to run a map after insert into a database table, is the first time that I try .

    I create new query in the database interface designer. The new query is :
    select * from shema.table_1
    I have defined the trigger for the new query.

    I am trying to use integration flow designer to enable triggers. This is the configuration for the input:

    input->Card_mode->Integral
    Input->GET->Source-> Database
    input->GET->Source ->order : -MDQ %mdq_file% -DBNAME database -QUERY TABLE_1
    input->SourceEvent->ON

    I have executed m4ora.sql and m4ora_col.sql scripts in the database

    Have I do anithing else??

    Thanks in advance!
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: How can I run a map after insert in a database table??

    Posted 07/10/09 09:07 AM

    Originally posted by: Kepa_Screen


    Hi heyspo !!! ;)

    I think that you need to create Triggers at Db Interface Designer, instead of using QUERY's.

    -QUERY is used to GET or retrieve data from DB
    If you want to be "listening" to a table change, then you need triggers.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


Related Content