To activate Commerce Intelligence for on-premise subscriptions, first create a Commerce Intelligence account, enter your settings information, then connect Commerce Intelligence to your Commerce database.
To create your account, contact your Adobe Account Team or Customer Technical Advisor.
After your account has been created, check your email for an account notification email from The Magento BI Team@rjmetrics.com. Use the link provided in the email to access your Commerce Intelligence account and create your password. Go to your inbox and verify your email address.
If you did not receive an email, contact support.
Before you configure the database connection, complete the store information form. This information is required to complete the Connect your Database setup.
After you set your password and log into Commerce Intelligence, you can add other users to your Commerce Intelligence account. When adding users, add admin users with appropriate permissions to complete the activation process.
To use Commerce Intelligence, you must add a permanent and dedicated user to the Commerce project. This dedicated user serves as a permanent connection to Commerce that enables the fetch and transfer of new data to the account’s Commerce Intelligence Data Warehouse.
Configuring a dedicated Commerce Intelligence user ensures that the account is not deactivated or deleted, thus stopping the Commerce Intelligence connection.
Adobe encourages using an account name that indicate its permanent status (e.g., ACI-dedicated, ACI-database-connector, and so forth).
After you created the dedicated user for Commerce Intelligence in the Admin, add the same user to the primary environment of the Commerce project with a Master setting of
On the Connect your database page for Commerce Intelligence setup, scroll down and select Encryption settings.
For Encryption Type, select
From the drop-down, copy the public key that is provided.
From the Commerce Admin, sign in using the login information for the Commerce Intelligence user you just created.
Select the Account Settings tab.
Scroll down and expand the SSH Keys drop-down. Then, select Add a public key.
Paste the public key that you copied in the Encryption Type step above.
Get the database connection information to the Commerce database to Commerce Intelligence
Run the following to get your information.
echo $MAGENTO_CLOUD_RELATIONSHIPS | base64 --decode | json_pp
Review the database information, which should look similar to the following example.
Enter your Commerce Intelligence information in the Connect your Magento Database screen.
Integration Name: [choose a name for your Commerce Intelligence instance]
Password: [input password displayed in the previous section]
Table Prefixes: [leave blank if there are no table prefixes]
Desired Timezone: [choose the time zone for which you want your data to display]
The project UI provides an SSH access string. This string can be used for gathering the information needed for the Remote Address and Username. Use the SSH Access string by selecting the access site button on the Master branch of the Project UI. Then, find your User Name and Remote Address as shown below.
ssh.us-3.magento.cloud [from the previous step]
vfbfui4vmfez6-master-7rqtwti—mymagento [from the previous step]
After completing the configuration steps, apply the changes by selecting Save Integration.
You have now successfully connected your Commerce database to your Commerce Intelligence account.
If you are a Adobe Commerce Intelligence Pro customer, contact your Customer Success Manager or Customer Technical Advisor to coordinate the next steps.
After you complete the configuration, sign in to your Commerce Intelligence account.