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


Chapter 1 Introduction : Overview of the Gateways

Overview of the Gateways
What are TIBCO Service Gateway for ODBC and TIBCO Service Gateway for Oracle?
The Gateways are server processes that you can use to access external DBMS data from a TIBCO Object Service Broker session.
You use the TIBCO Service Gateway for ODBC to access ODBC data from within TIBCO Object Service Broker and you use TIBCO Service Gateway for Oracle data to access Oracle data from within TIBCO Object Service Broker.
Both Gateways run in a TIBCO Object Service Broker Execution Environment under Windows. TIBCO Service Gateway for Oracle can also run under Solaris and Linux. The Gateways ensure that data is presented to TIBCO Object Service Broker rules in a manner consistent with TIBCO Object Service Broker behavior. The Gateways convert TIBCO Object Service Broker requests into ODBC API function calls and Oracle OCI function calls, and use these APIs and OCIs to communicate with the external DBMSs.
Because both Gateways exhibit similar behavior and yield similar functionality, they are described in this manual as one component, with their differences also indicated.
The Gateways are installed with TIBCO Object Service Broker.
Components of the Gateways
The Gateways consist of the following components:
Metadata Extractor
Extract table definitions from external DBMSs and store them in TIBCO Object Service Broker TDS tables.
Accessing TDS and External DBMS Data
Using the Gateways’ components, you access external DBMS data by:
1.
2.
3.
4.
Defining an SLK table based on an external table definition and optionally mapping stored procedures with TIBCO Service Gateway for ODBC
5.
The following diagram illustrates the access flow.

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