TDV Adapters simplify and accelerate high-performance access to a wide range of data sources including popular enterprise applications, relational and multidimensional data sources. TDV adapter features include interactive metadata mapping, integration of and resolution for most vendor-specific SQL, and statistical analysis of source tables to enable quick optimization of query execution plans. TDV adapters provide certified, vendor-specific connectivity that leverages data source APIs. TDV adapters for non-relational data sources let you create views that represent data as relational tables.

TDV adapters capture data source settings that are then recorded in the metadata modeling layer, for use when query execution plans are calculated. Refer to Adding and Removing Data Source Resources, for more information.

TDV provides some data adapters that have default settings. If data source instances have been changed to handle data and SQL in a special way, you might need to modify the adapter for best performance.