About this product
ODBC Driver for WooCommerce by Devart connects ODBC-compliant reporting, analytics, BI and ETL tools directly to live data in a WooCommerce store. The driver reaches the WooCommerce API over HTTPS. If direct HTTPS access is not available, you can connect through a proxy server.
You query the data with SQL. The driver supports extended SQL-92 SELECT syntax with JOINs, subqueries, GROUP BY, aggregate functions and ORDER BY, as well as INSERT, UPDATE and DELETE. It also offers full Unicode support, local data caching and connection pooling. The standalone installer needs no extra client software and works on 32-bit and 64-bit Windows with both 32-bit and 64-bit applications.
Who it is for
- Store owners and analysts who report on WooCommerce orders, products and customers in Excel, Power BI, Tableau or QlikView
- Developers who access WooCommerce via ODBC from Python, PHP, Visual Studio or C++Builder
- Users of Access, FileMaker, DBeaver or LibreOffice who work with WooCommerce data
Licensing
The Desktop edition may be installed on a single desktop computer used by one person at a time. If several users need access at the same time, Devart offers separate Server editions.
- Perpetual License: lets you use the purchased version indefinitely, with offline activation. It comes with support and upgrades for the base term or for 2 or 3 years.
- Perpetual Renewal: extends support and upgrades for an existing perpetual license for the base term, 2 years or 3 years.
- Subscription: lets you use the software for the length of the term (base term, 2 or 3 years). Activation and license checks need an internet connection.
- Premium Support included: each of these options is also available with Premium Support.
Delivery
This product is delivered electronically (ESD). You receive the license key and download details by email once your order has been processed. The software is in English and runs on Windows.