Activate your MBI Account for Cloud Starter Subscriptions

To activate MBI for Cloud Starter projects, first create an MBI account, then create a SSH key, then finally connect to your Commerce database. See activating on-premise subscriptions.

1. Create your MBI Account.

   • Go to Adobe Commerce account login

   • Go to My Account > My MBI Instances.

   • Click Create Instance. If you do not see this button, contact your Adobe Account Team or Customer Technical Advisor.

   • Select your Cloud Starter subscription. If you only have a cloud starter subscription, this is the default selection.

   • Click Continue.

   • Input your information to create your account.

   

   • Go to your inbox and verify your email address.

   

   • Create your password.

   

   • After creating your account, you can add users to your new account. Technical admins can now be added to carry out the following steps.

   

2. Input information about your store to set your preferences.

   

   Gather some information before you can connect your database for the third step in the onboarding flow. You complete the Connect your database page in Step 9.

3. Create dedicated MBI User.

   • Create a user in your Adobe Commerce account.

   • Why a new user? MBI needs a user added to the project to continuously fetch new data to be transferred to the account’s MBI Data Warehouse. This user serves as that connection. Adding this user to the project is covered in Step 4.

   • The reason for having a dedicated MBI user is to prevent the added user from inadvertently being deactivated or deleted and stopping the MBI connection.

4. Add the newly created user to the project’s primary environment as a Contributor.

   

5. Get your MBI SSH keys.

   • Go to the Connect your database page of the MBI setup user interface and scroll down to Encryption settings.

   • For the Encryption Type field, choose SSH Tunnel.

   • From the dropdown, you can copy and paste the provided MBI Public Key.

   

6. Add your new MBI Public key to the MBI user created in Step 5.

   • Go to your cloud Adobe Commerce account. Sign in with your account login information for the new MBI user created. Then go to the Account Settings tab.

   • Scroll down the page and expand the dropdown for SSH keys. Then click Add a public key.

   

   • Add the MBI SSH Public Key from above.

   

7. Provide MBI MySQL credentials.

   • Update your .magento/services.yaml

   mysql:
       type: mysql:10.0
       disk: 2048
       configuration:
           schemas:
               - main
           endpoints:
               mysql:
                   default_schema: main
                   privileges:
                       main: admin
               mbi:
                   default_schema: main
                   privileges:
                       main: ro
   

   • Update your .magento.app.yaml

           relationships:
               database: "mysql:mysql"
               mbi: "mysql:mbi"
               redis: "redis:redis"
   

8. Get information for connecting your database to MBI.

   Run
   echo $MAGENTO_CLOUD_RELATIONSHIPS | base64 --decode | json_pp

   to get information on connecting your database.

   You should receive information similar to the output below:

           "mbi" : [
                 {
                    "scheme" : "mysql",
                    "rel" : "mbi",
                    "cluster" : "vfbfui4vmfez6-master-7rqtwti",
                    "query" : {
                       "is_master" : true
                    },
                    "ip" : "169.254.169.143",
                    "path" : "main",
                    "host" : "MBI.internal",
                    "hostname" : "3m7xizydbomhnulyglx2ku4wpq.mysql.service._.magentosite.cloud",
                    "username" : "mbi",
                    "service" : "mysql",
                    "port" : 3306,
                    "password" : "[password]"
                 }
              ],
   

9. Connect your Commerce Database

   

   • Integration Name: [Choose a name for your integration.]

   • Host: MBI.internal

   • Port: 3306

   • Username: mbi

   • Password: [input password provided in the output for Step 8.]

   • Database Name: main

   • Table Prefixes: [leave blank if there are no table prefixes]

10. Set your Timezone Settings.

    

    • Database: Timezone: UTC

    • Desired Timezone: [Choose the time zone for which you want your data to display in.]

11. Get information for your encryption settings.

    • The project UI provides an SSH access string. This string can be used for gathering the information needed for Remote Address and Username in setting up your Encryption settings. Use the SSH Access string found by clicking the access site button on your Primary branch of your Project UI and find your User Name and Remote Address as shown below.

    

    

12. Input information for your Encryption settings

    

    Inputs

    • Encryption Type: SSH Tunnel

    • Remote Address: ssh.us-3.magento.cloud

    • Username: vfbfui4vmfez6-master-7rqtwti--mymagento

    • Port: 22

13. Click Save Integration.

14. You have now successfully connected to your MBI account.

15. After you have successfully connected MBI to your Commerce database, contact your Adobe Account Team to coordinate the next steps, such as setting up integrations and other configuration steps.

16. When you finish configuration, you can sign in to your MBI account.

Business.Adobe.com resources