MB3-215 - Microsoft Business Solutions - Great Plains 8.0 Integration Manager
Go back to Microsoft
In each source, you can set to order by a column in what order?
If an integration is run and a user does not have rights to the window, will the integration fail?
Yes, the Great Plains 8.0 adapter is a macro interface integration, thus a user needs permission at the window level
Which of the following is NOT a benefit of using the Direct to Table Adapter?
Data is full validated
You can default in Required Fields
When you create a custom destination with the Direct to Table Adapter Custom Destination Designer tool, all tables associated with the DSN will be displayed. How would you remove a table?
Highlight the table and right click
What is the minimum amount of queries needed for a Payroll Transaction Integration?
XML is an abbreviation for?
Extensible Markup Language
What file format does Import Utility support?
Tab Delimited file
Comma Delimited file
Where can you change the maximum number of errors and warnings?
In the Integration Properties
When bringing in Exchange Rate information using the Exchange Rate destination, which of the following statements is true?
The Exchange Table ID must already exist.
Integration Manager can add a Batch ID for a transaction integration. To do so, in the destination mapping ?options tab, which option must be set?
Missing Batch ?Add New Batch
Which of the following operating systems are not compatible with Integration Manager version 8.0?
Windows 98/98 SE
What are the available document types when integrating Sales Order Processing Transactions with the SQL Optimized Adapter?
Orders and Invoices
Which of the following types of tables are NOT recommended as an import destination with Import Utility?
What fields are required, or do not have the option to use default, when running a GL Accounts integration?
Account Number, Description, Category
What is the default Relationship Type?
There can be 0 or more records in the child for each record in the master
A Payables Transaction integration has been created. It is based on one source file that includes debit and credit distributions. When run, only one distribution account is integrated. What should be checked to resolve this problem?
Two source queries are required: One for transaction information and one for distribution information.
The relationship between the source queries needs to be pointing from the transaction(header) source query to the distribution(detail) source query.
In the Destination Mapping, click on the Entries collection and then the Options tab. Check to make sure the Source column is referencing detail source query and not the header source query.
How do you change the company to which records are going to be integrated when using the SQL Optimized Adapter?
Change only the Company Database on the Destination Settings of the integration.
Which of the following should be done when troubleshooting a problematic SQL Server connection when using the SQL Optimized Adapter?
Verify the SQL Server is running.
Be sure the DSN with the appropriate name has been setup on the workstation where the integration is being run.
Confirm the login and password are correct for the SQL Server.
When using the Import Utility, what will happen to invalid data types?
Converted and truncated
Where should security privileges be setup to add data to the appropriate tables on the SQL Server when using the SQL Optimized Adapter?
On the SQL Server
In order to improve performance, you would want to use what kind of importing option with the Direct to Table Adapter?
Import into a ustom?destination
As a Technical Support Assistant, you have been asked to install Integration Manager with all possible adapters. Which of the following adapters are not included in the Integration Manager installation and must be installed separately?
Project Accounting Timesheets
Fixed Assets General Asset Information
If you attempting to perform a Sales Order Processing transaction integration with Integration Manager version 8.0, which of the following would never be a selection available when adding a source?
Each field that has their Field Rule set to use Source Field will display additional settings under the Rule Properties section. The settings include which of the following options?
When an Integration Group is run, where would you go to see the log file for the integration group?
Open each integration separately and go to the properties window ?Log tab
Cash Receipts are being integrated and applied to Invoices. When looking at the Apply Sales Document window, nothing is applied. What should be checked to resolve this?
In the Destination Mapping, click on the Cash Apply collection and then the Options tab. Check to make sure the Rule column is marked to Use Source Recordset.
The invoices (or debit documents) must be posted
The invoices (or debit documents) must be sitting in the RM Open table
Which of the following can be specified for the Log Level of detail?
When integrating Customers, what are the available Destination Edit Modes?
Insert and Update
Which of the following items does the IM.MDB contain?
Data source information
With Integration Manager, you have the ability to do which of the following using XML?
Integrate into an Great Plains destination from an XML source
Integrate into an XML destination from a tab delimited source
Use XML as both a source and a destination
What tables contain the Import Definitions?
SY50000.idx and SY50000.dat
SY50100.idx and SY50100.dat
Which of the following destinations are available with the Great Plains 8.0 standard adapter?
How can you preview a Source?
Right click on the source name
What is the default value for maximum number of errors Integration Manager allows before the integration is stopped?
If you do NOT mark First Row Contains Column Names in the Source properties, what default names are assigned?
F1, F2, F3, etc.
The Direct to Table Adapter integrates at what level?
Which of the follow circumstances will cause Import Utility to reject records?
Records are duplicates of records that already exist in the table
Which of the following actions is a required step to schedule an integration to run?
Create a Great Plains Login Macro
Create a BAT file to run an integration
Create a BAT file to launch Great Plains
Which of the following destinations will allow you to update existing records in Great Plains?
All Master Record integrations and the Exchange Rate integration
Before running an integration with the Great Plains 8.0 adapter, do you have to be logged into the Great Plains company you would like to integrate to?
Which of the following types of translations can be created?
Data types can be changed within Integration Manager for which source type?
Advanced ODBC source
Relationships between text sources must meet which of the following criteria?
Must be between fields of the same data type
Which of the following is considered a Non-window field?
Sequence Line field
Which of the following is a resource that may be useful in setting up an import?
Software Development Kit
Microsoft SQL Query Analyzer
When creating a Simple ODBC query to access an Excel spreadsheet, what step must be done in Excel in order to see the data?
Define a named range within the spreadsheet
As the lead integration developer, you would like to streamline some of your integrations using the Script Library. In reviewing your current integrations, you determine that which of the following tasks can be completed using a script from the Script Library?
Concatenating two or more source fields
Prompting the user for a batch ID
Renaming a source file using today's date
Which of the following is NOT available as a rule in the option tab for the entries section of the General Ledger transaction destination mapping window?
Where can you delete an integration?
Within the open Integration window
When importing General Journal Transactions with Import Utility, which tables would be required?