![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
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.
• Define stored procedures only for TIBCO Service Gateway for ODBC Metadata Extractor Extract table definitions from external DBMSs and store them in TIBCO Object Service Broker TDS tables.
2. [z/OS only] Setting up resources for your Gateways through the TIBCO Object Service BrokerAdministration Menu
3. Starting one or more Gateways to convert requests into ODBC API or Oracle OCI API function calls
4. Defining an SLK table based on an external table definition and optionally mapping stored procedures with TIBCO Service Gateway for ODBC
5. Using the Table Browser, the Table Editor, and the rules language to manipulate the data
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |