Generate Database Credentials

  • Updated

Mission Control is currently in beta, which is open to all partners of Optimizely Configured Commerce and invite-only for some customers. If you do not have access to Mission Control, Optimizely Support can run these actions on your behalf. Contact them with the needed configuration details and field values (if applicable).

For information on the Mission Control beta or to request access, contact your Customer Success Manager.

You can generate read-only credentials in Mission Control for the target instance’s database in Optimizely Configured Commerce that remain active for 1 hour. These credentials let you explore the database and perform read-only queries against it.

This action provides credentials to the target instance’s database, not a copy. Because of this, running queries could impact performance for the given instance if the queried dataset is large enough. To help avoid potential performance concerns when querying data, you should avoid large select queries, long-running queries, or anything that would read a large amount of data. This is especially important when using this action on production instances. If you have questions or concerns about querying the database, contact Optimizely Support.

Steps

  1. Log into Mission Control.
  2. Go to Customers and select a customer.
  3. Select a target Configured Commerce instance.
  4. Click Actions on the instance page and select Generate Database Credentials.
  5. (Optional) Schedule the action by toggling Scheduled Execution to On and selecting a time and date.
  6. Review the details to confirm the selected instance (and scheduled time, if selected). ou can ignore any greyed-out or immutable fields because they are for development or debugging.
  7. Click Continue. If scheduled, the action runs at the specified time. Otherwise, the action runs immediately.
  8. Wait until the status is marked as Complete on the Action Request page. The action outputs the necessary credential details under Action Request > Results. These credentials are active for 1 hour.

    If the action fails, submit a ticket with Optimizely Support with a link to the failed action request page.