How to Connect to Optimizely Configured Commerce Database Using Mission Control
Uddhav Gurav
Technical Lead - Optimizely
April 3, 2025
Table of Contents
The global marketplace requires businesses to have complete access to their data to optimize their eCommerce operations. Optimizely Configured Commerce is a complete digital storefront management tool, and database access security is essential for performing analytics, generating reports, and investigating system issues.
This blog covers the complete method for accessing the Optimizely Configured Commerce Database through Mission Control. The step-by-step guide enables users to simplify database connections by properly implementing Optimizely security measures.
Discover Our Optimizely Solutions Today!
Prerequisites
Before you begin, ensure that you have the following prerequisites in place:
- Access to Opti ID – You can obtain this from your Optimizely Customer Success Manager (CSM).
- Installed Azure Data Studio – This tool is required for database connectivity. If you haven’t installed it, download the installer and complete the setup. (Installer)
Step-by-Step Guide to Accessing the Optimizely Configured Commerce Database
Step 1: Navigate to Mission Control
Start by accessing the Optimizely Mission Control portal:
- Open your browser and visit Mission Control – https://mission-control.cloud.insitehq.net/customers
- You will be prompted to log in using your Opti ID.
Step 2: Select a Customer/Client
Once logged in:
- Choose the customer/client account you wish to connect to.
- This step ensures you target the correct environment within your Optimizely instance.
Step 3: Select the Database Instance
After selecting the customer:
- Navigate to their dashboard, where you will see an option to choose a specific instance.
- If only one environment is available (such as a sandbox), select it.
Step 4: Generate Database Credentials
To proceed:
- Click on the Actions button located on the left-hand side navigation panel.
- Choose the option to Generate Database Credentials.
- The system will take a couple of minutes to process your request.
- Once complete, you will receive the credentials in the following format:
- Server Name
- Database Name
- Username
- Password
Step 5: Connect via Azure Data Studio
With your credentials ready:
- Open Azure Data Studio.
- Enter the details obtained from Optimizely Mission Control.
- Ensure that the Authentication Type is set to SQL Login.
- Copy and paste the credentials carefully (avoid copying extra spaces by mistake).
Important Notes
- The credentials provided by Optimizely are read-only. You cannot execute INSERT, DELETE, or UPDATE statements.
- The SQL credentials are valid for only 30-60 minutes and expire automatically, even if the session remains active.
- If credentials expire, you must regenerate them following the abovementioned process.
Why This Matters for Your Business
Accessing your Optimizely Configured Commerce Database securely ensures that you can:
- Generate essential performance insights for monitoring purposes and reporting procedures.
- Enhance decision-making based on data to make it efficient through direct access to real-time information.
- Streamline integrations with business intelligence tools for deeper analytics.
By following this structured approach, you ensure data security, maintain compliance, and maximize the potential of your eCommerce platform.
Partner with Royal Cyber for Enhanced Optimizely Solutions
Royal Cyber assists business clients by specializing in Optimizely solutions to optimize their digital transformation projects. Our team helps organizations with their database access, platform integration, and advanced analytics implementation needs.
Optimizely implementation enhancement options exist here for companies seeking additional services. Contact us now to assess business solutions that match your organizational needs.
Author
Poonam Chandersy
Talk With Our Expert
Recent Blogs
Websites used to be something you built once and basically forgot about. That doesn’t work …Read More »- Websites used to be something you built once and basically forgot about. That doesn’t work …Read More »
- Learn how to plan an Optimizely CMS 13 upgrade with .NET 10, Optimizely Graph, Visual …Read More »
