Skip to main content

​
Intro

Magento Enterprise Edition is a high performance, scalable eCommerce solution for fast-growing and large businesses. It’s got the enterprise-class features and the flexibility you need to create an eCommerce solution tailored to your unique needs. And to help you drive more traffic to your store, convert browsers into buyers and boost online revenue. To learn more about the Magento API, visit their page http://www.magentocommerce.com/api/rest/introduction.html. You can connect to your Magento account in the Data Center. This topic discusses the fields and menus that are specific to the Magento connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.

​
Prerequisites

To connect to your Magento account and create a DataSet, you must have the following:
  • Domain
  • Consumer Key
  • Consumer Secret
  • Access Token
  • Access Token Secret

​
Connecting to Your Magento Account

This section enumerates the options in the Credentials and Details panes in the Magento Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Data Connector.

​
Credentials Pane

Magneto connector uses Oauth1.0a for authentication. This pane contains fields for entering credentials to connect to your Magento account. The following table describes what is needed for each field:

Field

Description

Domain

Enter your Magento installed domain (minus the protocol). For example, api.company.com.

Consumer Key

Enter your Consumer Key.

Consumer Secret

Enter your consumer secret.

Access Token

Enter your access token.

Access Token Secret

Enter your access token secret.

Once you have entered valid Magento credentials, you can use the same account any time to create a new Magento DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

​
Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the Magento report you want to run. The following reports are available:

Report Name Description

Customer

Returns the list of customers.

Order

Returns the list of sales orders.

Order Item

Returns the order items for all orders.

Product

Returns the list of products.

Stock Item

Returns the list of stock items.

Filter

Enter filters for the report, separate multiple filters by a ’;’. For example, ‘increment_id > 2345554’, ‘store_name!= Warehouse’, ‘entity_id between 1000 and 2000;subtotal < 56.00.

Reset Update

Select ‘Yes’ to reset the update flag. Resetting the flag will cause the data source to retrieve all available data, rather than just the new data from the last update.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.