• Topic
  • Discussion
  • SupportWeb.ODBCLogicalDiagrams(Last) -- Owiki? , 2016-08-19 14:59:35 Edit owiki 2016-08-19 14:59:35

    ODBC Data Access Drivers - Logical Diagrams

    This section provides logical diagrams for OpenLink's ODBC data access drivers. Single-Tier (Express Edition) Drivers Single-Tier (Lite Edition) Drivers Multi-Tier Drivers

    Single-Tier (Express Edition) Drivers

    All Drivers
    Express Drivers Logical Diagram Executive Summary: A clientside-only solution that provides non-enterprise grade data access with minimal configuration and a low price point.

    Architectural Components: Application Instance(s), Driver Manager, OpenLink Client Driver, Data Store

    Functional Capabilities: ODBC data access to supported data stores.

    Hardware/OS Dependencies: OpenLink client driver must be installed on a supported Mac or Windows operating system that has Java runtime version 1.5 or higher. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Other Dependencies: Data store version must be supported.

    Performance Levels: Non-enterprise grade performance.

    Implementation Variances: Data store may reside on the client machine or a remote machine.

    Security Features:

    Constraints & Limitations: Solution does not provide enterprise grade performance or stability. Solution is not portable to Unix clients.

    Single-Tier (Lite Edition) Drivers

    Microsoft SQL Server, MySQL, PostgreSQL, and Sybase Drivers
    Lite (non-Wire) Logical Diagram Executive Summary: A clientside-only solution that provides enterprise grade data access with minimal configuration.

    Architectural Components: Application Instance(s), Driver Manager, OpenLink Client Driver, Data Store.

    Functional Capabilities: ODBC data access to supported data stores.

    Hardware/OS Dependencies: OpenLink client driver must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Other Dependencies: Data store version must be supported.

    Performance Levels: Highest performance available.

    Implementation Variances: Data store may reside on the client machine or a remote machine.

    Security Features:

    Constraints & Limitations: Solution only applies to Microsoft SQL Server, MySQL, PostgreSQL, and Sybase data access.

    DB2, Informix, Ingres, Oracle, and Progress Drivers
    Lite (Wire Protocol) Logical Diagram Executive Summary: A clientside-only solution that provides enterprise grade data access with minimal configuration.

    Architectural Components: Application Instance(s), Driver Manager, OpenLink Client Driver, Database Native Client, Data Store.

    Functional Capabilities: ODBC data access to supported data stores.

    Hardware/OS Dependencies: OpenLink client driver must be installed on a supported operating system that contains the database native client for the target data store. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Other Dependencies: Data store version must be supported.

    Performance Levels: Highest performance available.

    Implementation Variances: Data store may reside on the client machine or a remote machine.

    Security Features:

    Constraints & Limitations: Solution applies to DB2, Informix, Ingres, Oracle and Progress data access.

    ODBC & JDBC Bridge Drivers
    Lite Bridge Logical Diagram Executive Summary: A clientside-only solution that provides enterprise grade data access with minimal configuration.

    Architectural Components: Application Instance(s), Driver Manager, OpenLink Client Driver, ODBC DSN or JDBC Connection URL, Data Store.

    Functional Capabilities: Bridge-based ODBC data access to ODBC- and JDBC- compliant data stores.

    Hardware/OS Dependencies: OpenLink client driver must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Other Dependencies: OpenLink client driver must be installed on an operating system that contains a functional ODBC DSN or JDBC connection URL that connects to the target data store. The ODBC DSN or JDBC URL may use OpenLink or non-OpenLink drivers. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Performance Levels: Highest performance available.

    Implementation Variances: Data store may reside on the client machine or a remote machine.

    Security Features:

    Constraints & Limitations: Solution applies only to data stores that are accessible via ODBC DSNs and JDBC URLs. Overall functionality, performance, and stability may be impacted by limitations in the ODBC DSN or JDBC URL.

    Multi-Tier Drivers

    Multi-Tier (non-Wire) Logical Diagram Executive Summary: A client/server solution that provides enterprise grade data access with maximum configuration, security, and diagnostic resources.

    Architectural Components: Application Instance(s), Driver Manager, OpenLink Server Components, Data Store.

    Functional Capabilities: ODBC data access to supported data stores.

    Hardware/OS Dependencies: OpenLink client driver must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit. OpenLink server components must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Other Dependencies: OpenLink server components must reside on same machine as the data store when that data store is a DB2, Informix, Ingres, Oracle, or Progress. This restriction does not apply when the target data store is Microsoft SQL Server, MySQL, PostgreSQL, or Sybase.

    Performance Levels: High performance.

    Implementation Variances: 1) All architectural components may reside on one machine, 2) OpenLink server components and data store may reside on one, distinct server, 3) OpenLink server components may reside on a gateway and data store may reside on a dedicated DBMS server. This last architecture is suitable only for connectivity to Microsoft SQL Server, MySQL, PostgreSQL, or Sybase.

    Security Features: Complex, rules-based security configurable by Session Rules Book feature. SSL available in OpenLink 6.0 and newer releases. Proprietary bi-directional encryption available in earlier releases.

    Constraints & Limitations:

    Multi-Tier (Wire Protocol) Logical Diagram Executive Summary: A client/server solution that provides enterprise grade data access with maximum configuration, security, and diagnostic resources. No installation is required on data store server.

    Architectural Components: Application Instance(s), Driver Manager, OpenLink Server Components, Database Native Client, Data Store.

    Functional Capabilities: ODBC data access to supported data stores.

    Hardware/OS Dependencies: OpenLink client driver must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit. OpenLink server components must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Other Dependencies: OpenLink server components must reside on same machine as the database native client.

    Performance Levels: High performance.

    Implementation Variances:1) All architectural components may reside on one machine, 2) OpenLink server components and database native client may reside on one, distinct gateway. 3) OpenLink server components and database native client may reside on a distinct, DBMS server.

    Security Features: Complex, rules-based security configurable by Session Rules Book feature. SSL available in OpenLink 6.0 and newer releases. Proprietary bi-directional encryption available in earlier releases.

    Constraints & Limitations: Overall performance and stability may be impacted by bottlenecks in the database native client.

    Multi-Tier Bridge Logical Diagram Executive Summary: A client/server solution that provides enterprise grade data access with maximum configuration, security, and diagnostic resources.

    Architectural Components: Application Instance(s), Driver Manager, OpenLink Server Components, ODBC DSN or JDBC URL, Data Store.

    Functional Capabilities: Bridge-based ODBC data access to JDBC- and ODBC- compliant data stores.

    Hardware/OS Dependencies: OpenLink client driver must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit. OpenLink server components must be installed on a supported operating system. All architectural components on that operating system must share the same bit descriptor, i.e., 32 or 64 bit.

    Other Dependencies: OpenLink server components must reside on same machine as a functional ODBC DSN or JDBC URL. The ODBC DSN or JDBC URL may use OpenLink or non-OpenLink drivers.

    Performance Levels: High performance.

    Implementation Variances: 1) All architectural components may reside on one machine, 2) OpenLink server components and ODBC DSN or JDBC URL may reside on a gateway, 3) OpenLink server components and ODBC DSN or JDBC URL may reside on the data store server.

    Security Features: Complex, rules-based security configurable by Session Rules Book feature. SSL available in OpenLink 6.0 and newer releases. Proprietary bi-directional encryption available in earlier releases.

    Constraints & Limitations: Solution applies only to data stores that are accessible via ODBC DSN or JDBC URLs. Overall functionality, performance, and stability may be impacted by limitations in the ODBC DSN or JDBC URL.


    User Users are humans or non-human agents that leverage applications to obtain or manipulate SQL data held in data repositories. Users are identified by the hostname or IP address of the machine which hosts their target application(s).
    Application Instance The application instance refers to individual instances of applications that users exploit in the target architecture. Each instance of the application(s) is tasked with returning SQL data to users in a manner that is meaningful to them.
    Driver Manager The driver manager is a generic utility that loads drivers when requested to do so by client applications. OpenLink's Windows-based drivers are compatible with the Microsoft Driver Manager. OpenLink's Mac and Unix drivers ship with the iODBC Driver Manager. However, these drivers are designed for interoperability with non-OpenLink driver managers such as unixODBC and Intersolv.
    OpenLink ODBC Client Driver The OpenLink client driver comprises a clientside-only install of a .dll or other library and supporting files. Single-Tier client drivers are DBMS- or bridge-specific. They establish ODBC connectivity without the assistance of server components. Multi-Tier ODBC client drivers are generic. They require OpenLink server components to complete any data requests.
    OpenLink ODBC Client Driver Database native client refers to third-party database client communications software that facilitates connectivity to the target data store. This software speaks the native protocol of that data store.
    ODBC DSN or JDBC URL ODBC DSN or JDBC URL refers to ODBC data sources or JDBC connection URLs that pre-exist on the client system. These DSNs or JDBC URLS often use 3rd-party data access products, but they may use OpenLink data access drivers as well. The drivers used to create the DSN or JDBC connection URL must share the same bit descriptor as the OpenLink server components.
    OpenLink Server Components The OpenLink server components are architectural components that are specific to the Multi-Tier product format. The server components consist of a Request Broker and an Agent. The Request Broker is a generic, TCP-based listening service. It responds to client driver requests and loads the Agent that is suited for fulling those client requests. Agents may be DBMS- or bridge- specific. Requests for Oracle data are satisfied by one of OpenLink's Oracle Database Agents. Requests for data contained in a JDBC data store are satisfied by one of OpenLink's bridge-based JDBC agents.
    Data Data refers to SQL data that is contained in the target data store.
    Local IPC Connection Local IPC communications between architectural components. Local IPC communications can only occur when architectural components are hosted on the same, physical machine.
    TCP/IP Connection TCP/IP-based communications between architectural components. TCP/IP-based communications can occur across machine boundaries.

    Referenced by...