«Management Reporter Integration Guide for Microsoft Dynamics® NAV July 2013 Find updates to this documentation at the following location: ...»
Integration Guide for
Microsoft Dynamics® NAV
Find updates to this documentation at the following location:
Microsoft Dynamics is a line of integrated, adaptable business management solutions that enables you and your
people to make business decisions with greater confidence. Microsoft Dynamics works like and with familiar
Microsoft software, automating and streamlining financial, customer relationship and supply chain processes in a way that helps you drive business success.
U.S. and Canada Toll Free 1-888-477-7989 Worldwide +1-701-281-6500 www.microsoft.com/dynamics Information in this document, including URL and other Internet Web site references, is subject to change without notice. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted in examples herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.
© 2013 Microsoft Corporation. All rights reserved.
Active Directory, Microsoft, Microsoft Dynamics, and Windows are trademarks of the Microsoft group of companies.
All other trademarks are property of their respective owners.
MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAVTable of Contents Introduction
User account requirements
Configuring the data integration
Configure the data integration
Select the default company
Data mart displays only attributes associated with transactions
Unposted transactions are not supported in the data mart
Renaming companies from Microsoft Dynamics NAV
Changing report timeout settings
Modifying fiscal years in the data mart
Integrating a data mart with a second ERP database
Integrations might fail when customizations are made to database field lengths
MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAVIntroduction Management Reporter 2012 for Microsoft Dynamics® ERP uses a data mart database to integrate data between Microsoft Dynamics NAV and Management Reporter. You can view and use the data from Microsoft Dynamics NAV to create financial reports in Management Reporter 2012 without affecting the original data in the ERP database.
A data mart integration creates a database of information from the original ERP database to create financial reports in Management Reporter 2012. This integration provides high level of integration with a Microsoft Dynamics NAV system, and offers enhanced report generation options.
Data for the following entities are available for integration into Management Reporter 2012:
Actual balance Budgets Multiple currency information, for functional and reporting currencies Fiscal Periods Dimensions Companies The Microsoft Dynamics NAV data mart is compatible with Management Reporter 2012. Earlier versions of Management Reporter must be updated to Management Reporter 2012.
System setup Before you configure the Microsoft Dynamics NAV data mart integration, your system must meet the minimum requirements for Management Reporter. For more information, see the System requirements for Management Reporter. Additional prerequisites are listed below.
System prerequisites The following components must be installed before the data mart integration can be configured on your system.
Microsoft Dynamics NAV 2009 R2 The data provider is compatible with Microsoft Dynamics NAV 2009 R2. Earlier versions of this system must be upgraded to Microsoft Dynamics NAV 2009 R2 to integrate with Management Reporter 2012.
Note: The data provider does not require the Microsoft Dynamics NAV 2009 R2 client to be installed on the same computer, but the data provider requires access to the ERP database.
Management Reporter 2012 server components Data providers must be configured on any computer that hosts the Management Reporter 2012 application service and process service. To configure these components, see the Management Reporter installation guide.
MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAVUser account requirements Security permissions for the Microsoft Dynamics NAV integration user must be set up before configuring Management Reporter. The user account that is used to configure the data mart
integration must meet the following requirements:
In addition, Management Reporter 2012 requires database access to the Microsoft Dynamics NAV SQL Server database. When you configure the data integration, you must enter credentials that have access to the Microsoft Dynamics NAV database. Depending on the verification option that you select, different permissions are required for the user account that is assigned to the Management Reporter
process service, also known as the Service account:
If you are using Windows Authentication, the Service account credentials must be assigned to the db_datareader role in the Microsoft Dynamics NAV database.
If you are using SQL Server authentication, the SQL Server credentials that you provide must be assigned the db_datareader role in the Microsoft Dynamics NAV database. No additional permissions are required for the Management Reporter user account.
For more information about the Service account, see the Management Reporter installation guide.
Note: All Management Reporter users must have Active Directory domain accounts for authentication.
These credentials are used by the data provider to connect to Microsoft Dynamics NAV. For more information, see “How to create a domain account in Active Directory” on MSDN (http://msdn.microsoft.com/en-us/library/aa545262(CS.70).aspx).
After Management Reporter is installed and fully configured, you can add users and modify security permissions. See the Management Reporter Help documentation for more information.
MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAVConfiguring the data integration The data mart for Microsoft Dynamics NAV is installed at the same time as the Management Reporter server components. For more information and installation procedures, see the see the Management Reporter installation guide.
The following procedures explain how to configure the data integration for Management Reporter.
Configure the data integration Management Reporter uses a data mart to integrate information from a Microsoft Dynamics NAV system. You can configure these components during initial configuration or after you have set up the application service and process for Management Reporter 2012.
Note: Management Reporter 2012 can integrate with multiple ERP systems, but you can configure only one instance at a time.
1. Click Start, select Programs, select Microsoft Dynamics, select Management Reporter 2012, and then select Configuration Console to open the Management Reporter configuration console.
2. In the Management Reporter configuration console, click File, and then select Configure to open the Custom Configuration dialog.
3. Under Management Reporter Application Service, select the Add Microsoft Dynamics NAV Data Mart check box, and then click Next.
4. On the Prerequisite Validation page, review any failed prerequisites or warnings and resolve issues before continuing with the installation process. Click Revalidate to run the validation again.
5. Click Next.
6. On the Settings page, under Dynamics NAV connection information, enter the name of the Microsoft Dynamics NAV server to connect to in the Database server field.
7. Enter the domain, user name, and password of the Service account, or select Use Windows authentication to connect to the ERP database using the user account that the services are running under.
For more information about this account, see User account requirements and the Management Reporter installation guide.
8. If the SQL Server is configured to use Secure Lockets Layer (SSL) for encryption, select Encrypt Connection. The data that is transmitted between the SQL server and Management Reporter 2012 services is encrypted.
Note: to use this option, you must configure SSL on the server and install certificates. For more information, see “Encrypting connections to SQL Server” on MSDN (http://msdn.microsoft.com/en-us/library/ms189067.aspx).
9. In the Database field, select the Microsoft Dynamics NAV database to connect to.
10. Under Data mart connection information, in the Database server field, enter the name of the SQL server that hosts the Microsoft Dynamics NAV database.
11. To connect to an existing data mart database, select Connect to an existing database.
12. Enter the user name and password of a user account that has permissions to connect to the data mart database. To configure the database using your current credentials, select Use Windows authentication.
13. In the Data mart database field, select an existing database to connect to, or enter a unique name to create a new data mart database.
MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAV
14. Click Next.
15. Review the configuration information, and then click Configure.
16. When a message is displayed that indicates that the data mart integration has been successfully configured, click Close.
17. To integrate with another instance of Microsoft Dynamics NAV, repeat steps 1 through 16. To integrate with another ERP system, see the integration guide for that ERP system.
18. After all integrations are configured for Microsoft Dynamics NAV, you must import companies. For more information, see Import companies.
Import companies After you have installed Management Reporter 2012 services and integrated with a Microsoft Dynamics NAV system, you must import company information from the Microsoft Dynamics NAV database into Management Reporter 2012.
Note: If you are upgrading from a previous version of Management Reporter, you must import all companies that you want to access in Management Reporter 2012. This includes companies that you have integrated with previous versions of Management Reporter.
1. In the Management Reporter 2012 configuration console, verify that the application service is running.
Note: The application service must be running to import company information.
2. In the navigation pane of the Management Reporter configuration console, expand the Management Reporter 2012 services node. Under ERP Integrations, select the integration to import companies from.
3. Click Import in the display pane.
4. Enter the domain, user name, and password of a user account that has access to the data mart database. For more information, see User account requirements.
5. Review the list of available companies. If a company has already been imported, Already imported will be selected. To not import a company, select Skip import.
6. Click Import companies.
7. When a message is displayed that indicates that the companies have been successfully imported, click OK.