Use Cases: Loading Data Using TPT, ODBC, JDBC, or QueryGrid - Teradata VantageCloud Lake

Lake - Manage and Move Data

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-05-16
dita:mapPath
atx1683670417382.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
atx1683670417382
  • Use case: You have existing processes or data sources that Teradata® Parallel Transporter (TPT) supports, or you need to prepare data using in-database data prep functions.
    • Load option: Load a file system table as a stage using TPT, FastLoad, MultiLoad, Teradata Drivers, or READ_NOS. Then, INSERT-SELECT from the staging table to the target table in the Object File System. For details, see Teradata Tools and Utilities.
  • Use case: Custom integration or partner integration.
    • Load option: Use the Teradata drivers (JDBC and ODBC) to establish a connection directly to the Object File System tables. For details, see Teradata Tools and Utilities.
  • Use case: You have existing data in VantageCloud Enterprise or VantageCore that needs to be replicated on the Object File System.
    • Load option: Import data from VantageCloud Enterprise or VantageCore to VantageCloud Lake using QueryGrid.