Teradata Cookbook
上QQ阅读APP看书,第一时间看更新

How it works...

Teradata SQLA allows you to connect to a data source using the ODBC and .NET framework. When you install SQLA from TTU toolkit, make sure to check all the options. You will have two executables:

  • TTU_BASE has the following:
    • ODBC driver
    • BTEQ
    • All the loading tools, such as fastexport, fastload, and many others
    • Named pipe modules
    • Websphere access modules
    • .NET data provider
    • C preprocessor 2
    • Tearadata adminstrator
    • SQLA
    • Teradata Wallet and many more
  • TTU_DBM has the following:
    • Index wizard
    • BTEQ
    • ODBC driver
    • Query scheduler admin, client, server
    • TSET
    • Workload analyzer
    • Visual explain
    • Teradata Wallet