Uda Wiki Web

  • Topic
  • Discussion
  • UdaWikiWeb.Udaudaoledb(Last) -- Owiki? , 2016-08-19 15:01:28 Edit owiki 2016-08-19 15:01:28

    uda.oledb

    OLEDB Data Providers

    OLEDB Data Providers
    OLE DB is a set of COM-based interfaces that expose data from a variety of sources. OLE DB interfaces provide applications with uniform access to data stored in diverse information sources, or data stores. These interfaces support the amount of DBMS functionality appropriate to the data store, enabling the data store to share its data.

    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.

    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.

    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.