Testing the connection to the Teradata server

Test the connection to the Teradata server to verify that the Teradata client software is properly set up on the federated server.

Before you begin

The Basic Teradata Query (BTEQ) utility and the Teradata Data Connector Application Program Interface (PIOM) must be installed on the federated server. The BTEQ utility and the Teradata Data Connector Application Program Interface are installed on the federated server when you install the Teradata client software.

About this task

You use the BTEQ utility to submit an SQL query to verify that the federated server can connect to the Teradata server. See the Teradata documentation for more information about the BTEQ utility.

Procedure

  1. Start a BTEQ utility session and log on to the Teradata server.
  2. Issue an SQL command to verify that you can successfully connect to the Teradata server.
    For example: 
    select count(*) from dbc.tables;

    If the connection is successful, you will see the output from the query.

    If the connection is unsuccessful, you will receive an error. Check the Teradata client software to verify that it is properly installed and configured on the federated server.

  3. Log off from the Teradata server and end the BTEQ utility session.

What to do next

After you complete this task, verify that the Teradata library is enabled for run-time linking.