Migrating from Aster Database to Teradata Vantage | Teradata Vantage - 2.2 - Migrating from Aster Database to Teradata Vantage - Teradata Vantage - Teradata Vantage on AWS - Teradata Vantage on Azure - Teradata Vantage on Google Cloud - Teradata Vantage on IntelliFlex

Teradata Vantageā„¢ User Guide

Product
Teradata Vantage
Teradata Vantage on AWS
Teradata Vantage on Azure
Teradata Vantage on Google Cloud
Teradata Vantage on IntelliFlex
Release Number
2.2
Release Date
January 2021
Content Type
User Guide
Publication ID
B700-4002-011K
Language
English (United States)
When migrating from Aster Database to the Teradata Vantage environment, there are technical categories that must be considered. Work with Teradata Services to create a migration plan.
Migration Categories Comments
Users
  • User metadata
Users are converted as they are, with default options.
User data
  • Databases, schemas, and tables with their data are migrated.
  • Semi-automated migration that involves running scripts on Aster Database and Teradata Vantage.
  • There are limitations in migrating some objects and data arising from the limitations in data types, ranges, and so on, in Teradata Vantage compared to Aster Database.
Metadata Automatically generated for data migrated to Teradata Vantage.
Workflows Aster SQL and Aster commands must be converted. The migration tool is capable of either converting a single or a batch of Aster SQL/SQL-MR scripts into scripts that can be directly run on Vantage
Functions
  • User defined functions (UDF) and installed functions.
Installation of user defined functions and installed functions from Aster Database to Teradata Vantage is supported.
Clients
  • JDBC and ODBC-connected user environment.
The Aster JDBC driver must be changed to Teradata JDBC driver with the URL for JDBC connection.
ADE Functions developed using ADE work, but deployment requires alteration.
R Workflow must be migrated.
Other applications or scripts  
Aster Analytic Models Analytical Models from Aster Database to Vantage is supported.
ADFS Files used by Text analytical functions saved in ADFS of Aster Database are copied to CLOB/BLOB columns in Vantage.