Atlas Data Federation and Online Archive Can Now Be Deployed in Azure

This post is also available in: Deutsch, Français, Español, Português, Italiano, 한국어, 简体中文.

Exciting developments are on the horizon for users of Microsoft Azure, marking a significant leap in data management capabilities. First off, Atlas Data Federation is now Generally Available on Azure. This means you can now deploy it directly within Azure and even query data from Microsoft Azure Blob Storage. And that's not all. We've also launched the General Availability of Atlas Online Archive on Azure. These advancements usher in a new era of efficient archiving solutions for Azure-based data solutions.

Both updates are big steps forward in making data management on Azure more powerful and flexible. Let's dive into what this means for you!

Azure support in Atlas Data Federation (General Availability)

With Atlas Data Federation, users can seamlessly query, transform, and create views across multiple Atlas databases and cloud object storage solutions, such as Amazon S3 and now Microsoft Azure Blob Storage. This feature, previously exclusive to AWS, is a game-changer, allowing direct deployment within Azure and the ability to tap into Microsoft Azure Blob Storage for data insights.

Figure 1: Tap into Azure Blob Storage easily from the Atlas UI

Key features of Atlas Data Federation

  • Cloud flexibility: Choose between AWS and Azure for hosting federated database instances.
  • Diverse data sources: Incorporate MongoDB Atlas clusters or Azure storage solutions (Azure Blob Storage and Azure Data Lake Storage Gen2) as data sources for comprehensive queries, including cross-region.
  • Advanced aggregation: Comprehensive aggregation capabilities with operators inclusive of $match, $lookup, $queryHistory, $merge, $out, etc.
    • Direct $out support for Azure Blob Storage and Azure Data Lake Storage Gen2.
  • Atlas SQL queries on Azure: Execute SQL queries on Azure, integrating MongoDB data for a unified analysis experience.

Atlas Data Federation simplifies accessing and analyzing complex data sets by combining data across multiple sources into a single, federated view, providing valuable insights for more informed business decisions.

Explore Atlas Data Federation on Azure Today.

Azure support in Atlas Online Archive (General Availability)

Atlas Online Archive's expansion to Azure ensures that data tiering is not only efficient but also integrated, keeping archival data within the Azure ecosystem. This integration addresses the previous limitation of defaulting to AWS for storage, even for Azure-hosted clusters.

Figure 2: Seamlessly select Azure when choosing a region

Key features of Atlas Online Archive

  • Provider choice: Opt for AWS or Azure to align with your cloud strategy.
  • Automatic archiving: Set rules to move older data to cost-effective cloud storage automatically, eliminating manual offloading.
  • Unified querying endpoint: Access all data through a single endpoint, ensuring quick insights without compromising data availability.
  • Integrated MongoDB Atlas UI management: Manage your data tiering and archiving within the familiar Atlas interface, streamlining operations and maintenance.

Seamlessly manage your MongoDB Atlas data tiering at scale with Atlas Online Archive. Atlas Online Archive empowers you to manage your data lifecycle efficiently, balancing cost and accessibility with ease.

Finally, here are a few points to consider:

  • Any newly created archive on an Azure cluster on or after 02/28 will default to Azure regions. Note that storage regions for Online Archive will default to Azure clusters only if there are no pre-existing AWS archives on that specific Azure cluster
  • If there are any pre-existing AWS Online Archives on Azure clusters, then all newly created archives on that specific cluster will remain on AWS.
  • Cloud providers or storage regions cannot be edited or modified once configured

Embrace the Full Potential of Atlas Online Archive on Azure Today.

We're thrilled to support your data management journey, offering enhanced control and flexibility over your data through these new Azure capabilities. As MongoDB Atlas continues to expand as a multi-cloud solution, we're here to ensure your data strategy is as dynamic and versatile as your business needs.

For guidance on getting started, check out our documentation on Atlas Data Federation or Atlas Online Archive.

