Uda Wiki Web

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

    uda.odbc.express





    Single-Tier (Express Edition)





    Single-Tier (Express Edition)
    OpenLink Express Edition drivers enhance the common perception of an ODBC driver - a single component installed on the desktop or workstation machine only - by not requiring any further installation of database-specific networking on the client, or components on the database-server. Once installed, it provides seamless connectivity to the databases.

    The OpenLink Express Edition drivers have been designed in harmony with Apple''s Mac Universal Platform. Maximum capability, minimum effort.

    The OpenLink Express Edition driver is a client-only installation and goes some way to ensure the job for developers, administrators and end-users is simplified. Part of this process means installing the software in one location as opposed to numerous locations. By discarding the server-side setup, there is no server-side administration so the user has only a single entry-point for installation and administration. In the majority of cases, knowing the database by name is all that is required.

    To the developer writing an application, there is no requirement to know on which server it resides: you can write your application for any environment, regardless of where it will end. There are also performance benefits gained by employing this single solution, which in some cases exceeds that provided by the database vendor drivers. Being able to integrate your solution simply into your organization with its plethora of internal and disparate systems means your ROI increases significantly.

    These drivers are built by implementing the ODBC data-access interface specifications directly connecting to the database. There are no limiting factors as with traditional Single-Tier solutions.

    The Express Edition drivers are Type-B - C-based remote procedure calls (RPC) interface to the wire-protocol of the underlying database. This is a client-only interface that communicates directly with the remote database server. These interfaces typically are unavailable to third-party developers. To date the Open Source projects such as FreeTDS , MySQL , PostgreSQL , and Interbase are the only publicly accessible and freely available versions of such interfaces.

    The ODBC Express Edition drivers offer developers an opportunity to develop generic solutions across platforms without prior knowledge of the operating system hosting the Database server.

    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.
    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.