Über Devart ODBC Driver for QuickBooks Desktop

Zuverlässiger und einfach zu bedienender Datenkonnektor für QuickBooks Desktop.

Devart ODBC Driver for QuickBooks Desktop is a high-performance connectivity tool with enterprise-level features for accessing QuickBooks Desktop from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows. The ODBC driver fully supports standard ODBC API functions and data types and enables easy access to live QuickBooks Desktop data from anywhere.

Features

  • Connection to QuickBooks Desktop - This data connector enables various ODBC-aware applications to connect to QuickBooks Desktop directly via HTTPS. If you have no direct access to QuickBooks Desktop via HTTPS, you have the option of establishing a connection through a proxy server.
  • Extended SQL Syntax - The ODBC driver provides an unrivalled opportunity to work with QuickBooks Desktop objects just as with SQL tables. The extended SQL syntax allows you to use all the SQL benefits in SQL-92 compatible SELECT statements:
    • Complex JOINs.
    • WHERE conditions.
    • Subqueries.
    • GROUP statements.
    • Aggregation functions.
    • ORDER statements.
  • Fully Unicode-Compliant Driver - You can retrieve and modify any data in multilingual QuickBooks Desktop databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.
  • ODBC Conformance - The driver provides full support for the ODBC interface, its functions, and data types. It offers advanced connection string parameters and allows any ODBC compliant desktop or web application to connect to QuickBooks Desktop from various environments and platforms.
  • DML Operations - Devart ODBC Driver for QuickBooks Desktop provides support for DML which allows you to modify data in QuickBooks Desktop the same way as in SQL databases:
    • INSERT.
    • UPDATE.
    • DELETE.
  • QuickBooks Desktop Compatibility - The ODBC driver has full support for QuickBooks Desktop field data types and, moreover, the driver is compatible with the QuickBooks Desktop API itself.
  • Advanced Data Conversion - Advanced Data Conversion mechanisms have been implemented that provide bi-directional mapping between any QuickBooks Desktop and ODBC data types.