teradata

Connecting C++ and Teradata with ADBC

Instructions

Tip

If you don't already have a Teradata instance running, we recommend signing up for a free ClearScape Analytics trial.

Prerequisites

1. Install Pixi

2. Install dbc

Connect to Teradata

1. The ADBC driver for Teradata is available from Columnar's private driver registry. Create a Columnar Console account and activate a 14-day free trial. Then authenticate to the registry:

   dbc auth login

2. Install the ADBC driver for Teradata:

   dbc install --level user teradata

3. Download and install the Teradata Tools and Utilities (TTU). Select "Tools and Utilities" and choose the package for your platform. Install to the default location:

   • Linux: /opt/teradata
   • macOS: /Library/Application Support/teradata
   • Windows: C:\Program Files\Teradata\Client

   On Windows, you can do this with winget install Teradata.TTUBase

   On macOS with Homebrew, you can do this with brew tap Teradata/teradata && brew install ttubasesuite

4. Set LD_LIBRARY_PATH (Linux), DYLD_LIBRARY_PATH (macOS), or PATH (Windows) to make sure the TTU libraries are discoverable by your application.

5. Customize the C++ program main.cpp:

   • Change the connection arguments in the AdbcDatabaseSetOption() calls.
     • uri is the URI of your Teradata instance. The format is teradata://user:password@host[:port].
   • Change the SQL SELECT statement in AdbcStatementSetSqlQuery().

6. Build and run the C++ program:

   Using Make:

   pixi run make
   ./teradata_demo

   Or using CMake:

   pixi run cmake -B build
   pixi run cmake --build build
   ./build/teradata_demo

Clean up

Clean build artifacts:

Using Make:

pixi run make clean

Using CMake:

rm -rf build