data load using SAS EG.

[Nirmalya]

Suppose my source tables are in Oracle server. Now I want to extract data from oracle server and after transformation I want to load final data into Teradata server using SAS EG. 

How can I do that ?

[ChrisBrooks]

Hi @Nirmalya and welcome to the community.

The easiest way would be to use SAS/ACCESS Software - you'd need both ORACLE & TERADATA ACCESS licences. Failing that ODBC might be an option.

Here's a link to the SAS/ACCESS info page https://www.sas.com/en_gb/software/access.html

[TomKari]

The easiest option is to simply use the query builder, with the output being a table in your Teradata environment. But if efficiency is a concern, you'd probably want to use any bulk loading facilities that are available, and to do that you'd need to write code in a code window.

Are you comfortable writing SAS code?

Tom