TPT - ODBC connector missing

Tools & Utilities
Enthusiast

TPT - ODBC connector missing

Hello friends,

I am a beginner to TPT and working on some basic scripts. I have done Export, Load from Teradata(one environment) to other Teradata environment.

FYI, I am running the scripts through unix.

While working on the export and Load, I observed the path of the operators (/opt/teradata/client/14.00/tbuild/template). I assume TPT internally access these operators to get the job variables.

Now I am trying to extract the data from Oracle db using Oracle operator and I observed there are no files in the name of $Oracle_Operator.txt under '/opt/teradata/client/14.00/tbuild/template'. Also I am not able to create Oracle_Operator.txt file (with the required variables). Kindly suggest me on how I should proceed further.

Kindly help me on the same.

Regards,

Arun Prasad

6 REPLIES
Teradata Employee

Re: TPT - ODBC connector missing

You are probably venturing where you do not need to go.

The "template" directory is for our templates and you (as a beginner) should not be accessing those files.

If you would like to know how to use our operators, please refer to our documentation (the User Guide). We provide all of the necessary information for most (if not all) of the scenarios you would like to run, including the use of the ODBC operator.

The User Guide also has script samples.

You can also look in the "samples" directory for script samples.

-- SteveF
Enthusiast

Re: TPT - ODBC connector missing

Hi feinholz,

Thank you for your quick responses ! I have been following lot of your other posts as well and that helps me a lot. I am still having issues with my script and the details are provided below.

The below is what exactly I am trying.

1) Connect to oracle db to extract data

2) Create the table in Teradata and load the data from Oracle to Teradata

The script is provided below:

DEFINE JOB ODBC_LOAD
DESCRIPTION 'ODBC LOAD PRODUCT DEFINITION TABLE'
(
  DEFINE SCHEMA Sanity_Test_ODBC_Schema
  (
    DATA_SOURCE_NAME          VARCHAR(35),
    MP_ATTRIBUTES_VIEW_NAME   VARCHAR(35),
    MP_EVENTS_VIEW_NAME       VARCHAR(35)
  );

  DEFINE OPERATOR DDL_Operator
  TYPE DDL
  ATTRIBUTES
  (
    VARCHAR PrivateLogName = 'ddl_log',
    VARCHAR TdpId           = '112.18.132.124',
    VARCHAR UserName        = 'prasad_a',
    VARCHAR UserPassword    = '********',
    VARCHAR ARRAY ErrorList = ['3807','3803']
  );

  DEFINE OPERATOR ODBC_Operator
  DESCRIPTION 'Teradata Parallel Transporter ODBC Operator'
  TYPE ODBC
  SCHEMA Sanity_Test_ODBC_Schema
  ATTRIBUTES
  (
    VARCHAR PrivateLogName = 'odbc_log',
    VARCHAR DSNName        = 'TODS',
    VARCHAR UserName       = 'scott',
    VARCHAR UserPassword   = '********',
    VARCHAR SelectStmt     = 'Select DATA_SOURCE_NAME,'   ||
                             'MP_ATTRIBUTES_VIEW_NAME,'   ||
                             'MP_EVENTS_VIEW_NAME'        ||
                             'from MSDS_DATA_SOURCE_VW;'
  );

  DEFINE OPERATOR Load_Operator
  TYPE LOAD
  SCHEMA *
  ATTRIBUTES
  (
    VARCHAR PrivateLogName = 'load_log',
    VARCHAR TdpId          = '112.18.132.124',
    VARCHAR UserName       = 'prasad_a',
    VARCHAR UserPassword   = '********',
    VARCHAR TargetTable    = 'PRASAD_A.MSDS_DATA_SOURCE_ODBC',
    VARCHAR LogTable       = 'PRASAD_A.odbc_test_log',
    VARCHAR ErrorTable1    = 'PRASAD_A.odbc_test_error1',
    VARCHAR ErrorTable2    = 'PRASAD_A.odbc_test_error2'
  );

  Step Setup_Into_Tables
  (
    APPLY
     
      ('create table PRASAD_A.MSDS_DATA_SOURCE_ODBC (
            DATA_SOURCE_NAME         VARCHAR(35),
            MP_ATTRIBUTES_VIEW_NAME  VARCHAR(35),
            MP_EVENTS_VIEW_NAME      VARCHAR(35)
             );')

    TO OPERATOR (DDL_Operator);
  );

  Step Insert_Into_Tables
  (
    APPLY
('INSERT INTO PRASAD_A.MSDS_DATA_SOURCE_ODBC (:IN_RECV_DT,
                                              :IN_RTL_CO_NUM,
                                              :IN_STR_NUM);')
    TO OPERATOR (Load_Operator)

    SELECT
      DATA_SOURCE_NAME,
      MP_ATTRIBUTES_VIEW_NAME,
      MP_EVENTS_VIEW_NAME
    FROM OPERATOR (ODBC_Operator);
  );
);

The below is the my log: "tlogview -l ODBC_LOAD3-80.out"

TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Teradata Parallel Transporter Coordinator Version 14.00.00.03
Teradata Parallel Transporter Executor Version 14.00.00.03
Teradata Parallel Transporter SQL DDL Operator Version 14.00.00.03
DDL_Operator: private log specified: ddl_log
DDL_Operator: connecting sessions
DDL_Operator: sending SQL requests
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
DDL_Operator: disconnecting sessions
DDL_Operator: Total processor time used = '0.29 Second(s)'
DDL_Operator: Start : Tue Feb  4 06:02:03 2014
DDL_Operator: End   : Tue Feb  4 06:02:04 2014
Job step Setup_Into_Tables completed successfully
Teradata Parallel Transporter Executor Version 14.00.00.03
Teradata Parallel Transporter Executor Version 14.00.00.03
Teradata Parallel Transporter Coordinator Version 14.00.00.03
TPT_INFRA: TPT01036: Error: Task (TaskID: 7, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
Job step Insert_Into_Tables terminated (status 8)
Job ODBC_LOAD3 terminated (status 8)
Total available memory:          10002340
Largest allocable area:          10002340
Memory use high water mark:         74856
Free map size:                       1024
Free map use high water mark:          18
Free list use high water mark:          0

 When I refered the posts related to this, I came to know there are some latest patches to it. I am currently using Teradata Version - 14.00.00.03.

If I have to update those patches kindly do let me know what is the patch and where I can download it.

Thanks,

Arun

Teradata Employee

Re: TPT - ODBC connector missing

Always upgrade to the latest patch.

Question: why are you concatenating the SELECT statement in the ODBC operator?

-- SteveF
Enthusiast

Re: TPT - ODBC connector missing

Hi feinholz can you pls tell me where I can download utility guide for TPT 14.1.

Teradata Employee

Re: TPT - ODBC connector missing

Please let me know where you found that sample script with the concatenation.

We need to get that removed/changed.

Thanks!

As for coredump, you must upgrade to the latest patch. We cannot assist you when you are working with an older version (the patch may have fixed the coredump).

-- SteveF
Enthusiast

Re: TPT - ODBC connector missing

Hi Feinholz,

I got the sample script from "*\Teradata\Client\14.00\Teradata Parallel Transporter\sample\userguide\uguide06.txt".

Thank you for assisting me on this !