Microsoft Dynamics AX works with Microsoft SQL Server 2005
Products work well together to help you get simple, seamless, security-enhanced data management and maximize your IT investment
The latest versions of Microsoft SQL Server and Microsoft Dynamics AX connect in a way that makes your data even easier to manage. The three-tier, object-oriented architecture of Microsoft Dynamics AX 4.0 integrates with Microsoft SQL server in a way that helps IT managers work more efficiently. Companies can now take advantage of improved performance and backup features. And these features make it easier to maintain the system and keep it running 24 hours a day, 7 days a week. New business intelligence features can make it easier for users to access reports without the help of the IT department. And all the features in Microsoft SQL Server 2005 are standard and are offered at a low total cost of ownership (TCO).
On This Page
Keep your business working 24 hours a day, every day
Integration between Microsoft Dynamics AX 4.0 and SQL Server 2005 helps reduce application downtime, improve performance, and tighten security controls. If your company has operations or ongoing processes taking place during off hours (such as batch data processing), SQL Server can help you perform maintenance without disrupting business. In fact, there are Microsoft SQL Server customers running applications with multiterabyte databases proven to maintain more than 99.998-percent availability. New Microsoft SQL Server 2005 features include:
| • | Online backups and transaction log backups for restoring single pages |
| • | Database mirroring and snapshots and online indexing to keep operations running |
| • | Fine-grained online repairs that enable you to leave part of the system offline when you perform maintenance such as checking and restoring data at the page level |
Why new reporting features can save time for IT
Microsoft SQL Server helps business managers and employees quickly create and distribute comprehensive reports without having to depend on the IT and accounting departments.
Integration between Microsoft Dynamics AX 4.0 and SQL Server 2005 enables managers to control access to data based on security considerations and employee job roles. More memory and greater speed helps users organize and use data more efficiently.
Integration between Microsoft Dynamics AX and SQL Server enables users to:
| • | Structure data and tables from Microsoft Dynamics AX into multi-dimensional cubes for an easier overview |
| • | Build and analyze data warehouses of any size to get a picture of your business conditions at a specific point in time |
| • | Create, manage, and deliver print and interactive-Web reports based on data from Microsoft Dynamics AX |
Microsoft SQL Server Reporting Services with Microsoft Dynamics AX allows you to transform external and business application data into multidimensional reports. You can take advantage of different report, including Microsoft Office Excel, Microsoft SharePoint, Microsoft Access, and Business Objects.
What makes the TCO for SQL Server 2005 compelling?
Microsoft SQL Server 2005 is licensed per processor, not per core. This reduces the database cost by a factor of three or more. You can take advantage of the standard features in SQL Server such as advanced data mining, integration services, business intelligence, and features that help reduce downtime—all at no additional cost. For more information about pricing, read Microsoft SQL Server 2005 total cost of ownership studies.
Next steps
