The connection can be made locally or to the Gateway located on a separate machine. SQL Server treats the CData SQL Gateway as a linked SQL Server instance, so you can write full SQL queries to query your QuickBooks data without losing performance as would happen connecting to an ODBC data source directly. You can use SQL Linked Server to connect to the CData SQL Gateway. See the QuickBooks integration guides for information on connecting from other applications. See Using ODBC to connect to QuickBooks from the following programming languages and for information on the supported interfaces: See Using from Tools for information on using the ODBC driver in some of the popular applications and programming languages that connect via ODBC.
See Getting Started to create an ODBC data source name (DSN) and connect to QuickBooks from your platform.Īdvanced Features details additional features supported by the driver, such as defining user defined views, ssl configuration, remoting, caching, firewall/proxy settings, and advanced logging. Drivers for Windows, Linux, and macOS/OS X.Supports the Unicode ODBC APIs and ODBC 3.8.Supports 32-bit and 64-bit applications.Access, analyze, and report on data with your SQL-based tool of choice.The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more. Applications can then access QuickBooks as a traditional database. The driver wraps the complexity of accessing QuickBooks data in a standard ODBC driver compliant with ODBC 3.8. The CData ODBC Driver for QuickBooks enables real-time access to QuickBooks data, directly from any applications that support ODBC connectivity, the most widely supported interface for connecting applications with data.
0 kommentar(er)
