QuickBooks ODBC Driver Specifications
|
Read, write,update Customers, Transactions, Invoices, etc. through a standard ODBC Driver interface.
The QuickBooks ODBC Driver is a powerful tool that allows you to easily connect-to live QuickBooks data through any ODBC capable application or tool! The Drivers are completely self-contained; no additional software installation is required. All kinds of BI, Reporting, ETL, Database, and Analytics tools offer the ability to read and write data via ODBC connectivity. *Straightforward ODBC Connectivity -Access QuickBooks data through widely available tools - standard ODBC interface offering the -greatest accessibility from applications and developer technologies. -Advanced wire-protocol SSL security for remote connectivity -Faster application deployment and configuration -32-bit and 64-bit support -Build Apps That Connect To QuickBooks Desktop -Connect Office Tools with QuickBooks Desktop -Major development technology, including PHP, Python, Delphi, Visual Basic, PowerBuilder, FoxPro, FileMaker Pro, and more. -Powerful capabilities like 'Mail Merge', eliminating the need for complicated import/export procedures. -Support 32-bit and 64-bit applications and unicode ODBC APIs. -Easily Customizable and Configurable -Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications. -Certified Compatibility -ODBC Remoting: Allows hosting the ODBC connection on a server to enable connections from various clients on any platform (Java, .NET, C++, PHP, Python, etc.), using any standards based technology (ODBC, JDBC, etc.). ODBC Remoting is enabled using MySQL wire protocol server. -String, Date, Numeric SQL Functions: The driver includes a library of 50 plus functions that can manipulate column values into the desired result. Examples include Regex, JSON, and XML processing functions. -Collaborative Query Processing: Our drivers enhance the data source's capabilities by additional client-side processing, when needed, to enable analytic summaries of data. -Standards-Compliant ODBC: 3.8 compliant native protocol based drivers. -Secure Connectivity:Standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications. -The drivers include the optional ability to accept incoming SQL and MySQL client connections and service standard database requests.