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

SAS Federation Server

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

SAS Federation Server

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


Accepted Solutions
Solution
‎09-13-2017 08:49 AM
Super User
Posts: 5,429

Re: SAS Federation Server

Posted in reply to SwapnaKumari
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.
Data never sleeps

View solution in original post


All Replies
PROC Star
Posts: 325

Re: SAS Federation Server

Posted in reply to SwapnaKumari

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

Solution
‎09-13-2017 08:49 AM
Super User
Posts: 5,429

Re: SAS Federation Server

Posted in reply to SwapnaKumari
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.
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 230 views
  • 1 like
  • 3 in conversation