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 |
Step 2 - configure SSH access
To securely connect through public / private key encryption, the following public SSH key will need to be added for the user account on the server (this is the same user account for which the SSH Username was collected in the previous step).
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
mkdir -p .ssh
Add the Eyk public SSH key to authorized_keys
echo ssh-rsa "AAAAB3NzaC1yc2EAAAADAQABAAABgQCXqGAIgzLG8qbkD/PavKfNFC3spzI2aYCRexJt8IM/gOwOrnYANrMIB+ZhN1qhJyWqhnqweruIHcQigIAHJ+V4IDmGFhv601YHjMpQob8PnrVq33JNGsIJ2rYnkAOdu3zBKHxUT855WM/4/yd9ZGo0koGK8AA8T8T/Cj1J3JZ2ZPS09kxytLLGBj2Pe+fw5+fA0rUPglQMuCJ6KdgBtdUA0SqVbbitgfLTO5w4lsiuH+KqFjmiy1rkmxTAqIKHIFY4pcDEEi8X8mIAE8eFs6UOZV2kJzaaOf6PeX5b+qelXddqbfHkjI3w/w1V944XIJA9SFwnGpkrJVtgc8Nmcu4TQEKug4Q/zuCG94/uh5NsEubLlYbrMLvs47jBJ2MoIPI+lOc8k23nZbwSxNQ41FpcU4xxnPZSIwewr/usxCziLlT3CZ/EuN9jrikbHMe0AQLcdmXr7NZmiGTHs2E7hX6zrHpHaXs2+FJwJT//ttP5w+nv1KTEHgqKvPCYrYpe3N0=" >> .ssh/authorized_keys
Great job so far! The server that is running the MySQL database is now configured in a way that only the Eyk platform is able to connect to it over an encrypted connected 🔐
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.
In addition, Eyk will ask you for:
- How Personal Identifiable Information data (PII data) should be handled:
- Off: no masking - all data will be synced to your data warehouse
- Hash: PII data will be hashed - so that it cannot be related to a person anymore, but can be matched between rows in the database (eg. you can still recognise if two accounts have the same email address)
- Stars: include the columns, but replace all values with some asterisks symbols (*******)
- Remove: remove the columns altogether before the data enters the data warehouse
- The refresh rate: how ofter should Eyk refresh the data in your data warehouse
When all fields have been filled in, hit the “Add source” button to complete adding.
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 Ecommerce Performance or Ecommerce Attribution), will be automatically loaded.
Next step: connect one of Eyk’s pre-built Looker Studio templates and start analysing! 🏆