Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Managing TIBCO Object Service Broker Data Definitions : How to Access External DBMS Data

How to Access External DBMS Data
To access external DBMS data from TIBCO Object Service Broker, you must define a TIBCO Object Service Broker table of type SLK using the Table Definer. You also have the option of using the Table Definer to map a stored procedure for TIBCO Service Gateway for ODBC, that is, if you set SERVERTYPE to SLK. Using the Table Definer, you can access an existing table definition or create a new one.
Composition of an SLK Table
An SLK table consists of the following elements:
A stored procedure mapping can optionally have fields marked as:
All these characteristics are considered known to the user at definition time.
Table Definition Requirements
Each SLK table must be unique; it must be defined to one and only one SERVERID. You can use the SERVERID parameter to identify a pool of Gateways that are considered equivalent by the Data Object Broker.
You indicate what type of Gateway your definition is meant for by specifying the SERVERTYPE parameter:
Accordingly, for TIBCO Service Gateway for ODBC, you must indicate which data source to use; for TIBCO Service Gateway for Oracle, you must indicate which Oracle SID to use.
Procedure to Define a Table
Complete the following tasks to define an SLK table:
1.
2.
3.
4.
5.
6.
These tasks are described in Defining an SLK Table.
You can use the following optional tasks to assist in the management of the table:
These tasks are described in Post Table Definition Optional Tasks.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved