topic Re: Why TPT can not be used when transfter data from Teradata to SAS table? in SAS Data Management

Why TPT can not be used when transfter data from Teradata to SAS table?

Jade_SAS — Mon, 11 Dec 2017 17:07:48 GMT

Hi All,

I guess the TPT is not set up correctly on the System.

I am using SAS server on Linux. I can use TPT to transfer data from SAS to Teradata table in SAS EG. The coding is as below:

Data TDLib.SAS_To_TD (tpt=yes fastload=yes tpt_max_sessions=4 );

set sashelp.shoes (obs=5);

Run;

But when I transfer data from Teradata to SAS table in SAS EG using the coding below, I got a note (in the EG log file) said that the TPT was not used .

Data work.TD_To_SAS ;

Set TDlib.visits_table (tpt=yes fastexport=yes tpt_max_sessions=4);

Run;

/*NOTE: Teradata connection: TPT (the default) was NOT used, the FastExport utility was used instead.*/

Do you have any idea what software is missing on the SAS server side or Teradata server side? Thank you!

Jade

Re: Why TPT can not be used when transfter data from Teradata to SAS table?

kiranv_ — Mon, 11 Dec 2017 18:48:19 GMT

can you try through libname statement as shown below.

Libname tera Teradata user=testuser pw=testpw FASTEXPORT=YES;

Re: Why TPT can not be used when transfter data from Teradata to SAS table?

Jade_SAS — Wed, 13 Dec 2017 02:13:06 GMT

Thank you, I tried the following with Server and database, the libname statement works. But my question is the TPT can not be used when transfer data from Teradata to SAS table.

Libname tera Teradata server=Teradata database=testDB user=testuser pw=testpw FASTEXPORT=YES;

Re: Why TPT can not be used when transfter data from Teradata to SAS table?

kiranv_ — Wed, 13 Dec 2017 02:40:20 GMT

did you see whether this did tpt fastexport

Re: Why TPT can not be used when transfter data from Teradata to SAS table?

Jade_SAS — Wed, 13 Dec 2017 20:04:32 GMT

fastexport works, but not the TPT. Thank you!

Re: Why TPT can not be used when transfter data from Teradata to SAS table?

sathya66 — Wed, 21 Aug 2019 07:25:38 GMT

Hi ,

Have you got any solution for this? we are on the same situation.

Thanks,