Thank you for trusting MongoDB Atlas as your Developer Data Platform. Welcome to the future of multi-cloud data management!

← Previous

They Asked, We Answered: A Q&A on Joining MongoDB’s Remote Solutions Center

Our Remote Solutions Center (RSC) team offers those with technical backgrounds interested in working with customers an opportunity to jumpstart a career in pre-sales. We asked Soheyl Rafi, Solutions Architect and former Remote Solutions Center team member, some common questions candidates have about joining the team. What is the day-to-day like on the Remote Solutions Center team? Working in the Remote Solutions Center is a dynamic and ever-changing experience, with each day bringing unique challenges and opportunities. You can expect a blend of calls, hands-on activities, customer interactions, and problem-solving. The variety keeps the role super interesting. Part of the diverse work environment comes from the collaboration that this role inherently entails. Throughout the day, you’ll engage in various customer interactions such as discussing project requirements and challenges to proposing tailored solutions. Another aspect could be your involvement in Technical Feasibility Workshops with customers. This is where your deep technical knowledge comes into play. You’ll be addressing intricate technical questions, providing insights, and ensuring that our solutions align with the customer’s needs. Enablement also plays a pivotal part in the day-to-day. You will spend a lot of time learning new technologies and features released by our Product team, understanding the competition, and staying abreast of the market as a whole. All in all, the day-to-day work is extremely diverse, and you’ll need to both enjoy and be comfortable wearing multiple hats. What can I expect during the onboarding phase? When you join the RSC, you can expect a comprehensive onboarding experience that covers both technical and sales aspects. Our onboarding plan is designed to provide hands-on training, ensuring that you become familiar with MongoDB technology and business processes. From a technical standpoint, you’ll have access to detailed training sessions and resources. You’ll be guided through the intricacies of our products and services, allowing you to build a strong foundation in your technical knowledge. On the sales front, we have a tailored onboarding plan that focuses on honing the skills required for successful client engagement. This includes understanding our market positioning, customer needs, and effective sales strategies. You will be exposed to real-world scenarios and practical exercises to enhance your sales acumen. To complement your onboarding experience, each new team member is paired with a more senior peer within the RSC. This mentorship helps you begin to build relationships within the team and provides valuable insights and guidance on navigating the role effectively. In addition, RSC leadership recognizes the importance of learning from industry veterans. That’s why each new hire is also paired with a seasoned professional from outside the RSC who acts as a Solution Architecture buddy. This experienced mentor with tenure in the industry will offer a unique perspective and share valuable insights to accelerate your learning. To gain practical exposure, you will have the opportunity to shadow calls and workshops conducted by experienced team members. This hands-on approach allows you to observe firsthand how we conduct business, manage client interactions, and collaborate within the team. In summary, our onboarding program within the RSC is a holistic approach that combines technical training, sales development, mentorship, and practical experience. How often can I expect to collaborate with Solutions Architects (SAs) in the field? As an SA within the RSC, collaboration with SAs in the field is consistently high. We are strategically positioned around account activities and proactively engage with our counterparts in the field teams. Depending on the opportunity during an engagement, you might assist in the early stages of the sales cycle, such as discovery and demos, before passing the deal onto the field SA. Collaboration in these engagements is pivotal, requiring alignment to ensure a seamless handover to the field teams. What internal career development opportunities are there for me? Upon joining the RSC team, you’ll immerse yourself in a dynamic learning environment. Unlike traditional career structures, the RSC team fosters an environment where you are in the driver’s seat, dictating the pace of your internal career development. No artificial roadblocks hinder you from taking on more challenging and senior-level tasks. Your dedication, skills, and initiative are the primary determinants of how quickly you progress. While there are specific tasks you’ll work on in your day-to-day, you’ll also have a wide range of internal projects available to enhance your skill sets and advance your career within MongoDB. In a team with diverse interests and skills, you can choose projects that align with your passion and interests. You’ll find yourself in a situation with structured learning paths, mentorship programs, project leadership opportunities, and a career trajectory limited only by your aspirations. In my career journey, I’ve achieved my goal of growing from an Associate SA to being promoted to a Solutions Architect for our enterprise customers. I am now a dedicated Solutions Architect to one of our biggest financial customers, helping them in their digital transformation and expanding their MongoDB footprint. What new things will I learn if I join the team? The question should be, “What will you not learn?” Databases are at the center of every tech stack. You will be exposed to and gain an understanding of the entire tech stack, including the underlying infrastructure and the application that will be built on top of MongoDB. In your role, you’ll find yourself engaging with customers to discuss the various technologies used in application development, the infrastructure decisions made, and other database solutions that are either part of their tech stack or under consideration. Each customer employs different methodologies for developing software and utilizes various programming languages and solutions. It is pivotal as an SA in the RSC to comprehend these diverse solutions and effectively communicate them to our customers. Beyond the technical aspects, you will start to see things from a macro perspective. Understanding your customer’s business is crucial. You will need to learn how to align technical solutions with business objectives, considering factors such as budget, timelines, and return on investment. Learn more about applying your technical skills and engaging with customers as part of our Remote Solutions Center.

