Insights
Sources
Magento x Eyk
Magento is a top e-commerce platform perfect for Eyk users seeking to create flexible and scalable online stores. It offers powerful tools for managing products, orders, and customer data, along with extensive customization options and integrations.
With advanced SEO features and mobile-friendly design, Magento ensures your store is optimized for search engines and accessible on all devices. By using Magento, Eyk users can enhance the online shopping experience, increase sales, and drive business growth. Whether starting a new store or expanding an existing one, Magento provides the necessary features and scalability to meet your e-commerce needs.
Connect Magento to Eyk
Eyk connects to your Magento webshop backend via a direct MySQL database connection. Setting up Magento in Eyk requires a bit more effort compared to other sources. But we've got you covered! Follow the steps below to connect Magento and start gaining in-depth insights from your webshop backend.
Step 1 - Collect credentials
The following credentials are needed to set up the connection
Name | Description |
---|---|
The local address of the MySQL database on the host server, in most cases this will be 127.0.0.1 | |
The local port of the MySQL database on the host server, in most cases this will be the default MySQL port 3306 | |
The name of the MySQL database Eyk should connect to | |
The username of the user account within MySQL that will be used to access the database | |
The password of the user account within MySQL that will be used to access the database | |
The hostname of the server that is running the MySQL database | |
The port on which the server accepts SSH connections, in most cases this will be the default port used for SSH, port 22 | |
The username of an user account on the server that Eyk should connect as over SSH. In the next step we will configure access for this user | |
Optional field. The store view IDs to collect data for. Leave empty to collect data for all store views. |
Step 2 - Configure SSH access
To securely connect Magento to Eyk using public / private key encryption, you will need to add a public SSH key (provided below 👇) to the appropriate user account on the server. Below are the steps to achieve this, depending on your Magento setup.
Depending on your Magento set-up either step 2.1 OR step 2.2 is applicable. Some Magento hosting providers allow you to manage SSH public keys through their admin control panel.
If your Magento hosting provider has this functionality, the SSH key must be configured through the admin panel! Any SSH keys added directly on the server will be periodically overwritten.
If you don’t have a Magento hosting provider or your provider does not have SSH key management, you will need to add the key directly on the server in step 2.2
Step 2.1 - Using the admin panel of your Magento hosting provider
If your Magento hosting provider allows SSH key management through their admin control panel, follow these instructions:
- Log in to the Admin Control Panel: Use your credentials to access the hosting provider's control panel.
- Navigate to SSH Key Management: Find the section dedicated to SSH Key Management.
- Add the Public SSH Key:
- Paste the below public SSH key into the designated field
- Optionally give the SSH key a name like “Eyk”
- Apply or save the changes
AAAAB3NzaC1yc2EAAAADAQABAAABgQCXqGAIgzLG8qbkD/PavKfNFC3spzI2aYCRexJt8IM/gOwOrnYANrMIB+ZhN1qhJyWqhnqweruIHcQigIAHJ+V4IDmGFhv601YHjMpQob8PnrVq33JNGsIJ2rYnkAOdu3zBKHxUT855WM/4/yd9ZGo0koGK8AA8T8T/Cj1J3JZ2ZPS09kxytLLGBj2Pe+fw5+fA0rUPglQMuCJ6KdgBtdUA0SqVbbitgfLTO5w4lsiuH+KqFjmiy1rkmxTAqIKHIFY4pcDEEi8X8mIAE8eFs6UOZV2kJzaaOf6PeX5b+qelXddqbfHkjI3w/w1V944XIJA9SFwnGpkrJVtgc8Nmcu4TQEKug4Q/zuCG94/uh5NsEubLlYbrMLvs47jBJ2MoIPI+lOc8k23nZbwSxNQ41FpcU4xxnPZSIwewr/usxCziLlT3CZ/EuN9jrikbHMe0AQLcdmXr7NZmiGTHs2E7hX6zrHpHaXs2+FJwJT//ttP5w+nv1KTEHgqKvPCYrYpe3N0= support@eykdata.com
Step 2.2 - Directly on server
If your Magento hosting provider does not support SSH key management through an admin panel, or if you don’t have a hosting provider, follow these steps to add the SSH key directly on the server.
Navigate to the home directory of the user
On the server where the the MySQL database is running, navigate to the home directory of the user (corresponding with the SSH Username) by running the following command:
cd /home/{{SSH Username}}
Ensure the .ssh directory exists
Run this command from the home directory of the SSH user:
mkdir -p .ssh
Add the Eyk public SSH key to authorized_keys
Run this command from the home directory of the SSH user:
echo ssh-rsa "AAAAB3NzaC1yc2EAAAADAQABAAABgQCXqGAIgzLG8qbkD/PavKfNFC3spzI2aYCRexJt8IM/gOwOrnYANrMIB+ZhN1qhJyWqhnqweruIHcQigIAHJ+V4IDmGFhv601YHjMpQob8PnrVq33JNGsIJ2rYnkAOdu3zBKHxUT855WM/4/yd9ZGo0koGK8AA8T8T/Cj1J3JZ2ZPS09kxytLLGBj2Pe+fw5+fA0rUPglQMuCJ6KdgBtdUA0SqVbbitgfLTO5w4lsiuH+KqFjmiy1rkmxTAqIKHIFY4pcDEEi8X8mIAE8eFs6UOZV2kJzaaOf6PeX5b+qelXddqbfHkjI3w/w1V944XIJA9SFwnGpkrJVtgc8Nmcu4TQEKug4Q/zuCG94/uh5NsEubLlYbrMLvs47jBJ2MoIPI+lOc8k23nZbwSxNQ41FpcU4xxnPZSIwewr/usxCziLlT3CZ/EuN9jrikbHMe0AQLcdmXr7NZmiGTHs2E7hX6zrHpHaXs2+FJwJT//ttP5w+nv1KTEHgqKvPCYrYpe3N0= support@eykdata.com" >> .ssh/authorized_keys
Step 3 - Add Magento in Eyk
To complete this final step, first go to your Eyk environment
Then go to the page for adding Magento, either through one of the pre-built insights that are powered by data from Magento or through the sources page, and fill in the credentials you collected in Step 1.
When all fields have been filled in, click the Add source button to continue.
Eyk will now check if the connection with the database can be made and you will be taken to the following page where updates will be given on the status of the first sync of data from your Magento database into your data warehouse.
After the data has been synced to your data warehouse, the insights that you have selected in your Eyk environment (for instance Online Store Performance or RFM segmentation), will be automatically loaded.
Available insights
The Magento source directly feeds into our Online Store Performance and RFM Segmentation insights!
← Previous
Next →