Why would you want to do this? Read on… Is QuickBooks Really Just Another Database Application? In fact, this is a good way to create a data warehouse of your QuickBooks data. Because of this fact, we can access QuickBooks data using SQL statements to perform all kinds of useful tasks with our QuickBooks data. You can think of QODBC as the master key that unlocks access to your QuickBooks transactional and master data, using programs other than QuickBooks such as Excel, Access and SQL server.Īs you can see, QuickBooks is in reality a database application. The ODBC application programming interface used in this article is QODBC, from Flexquarters. QuickBooks Desktop utilizes a proprietary database engine that requires a proprietary ODBC connection (unless you are using QuickBooks Enterprise). If you are interested, there is a much longer explanation of ODBC and its origin on Wikipedi. Open Database Connectivity (ODBC) is an application programming interface for gaining access to database systems. Leveraging your QuickBooks data using ODBC can unleash your organization's analytics capability and create new profitable insights.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |