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
Back to discussions
Expand all | Collapse all

SQL mapping of several oracle tables

  • 1.  SQL mapping of several oracle tables

    Posted Mon December 17, 2001 12:48 PM

    (Tamino 2.3., Oracle 8i)

    Hi,

    I have tried to define a data structure (SQL columns) distributed over several oracle tables in one tamino schema. The _define process was successful but XQL-querys ends without results.

    Could somebody give me more details on to how this thing was exactly done (e.g. examples)?

    Thank you in advance
    Jan


    #webMethods
    #API-Management
    #Tamino


  • 2.  RE: SQL mapping of several oracle tables

    Posted Thu December 20, 2001 03:55 AM

    Jan,

    I have attached an Tamino XML Schema which you can find how to link up multiple SQL tables (with primary & foreign key). Although my database was “MS ACCESS”, the concept is the same.
    patients.xml (3.08 KB)


    #Tamino
    #webMethods
    #API-Management


  • 3.  RE: SQL mapping of several oracle tables

    Posted Fri January 11, 2002 01:25 PM

    Hi!

    Has anyone tried to link up more than 2 SQL tables?

    I have tried with three, by following the example of Tony, but it doesn’t work.

    Thanks in advance!


    #API-Management
    #Tamino
    #webMethods


Related Content