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++ 2015-2022 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

Connecting to Magento 2.x

To connect, set the URL; for example, http://yoursitename/magento2, and optionally provide the StoreCode of the store you are connecting to, if more than one are present.

Authenticating to Magento

To authenticate to Magento 2.x server versions, you can use either the Basic or the Token AuthScheme.

Basic

• AuthScheme Set this to Basic.
• User Set this to your user name in Magento.
• Password Set this to your password in Magento.

Access Token

• AuthScheme Set this to Token.
• AccessToken Set this to your AccessToken in Magento.

To generate the AccessToken, Log in to the Magento Stores > Settings > Configuration > Services > OAuth > Access Token.