15.10 - System Prerequisites - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
15.10
category
Programming Reference
featnum
B035-2425-035K

System Prerequisites

The Teradata OLE DB Access Module 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 OLE DB Access Module 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 OLE DB Provider for Teradata User Guide (B035‑2498), the Microsoft Web site, or the SQL Summit web site.

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