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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.