Configure a Connection Profile

From the CData ribbon, click Get Data and select From AdobeCommerce connection/s to launch the CData Query window. To setup a new connection, you will have to click the New AdobeCommerce Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to AdobeCommerce

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 AdobeCommerce

To authenticate to AdobeCommerce 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 AdobeCommerce.
• Password Set this to your password in AdobeCommerce.

Access Token

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

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

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to AdobeCommerce you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

• Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
• Using the Excel Add-In: Find other ways to interact with AdobeCommerce data, such as using the available CData Excel Functions.