|
Overview
Custom Query tab is used to shape source data being used in the import.
Key Concepts
| • | By default, when reading the data from your source, Import Tools is effectively reading: select * from [your data source]. Using Custom Query, you can customize the return set that gets pushed to Field Mappings. |
| • | In short, Import Tools passes your query to Microsoft.ACE.OLEDB.12.0 which then communicates to the source. The syntax used in the query is dependent upon the File Type (Data Source) configured on the General Tab. Typically |
| • | ODBC - Contingent upon the driver. (ex. MS SQL = T-SQL, Oracle = Oracle SQL) |
Field Descriptions
| • | Query Window - Custom Query is entered here. Knowledge of SQL is required. |
| • | Test Query - Returns a test result of the SQL Query. |
|