Course 8519A:

Integration Manager in Microsoft Dynamics GP 9.0

Length:2 Days
Published:February 15, 2006
Language(s):English
Audience(s):IT Professionals
Level:200
Technology:Microsoft Dynamics GP 9.0
Type:Course
Delivery Method:Instructor-led (classroom)
About this Course
The two day Microsoft DynamicsT GP Integration Manager course develops your understanding of how to integrate outside systems with your Microsoft Dynamics GP accounting application through the use of tools designed to safely and easily import records. You will find value in using Integration Manager for safely converting data into a new Microsoft Dynamics GP installation, or as an ongoing way to integrate data from your external business databases, e-commerce solutions and desktop applications with Microsoft Dynamics GP. In addition to Integration Manager, information will be provided on Table Import. Table Import enables you to quickly transfer data from other sources into Microsoft Dynamics GP, regardless of module, table, operating system or database.
Audience Profile
Microsoft Dynamics GP Integration Manager training is recommended for people who plan to install, implement, configure, consult, or support the tools used to integrate data with Microsoft Dynamics GP. This class is targeted towards individuals that desire to increase their knowledge and the skills necessary to create automated integrations between Microsoft Dynamics GP and existing outside data sources.
At Course Completion
After completing this course, students will be able to:
  • Explain the different methods used to import data into Microsoft Dynamics GP.
  • Identify the different tools available to assist users in importing records into Microsoft Dynamics GP.
  • Recognize the features and benefits of using Import Utility.
  • Learn the steps for setting up an import.
  • Identify the available resources that can be used to assist the user in setting up an import.
  • Identify the different field structures.
  • Define a table import.
  • Create a table import definition to import customer information.
  • Identify the features and benefits of Integration Manager.
  • Install Integration Manager.
  • Recognize the basic steps in creating an integration.
  • Identify the destinations available with the Great Plains Standard Adapter.
  • Create an integration for GL Accounts.
  • Create an integration for GL Transactions using two source files.
  • Create a GL Transaction integration using one source file.
  • Create a Customer integration.
  • Create a RM Transaction integration.
  • Create an Integration Group.
  • Configure Integration Manager setup options.
  • Create Translations.
  • Create ODBC sources.
  • Use VBScripting with Integration Manager.
  • Use the Integration Manager Script Library.
  • Identify the steps needed to schedule an integration.
  • Create a payroll transaction integration.
  • Review the differences between the SQL Optimized Adapter and the Great Plains Standard Adapter.
  • Create an Inventory Transaction Integration using the SQL Optimized Adapter.
  • Create a Sales Order Processing Transaction Integration using the SQL Optimized Adapter.
  • Create a Purchase Order Integration using the SQL Optimized Adapter.
  • Identify the steps to create a custom destination.
  • Create a payables manual check integration using the Direct to Table Document Definition Wizard.
  • Understand the XML source and destination adapters, and their uses.
  • Create a vendor integration using the XML Source adapter.
  • Create a PM Transaction integration using the XML Source adapter.
Course OutlineModule 1: Microsoft Dynamics GP Tools Overview
The purpose of this chapter is to give students a general overview of the tools available to integrate data into Microsoft Dynamics GP.
Lessons
  • Methods of integrating data
  • Description and comparison of tools
After completing this chapter, students will be able to:
  • Explain the different methods used to enter data into Microsoft Dynamics GP.
  • Review each of the different tools available to assist users in importing records into Microsoft Dynamics GP.
Module 2: Import Utility
This chapter focuses on Import Utility. We will examine the features and benefits of using Import Utility to import data into Microsoft Dynamics GP. We will review the basic steps in creating a table import. There is also a section on resources that can be used to determine what information needs to be imported and how to determine field structures. We will then define and perform an import.
Lessons
  • Features and benefits
  • Steps involved in creating an import
  • Field structures
  • Define and run an import
  • Lab
  • Import Utility
After completing this chapter, students will be able to:
  • Recognize the available resources that can be used to assist the user in setting up an import.
  • Define the steps for setting up an import.
  • Create an import definition.
Module 3: Integration Manager Overview
The purpose of this chapter is to identify the features and benefits of Integration Manager. We will go over the Integration Manager installation as well.
Lessons
  • Feature and benefits
  • Installation
After completing this chapter, students will be able to:
  • Identify the features and benefits of Integration Manager.
  • Install Integration Manager.
  • Launch and register Integration Manager.
