IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  select adapter service

    Posted Tue April 29, 2008 02:06 PM

    Hi,
    Plz can u convert the following SQL query into webMethods Adapter service

    select a.X_SALES_REGION,b.name ALIAS_NAME, c.name Primary_Industry_Name
    from tbsie.mv_s_org_ext a, tbsie.mv_s_org_syn b, tbsie.mv_S_INDUST c
    where b.OU_ID(+) = a.row_id
    and a.X_PR_INDUST_ID = c.row_id(+)

    Regards,
    Sunil


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 2.  RE: select adapter service

    Posted Tue April 29, 2008 04:27 PM

    You can either use a select adapter service or a custom SQL adapter service. Review the JDBC documentation for defining such services.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


Related Content