When developing SAS applications, you can feed Database tables into your application by using the libname access engine either by directly referring a database table, or via SAS or database views that themselves refer to one or more of the database tables. 

However, such on-the-fly data access may not be efficient enough, especially for interactive SAS applications when system response time is critical. In case of distributed systems where a database might reside on one server, and the Sas Application Server – on a different physical server, user wait time caused by delays in data access across networks and databases might become intolerable. In such cases, it makes perfect sense to extract database tables and load them into SAS tables in advance, preferably placing them on (or close to) the SAS Application server. That will ensure higher operational efficiency (responsiveness) of the interactive SAS application. 

SAS Training & Placement Programs with Internship*:

Epoch Research Institute India

Largest and Oldest SAS Training Institute

Epoch Research Institute Links:
http://www.epoch.co.in/
https://www.facebook.com/EpochResearchInstitute
https://twitter.com/epochresearch
https://www.linkedin.com/company/epoch-research-institute-india-pvt-ltd-