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.


#TechXchangePresenter
 View Only

  • 1.  DB link Script

    Posted Wed April 16, 2014 02:16 PM

    what is the process for converting a DB link script to webMethods? Do I need to write dynamic SQLs or making a package in oracle from teh script?


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 2.  RE: DB link Script

    Posted Wed April 16, 2014 02:24 PM

    What does your DB link scripts contain and what does it do? Is it a huge script or just few lines?


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 3.  RE: DB link Script

    Posted Thu April 17, 2014 12:22 AM

    It is a select from one database and insert into other database. Different tables and columns, 3 stored procedure about ten selects.

    Thanks


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: DB link Script

    Posted Thu April 17, 2014 03:12 AM

    You can go for CustomSQL, DynamicSQL, StoredProcedure and StoredProcedureWithSignature adapter services

    Please read : 6-5_JDBC_Adapter_Install_and_Users_Guide


    #Integration-Server-and-ESB
    #webMethods-General
    #webMethods


  • 5.  RE: DB link Script

    Posted Thu April 17, 2014 04:44 AM

    You should rething your architecture. If you are using webMethods for executing a script which moves data from one db to another you are probably not using a good solution architecture. What are you trying to achieve?


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


Related Content