System Prerequisites| Teradata Access Module for OLE DB - System Prerequisites - Access Module

Teradata® Tools and Utilities Access Module Reference - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Access Module
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-05-14
dita:mapPath
cya1691484517272.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
hjf1479308836950
lifecycle
latest
Product Category
Teradata Tools and Utilities
The Teradata Access Module for OLE DB requires the following:
  • The Windows version of a Teradata utility (Teradata BTEQ, Teradata FastExport, Teradata FastLoad, Teradata MultiLoad, Teradata PT, or Teradata TPump) to transport data
  • ODBC Driver for Teradata
  • An OLE DB provider
    The installation of the Teradata Access Module for OLE DB ensures that the following Microsoft data access components (MDAC) and OLE DB providers are available:
    • Microsoft OLE DB Provider for SQL Server
    • Microsoft OLE DB Provider for Oracle
    • Microsoft OLE DB Provider for Microsoft Jet (to access data from Access, Paradox, dBASE, Excel, FoxPro, text, and more)
    • Microsoft OLE DB Provider for ODBC Driver (to access data traditionally accessed using ODBC)

For more information about OLE DB providers, consult the Microsoft Web site, or the SQL Summit web site.

The Teradata Access Module for OLE DB installation procedure installs MDAC on Windows 2000. On all later versions of Windows, MDAC installs through the operating system update.
Related information