topic Re: data load using SAS EG. in SAS Enterprise Guide

data load using SAS EG.

Nirmalya — Mon, 04 Mar 2019 09:00:24 GMT

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 ?

Re: data load using SAS EG.

ChrisBrooks — Mon, 04 Mar 2019 09:34:15 GMT

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

Re: data load using SAS EG.

TomKari — Mon, 04 Mar 2019 16:31:46 GMT

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