An Integration Manager component that connects to a destination or source application.
Advanced ODBC query
A query that issues a SQL statement to retrieve information from an ODBC data source. See also Simple ODBC query.
The logical value of True or False.
A text file that uses commas to separate the individual data items in the text file.
An acronym for Comma-Separated Values. It indicates a text file that uses commas to separate the individual data items.
A data type that is intended to hold monetary values. It can have up to four decimal places and must be in the range –922,337,203,685,477.5808 to 922,337,203,685,477.5807.
An ODBC data source from which you retrieve data.
A data source setting that indicates what type of data is contained in the column of a data source. Common data types include booleans, currencies, integers and strings.
A character or characters that separate the individual data items in a text file. Commas and tab characters are often used as delimiters.
Where data gathered by Integration Manager is placed in Microsoft Dynamics GP. Integration Manager provides several common destinations, such as customer information or receivables transactions.
A feature that validates data before integrating it to the destination application or database such as Microsoft Dynamics GP.
Where information for each item in the integration destination originate. For many items in the destination, the destination mapping indicates that information originates from a query. For other items, the mapping indicates that a constant value or a default value from Microsoft Dynamics GP should be used.
The metadata that Integration Manager uses to describe the structure and content of a source or destination. It describes recordsets, hierarchical relationships, fields, data types, field lengths, and more. It is analogous to an XML schema, but it usually contains more information than an XML schema.
A data type that stores a double-precision floating point number. The value can have up to fifteen significant digits.
Negative values must be in
–1.79769313486232E308 to –4.94065645841247E–324.
Positive values must be in
4.94065645841247E–324 to 1.79769313486232E308.
eConnect destination adapter
An Integration Manager destination adapter that enables integration with Microsoft Dynamics GP data using eConnect.
A data type that is restricted to a fixed set of named values. Enumeration fields in a destination correspond to list boxes, drop-down lists and other list controls in Microsoft Dynamics GP. When you set the value of an enumeration field, you supply the integer value that corresponds to one of the items in the enumeration. See also Translation.
Specifies the criteria for determining precisely which documents to extract from the source. You can define filters only for those fields located in the Root Recordset.
A data type that stores integral numeric values. It must be in the range –32,768 to 32,767. A set of integrations that are performed in succession in a specified order.
Integration Manager engine
An Integration Manager component that receives data from the source adapter, provides mapping and transformation functionality, and passes data to a destination adapter.
A database operation that combines some or all records from two or more tables.
A data type that stores integral numeric values. It must be in the range –2,147,483,648 to 2,147,483,647.
A data type that stores a sequence of up to 65,535 characters.
Those elements that contain child elements to attributes as well as data.
A keyword that indicates a field or variable does not contain valid data.
A data type specific to Integration Manager. It stores decimal values that can have up to 19 digits with up to 5 of the digits after the decimal point.
A request for information. In Integration Manager, a query can request information from text files or from ODBC data sources.
A tool in Integration Manager to aid writing a SQL statement to use for an advanced ODBC query.
A relationship between two queries that defines how they work together to retrieve information.
An element that is used to map items in an integration destination. There are two types of recordsets. One type of recordset simply groups related fields in the destination. The other type of recordset indicates that several sets of fields in the recordset can be associated with a single instance of a record imported into the destination. These recordsets are represented by the folder icon.
A text file that contains records that were rejected from text queries by Integration Manager. Rejection files have the .rjt extension.
A set of criteria that allows you to specify the rows that will be included in a query. All rows that do not fit the criteria are excluded.
Defines where the information for an item in the destination mapping originate.
Simple ODBC query
A query that retrieves data from an ODBC data source. See also Advanced ODBC query.
A data type that stores a single-precision floating point number. The value can have up to seven significant digits.
Negative values must be in the range –3.402823E38 to –1.401298E–45.
Positive values must be in the range 1.401298E–45 to 3.402823E38.
Indicates where the data to be integrated comes from. A source can either be a text file, a database, or an application
A feature that connects to a database, text file or application source. It filters and extracts the data from the source before passing the information to the Integration Manager engine.
Shows data from the source one document at a time and in the structure of the document definition.
The name of the source document definition that you are setting up. This name appears in the Add Source window. You may use any name that helps you easily identify this source document definition.
Source settings connect the source document definition to an actual source by having you specify certain parameters. They are additional properties relating to a source and are associated with an individual integration. They are not, however, automatically inherited by other integrations that use the same source document definition.
A data type that stores a sequence of up to 255 characters.
A text file that uses tab characters to separate the individual data items in the text file.
A query that retrieves data directly from text files.
Allows you to define a relationship between values in the source file and corresponding values that are used for the destination field.
A subset of the Microsoft Visual Basic programming language that is embedded into Integration Manager to provide scripting capabilities.
Extensible Markup Language (XML) is the standard method of viewing data on the Web. Rich, structured data from any application can be easily described in a standard and consistent manner through the use of XML. It also is a complementary format of HTML.
eXtensible Stylesheet Language for Transformations (XSLT) is used as a part of XSL, which functions as a stylesheet language for XML. XSL includes an XML vocabulary for specifying formatting; XSL specifies the styling of an XML document by using XSLT to describe how the document is transformed into another XML document that uses the formatting vocabulary.