topic Re: SAS Federation Server in SAS Data Management

SAS Federation Server

SwapnaKumari — Mon, 24 Jul 2017 11:53:20 GMT

Hi Team,

Need help on SAS Federation Server.

The question is can we write SAS code to manually edit teradata tables via SAS Federation Server. if yes then can someone help me with the code please.

Any help will be really appreciated.

Regards,

Swapna

Re: SAS Federation Server

kiranv_ — Mon, 24 Jul 2017 16:01:55 GMT

I have written FEDSQL few times. Federation Server helps us to connect with various DBMS and accepts ANSI SQL. AS far as I know federation server is more about connecting to Different databases rather than manually editing database Tables. DBMS tables are not meant for data enteries. You can use an update statement or insert statement to inter or edit table in FEDSQL. I am not totally sure about editing Teradata Tables from Federated server

Re: SAS Federation Server

LinusH — Thu, 27 Jul 2017 08:03:43 GMT

Chime in with @kiranv_ Federation Server is mainly about consolidating and virtualization, not application data entry.
When you say manually and SAS code, I can think of SAS Stored Process. Or how do you intend to manage those updates in practice?
Either way, I think this could/should be handled via a SAS/ACCESS engine.