• Overview
• Outline
• Schedule

About This Course

The two day Microsoft Business Solutions Great Plains Integration Manager course develops your understanding of how to integrate outside systems with your Microsoft Great Plains accounting application through the use of tools designed to safely and easily import records. You'll find value in using Integration Manager for safely converting data into a new Microsoft Great Plains installation, or as an ongoing way to integrate data from your external business databases, e-commerce solutions and desktop applications with Microsoft Great Plains. 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 Great Plains, regardless of module, table, operating system or database.

Audience Profile

Microsoft Great Plains Integration Manager training is recommended for people who plan to install, implement, configure, consult, or support the tools used to integrate data with Great Plains. This class is targeted towards individuals that desire to increase their knowledge and the skills necessary to create automated integrations between Great Plains and existing outside data sources.

Prerequites

Before attending this course, students must have:

• General knowledge of Microsoft Windows
• Basic knowledge of Microsoft Great Plains

At Course Completion

After completing this course, students will be able to:

• Explain the different methods used to import data into Microsoft Great Plains
• Identify the different tools available to assist users in importing records into Microsoft Great Plains
• 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 Microsoft Great Plains 8.0 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 Microsoft Great Plains 8.0 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 Adapter
• 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