Setting up general properties for ODBC sources

When you add a new simple ODBC source to an integration, the Properties window opens. Use the following procedure to set the options on the General tab of the Properties window.

To set up general properties for an ODBC source:

  1. Open the properties window for a new simple ODBC source.
    Open an integration > Add Source > Simple ODBC > Define New Simple ODBC
  2. Specify the name and description of the simple ODBC source.

The name should describe the type of information retrieved by the ODBC query. The description should provide information about the source, such as what type of data is retrieved by the query or what data is contained in the source.

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, go to the MSDN online library (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.


  1. On the General tab of the Properties window, select the data source and table from which the information will be retrieved.

Data Source   This is the ODBC data source to retrieve data.

Table   This is the table to use from the ODBC data source.

  1. If you’re using an .xls file type, enter a named range. Select the data range, including column headings, and choose Insert > Name > Define. Type the new name for the reference and click Add.
  2. After setting up the general properties of the simple ODBC source, you need to set up the other source properties. See Setting additional properties for ODBC or text sources. Be sure to save your integration when you are finished.

Documentation Feedback