Microsoft GP 10.0 Integration Manager Set 4

Sources Queries Data Sources Query Relationships Destination Mappings

Give the spreadsheet a name that matches the query name ✘ Define a named range within the spreadsheet ✘ Format the spreadsheet as a eneral format ✘ The first Excel row must have column names ✔

It automatically upgrades, regardless of Integration Manager settings. ✘ It automatically upgrades, unless "Do Not Automatically Upgrade Sources and Destinations" is selected. ✘ It never automatically upgrades; the Database Conversion must be run. ✘ It never automatically upgrades; the adapters must be manually upgraded in Microsoft Access. ✔

Source Adapters Destination Adapters Web services Integration Manager Engine

Universal Translation Global Translation Local Translation Fixed Translation

On the workstation where they were created ✘ On the SQL Server ✘ In the Integration Database ✘ In the location specified when they are created ✔

Simple ODBC can only pull data from Excel spreadsheets ✘ Advanced ODBC can only be used by the 'sa' user ✘ Simple ODBC must be the only source on an integration ✘ Advanced ODBC requires a SQL statement to be written ✔

Menu Toolbar Navigation Pane Ribbon

Insert New Records ✘ Update Existing Records ✘ Both Insert and Update ✘ Delete records ✔

On the server only ✘ On every workstation ✘ On the first workstation only ✘ In Microsoft Dynamics GP ✔