Loading Aster Tables to Advanced SQL Engine Using ODBC - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
The ODBC instructions follow. To follow them, you must have an account on https://downloads.teradata.com.
  1. Install Teradata Parallel Transporter Base.
  2. Set up the Aster driver on the client machine.
  3. If the table does not exist on Aster Database, create and populate it there.
  4. On Advanced SQL Engine, do the following:
    1. If the user who is to own the table does not exist, create it.
    2. Write the tpt script.
    3. Write the JobVariablesFile.
    4. Use the tbuild command to run the tpt script.