Column (Sorting tab, Order By pane)
Add columns to indicate the order in which rows from the source should be imported. You can specify the sorting order for these columns in the Order field.
Column (Sorting tab, Group By pane)
Add columns to this list to specify the columns in the source that contain identical values. You can group, or collapse, the rows in the source that have identical values for corresponding columns. When the rows are collapsed, only one row is included in the source results for any group of rows for which all of the selected columns match.
Column Name (Columns tab)
Lists the names of the available data items for the source. You can edit the column names.
Column (Filter tab)
Select a column, or field, from the list to specify restriction criteria for.
Connect String (Columns tab)
The string describing how to connect to the ODBC data source.
Criteria (Filter tab)
Displays the criteria specified on the Filter tab. This criteria will be used to restrict which rows are returned by the query.
Data Source (General tab)
Select the ODBC data source to use for this simple or advanced ODBC source query.
Datatype (Columns tab)
Indicates the type of data contained in the column.
If you are creating a text query, Integration Manager will examine the data in the text file and provide a default value. If you are creating an ODBC query, Integration Manager will retrieve the data type from the ODBC data source. In some cases, you might need to change the data type to better reflect how the data is used. See Data types for more information.
Delimiter (General tab)
Specify the delimiter, which indicates the character that separates the individual data items in the file. For example, a comma-delimited text file will have a comma between each data item. If you select Other, type the character to use in the space provided.
Enter a description of the source, such as what data is contained in the source or what type of data is being retrieved.
File (General tab)
Enter or select the location of the text file that will be used to retrieve data from.
First Row Contains Column Names (General tab)
Select this option to include the column names from the first row of the file on the Columns tab. You would select this option if the first row of the text file contains the names of the data items in each column of the text file. If this option is not selected, Integration Manager will use a set of default names.
Is Key (Columns tab)
Select this to indicate any columns that uniquely identify each row in the query. For example, a column called Customer ID might be marked as Is Key to indicate that the values within the column are unique. This attribute is not required.
When you run an integration, this information is used to identify specific rows in the query that caused errors.
Enter the name of the source. The name should describe the type of information retrieved by the query, and should be more descriptive than the name used for the integration.
Don’t use ODBC-reserved words in the source name. They can prevent the integration from running properly. For a list of ODBC reserved words, see http://msdn.microsoft.com and search for “ODBC reserved words”. You’ll find a list of reserved keywords in Appendix C of the ODBC Programmer’s Reference.
Operator (Filter tab)
Select an operator to use to apply filter criteria for the selected field, such as =, >, or <.
Order (Sorting tab, Order By pane)
Indicates the order in which the rows from the source will be imported. Individual columns can be sorted in ascending or descending order. Specify a sorting order when the data in the source text file is not in the desired order.
Sorting can improve the performance of integrations. If multiple queries will be used for an integration, sort the query results by the columns that are used to define the relationship.
Allows you to attach scripts to a query. You can attach the following scripts.
Runs once before any data is retrieved by the query.
Runs once after Integration Manager has processed all source records for the query.
Show (Columns tab)
Select Show to include the data from this column in your integration. Clear this check box for any columns to exclude from the integration.
Size (Columns tab)
Indicates the data size of each column, in bytes. You can’t edit this value for simple ODBC queries. For advanced ODBC queries, you might need to adjust this value to better reflect the size of the data value returned by the query.
SQL Statement (General tab)
Displays the SQL statement from the advanced ODBC data source that will be used to retrieve rows from the specified data source.
Table (General tab)
Displays the table from the selected simple ODBC data source that data will be retrieved from.
Value (Filter tab)
Select a value to use to compare the selected field to.