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.  Creating SQL Schema

    Posted Wed October 17, 2001 12:40 PM

    Hi,

    I successfully connected to my SQL store as DBA/dba. Now I’d like to create a schema: trying to connect by using SQLint failed. I also tried to create the schema by using the Tamino manager tool, but I can’t find where to define a schema

    Can somebody point me to the Tamino documentation where it’s described. I couldn’t find it.

    Any suggestions? Thanks, rene


    #webMethods
    #API-Management
    #Tamino


  • 2.  RE: Creating SQL Schema

    Posted Fri October 19, 2001 08:32 AM

    In your Tamino Interactive interface there is a define option just click browse and point to your file and click Define. Hope this helps


    #webMethods
    #API-Management
    #Tamino


  • 3.  RE: Creating SQL Schema

    Posted Fri October 19, 2001 06:38 PM

    For defining SQL tables you will have to use the ‘sqlint’ utility. The Tamino Manager SQL Catalog is really a view of the current SQL schemata that have been defined.

    For using SQL you need a licence file that allows it.

    For help on ‘sqlint’ there is a PDF file in …\Tamino 2.3.1.4\Help\Print\sqlint.pdf. This explains btw that sqlint.exe is not installed unless you use ‘custom’ install.

    Once in sqlint you can connect to the Tamino database with:

    SQLINT> CONNECT TO “myDB” USER “DBA” PASSWORD “dba” ;

    From this point you should be able to define schemata, tables etc.

    Oh, btw the Tamino Interactive Interface only allows schema’s defined for the XML repository and not the SQL repository.


    #API-Management
    #Tamino
    #webMethods