ODBC Driver for WooCommerce

Build 20.0.7587

Windows DSN Configuration

Using the Microsoft ODBC Data Source Administrator

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.

Complete the following steps to edit the DSN configuration:

  1. Select Start > Search, and enter ODBC Data Sources in the Search box.
  2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
  3. Click the System DSN tab.
  4. Select the system data source and click Configure.
  5. Edit the information on the Connection tab and click OK.

Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2017 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

Connecting to WooCommerce

WooCommerce supports the following authentication methods: Basic Authentication, one-legged OAuth1.0 Authentication and standard OAuth2.0 Authentication.

Additionally, in order to connect to WooCommerce, you also must specify the URL of the instance to connect to.

Connecting using Basic Authentication

Some plugins and some servers may interfere with the Authorization header, if not configured properly.

For these cases, Basic authentication may be used. In this authentication mode, the user provides the consumer_key and the consumer_secret as user and password respectively.

These credentials are then sent as query parameters with each request.

Specify the following properties:

  • User - Set this to your consumer key
  • Password - Set this to your consumer secret
  • Url - Set this to the base URL of the WooCommerce instance to connect to.

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
  • Url - Set this to the base URL of the WooCommerce instance to connect to.

Connecting using WordPress OAuth 2.0 Authentication

After having configured the OAuth2 Plugin plugin, you may connect to WooCommerce by providing the following connection proeprties:

  • OAuthClientId
  • OAuthClientSecret
  • CallbackURL
  • InitiateOAuth - Set this to either GETANDREFRESH or REFRESH
  • Url - Set this to the base URL of the WooCommerce instance to connect to.

In addition to the above connection parameters, you can optionally set the AuthScheme parameter to force the preferred authentication scheme.

  • AuthScheme - Set this to either Basic, OAuth or OAuthOneLegged, depending on your preferred authentication method.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587