StreamStudio communication

StreamStudio uses web services (WS) and JDBC when communicating with the service gateway, the runtime repository, and the web content repository. The service gateway, in turn, uses ODBC when retrieving data from the runtime repository and from the Collector archive.

Figure 5

StreamStudio communication

Web services

Web services are used when StreamStudio communicates with the service gateway.

You configure the service gateway web services in Control Center. Some additional configurations can be done in the property file for the web services (ws.properties). For example, in this file you can load balance two service gateways. For more information, see OpenText StreamServe Performance Guidelines Reference Guide.

JDBC

StreamStudio uses JDBC stored procedures when retrieving data directly from the runtime repository and the web content repository. The required drivers are provided by the StreamStudio setup.

The property files for Microsoft® SQL Server® (sql_jdbc.properties) and Oracle® Database (oracle_jdbc.properties) are pre-configured and installed together with the StreamStudio setup. Normally, you do not have to edit these files. However, if you set up OpenText StreamServe for Oracle® Real Application Clusters (RAC), you must generate a new oracle_jdbc.properties. (To set up StreamServe for Oracle RAC, there are also other configurations that must be carried out. For more information, see OpenText StreamServe Cluster Guidelines Reference Guide.)