Migrating from Aster Database to Teradata Vantage - Teradata Vantage

Teradata® Vantage User Guide

Product
Teradata Vantage
Release Number
1.0
Published
January 2019
Language
English (United States)
Last Update
2020-03-11
dita:mapPath
hfp1506029122470.ditamap
dita:ditavalPath
hfp1506029122470.ditaval
dita:id
B700-4002
lifecycle
previous
Product Category
Teradata Vantage
When migrating from Aster Database to the Teradata Vantage environment, there are technical categories that must be considered. Work with Teradata Customer Support 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.
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  
Teradata AppCenter connection and all Teradata AppCenter apps Supported