Connecting to Magento

Magento is an open-source digital commerce platform written in PHP.

Data integration: Skyvia supports importing data to and from Magento, exporting Magento data to CSV files, replicating Magento data to relational databases, and synchronizing Magento data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Magento backup.

Query: Skyvia Query supports Magento.

 

To connect to Magento, you need to specify the url to connect to and the user name and password to login.

magento-connection-editor

You need to specify the following parameters for Magento connection:

Name - connection name that will be used to identify the connection on the Connections page and when selecting a connection for a package.
Domain - the address of your Magento store.
Service Version - Magento version to connect to.
User - the user name to login with.
Apikey - an automatically generated key that is used for connecting to Magento. You can find the API Key in the User information section of your Magento dashboard.
Metadata Cache - Determines how often to update cached metadata for the connection. By default, Skyvia caches metadata of available objects for cloud sources. You can configure how often the cache is refreshed automatically or reset in manually on the Connection Details page of the corresponding connection by clicking the Clear link in the Metadata cache parameter in the Parameters pane. The following values are available for this setting:
oDisabled - the metadata cache is not created, and metadata are queried automatically whenever the connection is opened.
oOne Hour - the metadata cache expires after one hour since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Day - the metadata cache expires after one day since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Week - the metadata cache expires after one week since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Month - the metadata cache expires after one month since the previous refresh, and it is refreshed after this when the connection is opened.
oInfinite - the cache is never reset automatically. Default value.