Module 4: Great Plains Standard Adapter
In this chapter we will discuss the most commonly used destination adapter in Integration Manager: the Great Plains Standard Adapter. We will define the steps in creating a basic integration. The available destinations will be listed as well.
Lessons
  • Great Plains Standard Adapter introduction
  • Steps to create an integration
  • Available Destinations
  • Labs
  • GL Accounts Integration
  • GL Transaction Integration
  • GL Integration using One Source File
  • Customer and RM Transaction Integration
After completing this chapter, students will be able to:
  • Define a Business Object.
  • Create the Integration.
  • Define the Source.
  • Set up row and sorting options.
  • Define source relationships.
  • Select the Destination.
  • Create the destination mapping.
  • Check the integration log for errors.
  • Set up integration groups.
  • Create and run an integration for GL Accounts.
  • Create and run an integration for GL Transactions.
  • Create and run an integration for GL Transactions that uses one source file.
  • Create a Customer Integration.
  • Create a Receivables Transaction Integration.
  • Create and run an integration group.
Module 5: Advanced Integration Topics
In this chapter we will discuss advanced integration topics. We will discuss different options that allow you to further customize and enhance the integration to work with the source data.
Lessons
  • Setup options
  • Object Browser
  • Data translations
  • Query relationship types
  • ODBC connectivity
  • VBScripting
  • Scheduling integrations
  • Lab
  • Payroll Transaction Integration
After completing this chapter, students will be able to:
  • Change the location of the im.mdb.
  • Create a pathname translation.
  • Use the Object Browser.
  • Create data translations.
  • Identify the query relationship types.
  • Create a simple ODBC source.
  • Create an advanced ODBC source.
  • Identify the different levels of scripting.
  • Create a VBScript and attach it to an integration event.
  • Use the script library.
  • Schedule an integration.
  • Create and run a payroll transaction integration.
  • Implement a data translation.
  • Implement VBScripting.
  • Use ODBC connectivity for the source.
Module 6: SQL Optimized Adapter
This chapter focuses on introducing students to the SQL Optimized Adapter. Unlike the Great Plains Standard Adapter, the SQL Optimized Adapter integrates at the table level, with full data validation.
Lessons
  • Introduction
  • Destinations available
  • Differences between the SQL Optimized Adapter and Great Plains Standard Adapter
  • Destination Settings
  • Destination Options
  • Troubleshooting integrations
  • Labs
  • Inventory Transaction Integration
  • SOP Transaction Integration
  • Purchase order Entry Integration
After completing this chapter, students will be able to:
  • Recognize what destinations are available with the SQL Optimized Adapter.
  • Identify the differences between the adapters.
  • Set the Destination Settings & Options.
  • Troubleshoot integrations using the SQL Optimized Adapter.
  • Successfully Create and run an inventory transaction integration.
  • Identify the Destination Options for Sales Order Processing using the SQL Optimized Adapter.
  • Create and run a sales order transaction integration.
  • Create and run a purchase order transaction integration.
Module 7: Direct To Table Adapter
This chapter focuses on introducing students to the Direct to Table Adapter. The Direct to Table Adapter integrates at the database level.
Lessons
  • Introduction
  • Elements of a Custom Destination
  • Creating a Custom Destination
  • Lab
  • Payables Manual Checks
After completing this chapter, students will be able to:
  • Identify features of the Direct to Table Adapter.
  • Use the Direct to Table Document Definition Wizard.
  • Create a custom destination.
  • Successfully create and run a payables manual checks integration.
Module 8: XML Source Adapter
This chapter focuses on introducing students to the XML Source and Destination Adapters. Using the XML Source Adapter allows you to integrate data from a well-formed XML document using Integration Manager. While the XML Destination allows you to transform data from a source to a specified XML definition.
Lessons
  • Adding an XML Source
  • Import Command
  • Using the XML Destination
  • Labs
  • Vendor Integration
  • PM Transaction Integration
After completing this chapter, students will be able to:
  • Identify the XML Source Properties.
  • Import a document definition.
  • Identify the Source Settings.
  • Understand the XML Destination.
  • Successfully create and run a Vendor integration.
  • Create an XML Source.
  • Successfully create and run a payables transaction integration.
  • Create an XML Source.
Before attending this course, students must have:
  • General knowledge of Microsoft Windows.
  • Basic knowledge of Microsoft Dynamics GP.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Course index

Find Training Near You

Location:
Eg: Seattle, WA or Paris, France

Related Services