We are proud to share our inclusion in the 2024 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition reflects the differentiated business outcomes CData delivers to our customers.
Get the Report →Use the CData ODBC Driver for WooCommerce in SAS JMP
You can use the CData ODBC Driver to integrate WooCommerce data into the statistical analysis tools available in SAS JMP. This article shows how to use WooCommerce data in the Graph Builder and Query Builder.
You can use the CData ODBC Driver for WooCommerce to integrate live data into your statistical analysis with SAS JMP. The driver proxies your queries directly to the WooCommerce API, ensuring that your analysis reflects any changes to the data. The CData ODBC Driver supports the standard SQL used by JMP in the background as you design reports.
The WooCommerce API supports bidirectional access. This article shows how to access WooCommerce data into a report and create data visualization. It also shows how to use SQL to query and manipulate WooCommerce data from the JMP Query Builder.
Access WooCommerce Data as an ODBC Data Source
If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.
WooCommerce supports the following authentication methods: one-legged OAuth1.0 Authentication and standard OAuth2.0 Authentication.
Connecting using one-legged OAuth 1.0 Authentication
Specify the following properties (NOTE: the below credentials are generated from WooCommerce settings page and should not be confused with the credentials generated by using WordPress OAuth2.0 plugin):
- ConsumerKey
- ConsumerSecret
Connecting using WordPress OAuth 2.0 Authentication