February 28, 2024
Next →

Announcing DirectQuery Support for the MongoDB Atlas Connector for Power BI

Last year, we introduced the MongoDB Atlas Power BI Connector , a certified solution that has transformed how businesses gain real-time insights from their MongoDB Atlas data using their familiar Microsoft Power BI interface. Today, we’re excited to announce a significant enhancement to this integration: the introduction of DirectQuery support. DirectQuery mode provides a direct connection to your MongoDB Atlas database, allowing Power BI to query data in real-time. This means that your Power BI visualizations and reports will always reflect the latest data without importing and storing data within Power BI. This is especially beneficial for analyzing large datasets where up-to-date information is crucial, ensuring decisions are made efficiently without losing performance due to repetitive data imports and storage complexities. How DirectQuery in MongoDB Atlas Power BI Connector works: The Power BI Connector is supported through MongoDB’s Atlas SQL Interface , which is easily enabled from the Atlas console. Atlas SQL, powered by Atlas Data Federation , allows you to integrate data across sources and apply transformations directly, enhancing your analytics. Once enabled, you’ll receive a SQL Endpoint or URL to input into your MongoDB Atlas SQL Connection Dialog within Power BI Desktop. Here, you can choose between two connectivity modes: Import or DirectQuery. Once connected through DirectQuery, Query folding takes place with Power Query , which is how data retrieval and transformation of source data is optimized. You can also achieve data transformation using a SQL Statement, either with the SQL Statement option in the Atlas SQL Interface or within the M Code script accessed via the Power Query Advanced Editor. After your data is transformed and ready for analysis, start building reports with your Atlas data within the Power BI Desktop! Then, simply save, publish, and distribute within the Power BI online app, which is now part of the Microsoft Fabric platform. Watch our comprehensive tutorial below covering how to connect your Atlas data to Power BI , control SQL schemas in Atlas, and use DirectQuery to gain real-time access to your data for business insights. Power BI Connector for MongoDB Atlas is a Microsoft-certified solution. It not only supports the advanced capabilities of DirectQuery but also continues to offer Import Mode for scenarios where data volume is manageable and detailed data modeling is preferred. Whether you’re analyzing real-time data streams or creating comprehensive reports, the Atlas Power BI Connector adapts to your needs, ensuring your business leverages the full power of MongoDB Atlas. DirectQuery Support is available now and can be accessed by updating your existing MongoDB Atlas Power BI Connector or downloading it here . Start transforming your data analysis and making more informed decisions with real-time Atlas data. Log in and activate the Atlas SQL Interface to try out the Atlas Power BI Connector ! If you are new to Atlas or Power BI, get started for free today on Azure Marketplace or Power BI Desktop .

May 13, 2024