PacktLib: Microsoft Dynamics NAV Administration

Microsoft Dynamics NAV Administration

Credits

Foreword

About the Authors

About the Reviewers

Preface

Setting up the Environment for Dynamics NAV

Considerations for deploying Dynamics NAV

Summary

Installing Dynamics NAV

Installing a Classic client

Installing a C/SIDE database server

Preparing a Microsoft SQL Server database for Dynamics NAV installation

Connecting a Dynamics NAV client (Classic) to the NAV Classic database server

Connecting a Dynamics NAV client (Classic) to a Microsoft SQL Server database

Installing the RoleTailored client for Dynamics NAV

Installing the Dynamics NAV server (the middle-tier component)

Connecting a RoleTailored client to the database

Summary

Integrating Dynamics NAV with the Microsoft Platform

Integrating Dynamics NAV and the Microsoft Office system

Summary

Securing Dynamics NAV Applications

Security with SQL Server installation

Dynamics NAV security models

Users, logins, and passwords

Roles and permissions

Sarbanes Oxley compl´╗┐iance

Summary

Backing up and Restoring a Dynamics NAV Database

Creating and restoring backups using a Dynamics NAV client

Using HotCopy backup

Testing the database

Backing up and restoring with SQL Server

Synchronizing a SQL database

Expanding the database

Things to consider while defining the backup strategy

Summary

Performance Tuning

Configuring a SQL Server database for Microsoft Dynamics NAV

Writing less expensive C/AL code for customizations

Fine-tuning the SQL Server database for Dynamics NAV

Investigating the performance of the database

Summary

Setting up Periodic Activities, Stylesheets, and Rapid Implementation Methodology

Job Queue

Managing stylesheets in Dynamics NAV

Rapid Implementation Methodology

Summary

Updating Objects and Virtualization with Dynamics NAV

Objects in NAV

Virtualization with Dynamics NAV

Summary

Business Intelligence

Importance of Business Intelligence

Dynamics NAV and Business Intelligence

Reporting capabilities in NAV

Summary