SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Regular Contributor
Posts: 223

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

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

PROC Star
Posts: 503

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

can you try through libname statement as shown below.

 

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

Regular Contributor
Posts: 223

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

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;

PROC Star
Posts: 503

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

did you see whether this did tpt fastexport

Regular Contributor
Posts: 223

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

fastexport works, but not the TPT. Thank you!

Ask a Question
Discussion stats
  • 4 replies
  • 212 views
  • 0 likes
  • 2 in conversation