I'm new to Teradata PT API and am using PT API script to intract (Load/Unload) with Teradata.
I am using TD_LOAD operator to load the data in Teradata table and the TPT API script is working
fine with flat file as a source.
Now I have to load the data directly from other RDBMS such as Oracle or SQL Server.
I generated the TPT script using TPT wizard with SQL Server as source and Teradata as target.
It has generated the TPT script with DSNName attribute.
How can I set the ODBC connection (DSNName, Password and etc.) string through TPT API script for source connection.
Appreciate your help on this.
TPTAPI does not use a script, and so referring to TPTAPI in this context is not correct.
TPTAPI is an "API" interface in which you write a C++ program to have direct control over the TPT operators.
So, I am assuming you are using script-based TPT.
What version of TPT are you using?
TPT has the ability to interface to Oracle and SQLServer by using the ODBC operator.
And the ODBC Operator has attributes for specifying the DSN name, username and password.
Please refer to TPT documentation for more information.
Thanks for your reply on this.
Sorry I shouldn't have mentioned TPT API script and I'm trying to connect RDBMS (Oracle/SQL Server) from TPT API interface.
You have mentioned that we have to write a C++ program, that means we have to write C++ code using ODBC driver to connect any RDBMS.
The TPTAPI interface only connects to Teradata.
It does not connect to Oracle.
If you would like to move data from Oracle to Teradata, then use the script-based TPT, and use our ODBC operator to retrieve data from Oracle and feed the data to a loading operator to load into Teradata.