Source adapters connect to a source (such as delimited text files, XML files, or ODBC databases), and extract data before passing it to the Integration Manager engine.
The ODBC/text adapter extracts data from ODBC and text sources. Integration Manager supports three types of ODBC/text sources: Text, Simple ODBC, and Advanced ODBC. Text sources retrieve data from text files. Simple ODBC sources retrieve data from an ODBC data source. Advanced ODBC sources issue SQL statements from SQL Server to retrieve information from an ODBC data source.