Atlas for Microsoft Dynamics 365

Transform your business with Atlas and Microsoft Dynamics 365

Atlas for Microsoft Dynamics 365 allows users to create powerful reports with drill-down in Excel using live ERP data. Atlas provides one platform to consolidate data from key business systems into a single report, eliminating the need for manual re-keying or downloading of data into Excel. Users can seamlessly access Microsoft Dynamics data in the cloud or on-premise. Take advantage of integration features that enable you to design, build, and share real-time reporting in Excel spreadsheets, and visualize the data using Power BI or customizable Atlas dashboards.

Up-to-the-minute Reporting Data from Microsoft Dynamics 365 in Excel

Boost your reporting structure with Atlas:

Eliminate manual processes – Say goodbye to re-keying data. With Atlas, easily create dynamic reports from any Office app that can be refreshed on demand, or when the value in a linked cell is changed

Report, change, and write-back with ease - Reports generated using Atlas can also include templates that enable you to easily upload data back into your ERP system. These templates can then can be saved for later use.

Combine your reporting data like never before - Have data in multiple locations? Atlas allows you to bring together data from a number of enterprise data sources into a single report.

Refresh each report on demand – Refresh one or more Atlas workbooks in the background and continue using Excel without interruptions.

Drill down to the details - The Atlas Sidebar provides an experience that’s sophisticated, not complicated. The Sidebar allows you to tailor reports to meet the needs of any project, and drill down to the fine-tuned details. Choose between a sidebar or a full visualization canvas to display more detailed figures behind what you see.

Save more time with snippets - Frequently used report definitions can be saved as snippets and reused later. Then, boost productivity by saving these templates into libraries that can be shared with other team members.

Access your data anytime, anywhere - Publish your existing Atlas reports to Office 365, OneDrive, and Power BI so that you can get the information you need, anytime, from anywhere.

Organize a workflow

Prioritize tasks and form a batch, and execute templates in the order specified. You can use this feature to automate dependent workflows without changing permissions already set by the host system.

Leverage powerful journal features

Atlas provides a journal feature to simplify interaction with your Dynamics 365 system. Journals are validated and inserted using the same mechanisms you’d use in 365 directly. Use the Atlas journal function to:

Load data from an external system and enter it in Microsoft Dynamics 365 for Operations

Stay secure

When using Atlas for Dynamics 365, your data stays secure. Microsoft’s Common Data Model encrypts information at rest, and keeps the same permissions and controls intact for any data you access within Atlas.

Complement your Power BI Experience

Atlas streamlines your Power BI experience. It offers one toolset that controls all the parameters relating to your data and the way you would like it to be presented.

Atlas is used by 4,500+ customers all over the world...

Technical Requirements

PC Minimum Software

Recommended

Excel 2007 (32-bit)

Excel 2016 (32-bit or 64-bit)

Windows 7 (32-bit)

Windows 10 (32-bit or 64-bit)

Microsoft Visual Studio Tools for Office

Microsoft Access Database Engine 2010

Application Database: Windows Server 2008 SR2 SP2

Windows Server 2012 and R2

Microsoft Dynamics 365

Processor: 2x Processor Cores

4x Processor Cores

8GB RAM or Above

Monitor: 1080p, 1920x1080 is the best solution

Network Bandwidth: 100 Mbps

Network Latency: Less than 5 milliseconds

Microsoft VTSO Package - Latest Version

Microsoft .NET 4.6.1

Citrix and Terminal Server Installation

Processor 8x Processor Cores

RAM 16GB RAM or above

Restriction It is recommended that no more than 20x users are using Atlas and Excel on each Citrix/Terminal Server concurrent.

Frequently Asked Questions

Case Studies & Articles

This case study of Contura Energy is based on a June 2017 survey of Global Software, Inc. customers by TechValidate, a 3rd-party research service.