• Topic
  • Discussion
    • UdaWikiWeb.Udaudaodbcmtodbc-postgres-mt(Last) -- Owiki? , 2016-08-19 15:01:27 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    owiki 2016-08-19 15:01:27

    uda.odbc.mt.odbc-postgres-mt





    ODBC Driver for PostgresSQL





    ODBC Driver for PostgresSQL
    The OpenLink Multi-Tier ODBC Driver for PostgreSQL comprises two parts. On the server you install a request broker which handles incoming connections, and a database agent which makes the connection to the database itself.

    On data-consuming machines (clients or application-servers), you install a generic client. This approach presents an extra layer of abstraction, such that by installing one component on each client, you can connect to several servers, or several different databases via the same broker.

    Multi-tier is ideally suited to larger installations where the network administrator wishes to handle security rules and performance configurations centrally.

    The OpenLink Multi-Tier Drivers for PostgreSQL are a Type-B class driver developed using the PostgreSQL network (wire) protocol interface.


    [[/images/odbcpostgresmt.gif|]]


    /PostgreSQL Multi-Tier Architecture Diagram Image scaled down; Click to enlarge./

    Platform Support Support for client, server, and application server operating systems
    32- and 64-bit components Enables the development and utilization of 32- or 64-Bit DBMS independent applications. Broad Operating System Support Enables the development of ODBC compliant applications and the utilization of ODBC Drivers on non Windows platforms such as; Linux (x86, PPC, Itanium, Opteron), Mac OS X, Mac OS Classic, FreeBSD , Solaris, AIX, HP-UX, HP True64 UNIX, IRIX, Altix, SCO UnixWare , and others.
    Database Engine Support Backend database engine support


    | Broad backend Database Support | Enables DBMS independent application utilization and deployment across a vast array of industry leading DBMS engines that includes; Oracle (7.x - 10.x), SQL Server (6.x - 2005), DB2 (6.x - 8.x), Sybase (10.x - 12.x), Progress (7.x - 10.x), Ingres (6.4 - II family), Informix (5.x - 9.x & IDS 2000), MySQL , and PostgreSQL .

    Performance
    Blistering Performance Delivery of data access performance levels across ODBC, JDBC, ADO.NET and OLE DB that don't compromise viability of DBMS independent application development and deployment. Network Aware Record Retrieval Enabling the retrieval and insertion of multiple DBMS records in batches over the network with a minimal number of network hops.
    Security
    Rules Engine Based Security Alignment and enforcement of data access policies across facets of enterprise IS infrastructure. This includes any combination of; users, user roles, applications, operating systems, databases, machine aliases, and networks. Secure Data Transmission Enables development and utlization of encrypted data transmission between DBMS independent applications and backend databases.
    Administration Configuration and Management


    | Zero Configuration for ODBC DSNs | Provides a Cross Platform implementation of the Rendezvous service discovery protocol. This enables the configuration of ODBC Data Sources Names (DSNs) to be completely server based with no client side configuration whatsoever. You simply pick a DSN configuration associated with your OpenLink Request Broker from combo-box hosted list of OpenLink Services.

    Usability
    Wire Protocol Based Driver The use of the PostgreSQL wire-protocol facilitates direct connectivity from Driver to Database Server. This alleviates the need to install any additional client side networking software as part of the driver installation and configuration process Wire Protocol Based Driver The use of the PostgreSQL wire-protocol facilitates direct connectivity from Driver to Database Server. This alleviates the need to install any additional client side networking software as part of the driver installation and configuration process
    Usability
    Network Ready Enables usage of DBMS independent applications on any platform without installation of additional DBMS specific networking products. Generic Drivers Install one, as opposed to several, client components per data access standard and driver combination for your database independent applications.
    Administration Configuration and Management


    | Centralized Configuration & Management | A single point of focus when administering the data sources that serve the data access standards compliant applications.

    Standards Compliance


    | International character support | Enables the development and deployment of international applications that are independent of underlying database engine.

    Standards Compliance


    | ODBC 3.5 Compliance | Enables broad compatibility between an extensive collection of older and newer ODBC Applications across an array of platforms.

    Performance


    | Multithreaded | Enables exploitation of scalability benefits arising from the use of multiple CPUs or Clusters while developing or using DBMS independent applications.

    Standards Compliance
    Supports Advanced Data Access API functionality Enables the development and utilization of DBMS application with DBMS independent granularity that extends to challenging areas such as scalar function calls, dates and timestamps manipulation, outer join handling, and SQL stored procedure invocation etc. Complete ODBC Scrollable Cursor Model Support Provides ODBC compliant applications with a flexible model for handling sensitivity to data changes using the following scrollable cursor models: Forward-Only, Static, KeySet , Dynamic, and Mixed.