Alternative Method for Accessing SAS Framework Data Server Content

0

Back in 2011, I wrote about the all new SAS Framework Data Server in 9.3 and how it needs to be running for certain web applications to function properly. But it is actually used as the data storage device for multiple SAS components including webdav content, alerts, comments, and workflows. During your configuration, you can choose to use another RDBMS database but in the default SAS uses a .FDB data structure stored as SAS-config-dir\\Lev1\\FrameworkServer\\Content\\SHAREDSERVICES.FDB.

So ... what if you have a default installation and need to access this data for other purposes. Think custom SAS Stored Process with all comments saved about a specific BI Dashboard report. On initial research, the only way to access this .FDB appeared to be a JDBC Data Source connection. But then I got really lucky, not enough to win Wednesday night's Powerball but still lucky! SAS has a hidden SASTS library type. Included is the framework (geek joke intended) of the connection string:

libname fdsdb sasts server=<SAS-server-host> port=22031 protocol=bridge 
user='sasadm@saspw' password=<password> 
noprompt="driver=tssql;conopts=(dsn='SharedServices')"; 

After updating the string with your connection information and running in SAS, you will then be able to review the data tables. Note that a better practice would be to copy the data tables into your personal area to avoid locking them in production.

proc datasets library=fdsdb nolist;
   copy out=work;
quit;

It's probably good that I didn't win the Powerball lottery anyway, I would have a difficult time sharing with the two other winners. At least I can win by finding these wonderful tidbits and sharing them with you.

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Related Posts

Leave A Reply

Back to Top