This blog is designed to show various ways to use Data Virtualization, technologies, and SAS with Microsoft technologies with an eye toward outside of the box thinking.
Monday, February 27, 2006
RoboHelp and IIS 6.0
I hope this helps someone else in this same boat.
Alan
Thursday, February 09, 2006
Web Services and SAS
- An API has to be created and maintained over time
- Neither application plays to its strengths but instead each one 'dumbs' down to the lowest common denominator of both applications
- You always have to search for the specific API to use to get anything done
- There is no central way of managing these APIs and you get a lot of code bloat
To solve these issues, web services were born. Now web services may sound like voodoo or black magic but they are very, very simple. Everyone, and I mean everyone (including SAS), agreed to have a common means (XML) of transporting information between each other. I won't go into the ugly details of web services because the web is rife with them but let's talk about how they could be used to solve the typical SAS scenario I mentioned above.
You have SAS running on a Unix server and all of your users want it in Excel.
Old solution: Use SAS\Access to create an Excel file, use ODS to create a very bloated Excel file, write out to CSV, etc. Run the code, ftp the file to a server for delivery, have the end users read in the data and parse it themselves, or again use ODS and figure out the coding needed to create an Excel report.
New solution: Create a web service on Unix that reads in the SAS data using OleDB, ODBC, etc. and just expose a service (let's call it GetSasData("ExcelData"). Next have Excel consume that service and parse the data into the exact Excel report you need.
Ok. You may say that the new solution doesn't sound much better than the old. But wait!! Your boss now comes along and says can you please make that same data available to Lotus 1-2-3 and StarOffice. AHHHHH!!!! Under the old method you need to rewrite all of that ODS or just create an entirely new package. The boss then asks you to also support SAP and Oracle. AHHH!!
Ok, web services wouldn't require any changes because Oracle, SAP, etc. support web services. They can just consume that service the same as Excel. But, you claim, CSV is supported by everyone as well.
Actually, it isn't. Take the following CSV file:
Name Age Gender
Bill 29 M
Mary 32 F
Now is name a numeric, string, what does Name mean? CSV doesn't tell you and never will. Web services have support for typing information so you know what it is.
This blog merely scratches the surface. Don Henderson and I have put up some sample web services for people to play with over here:
http://demo.savian.net/SasWebServicesDemo/Service.asmx
I urge you to check them out and see what the possibilities are.
Out in left field and loving it,
Alan
Web Services and SAS
- An API has to be created and maintained over time
- Neither application plays to its strengths but instead each one 'dumbs' down to the lowest common denominator of both applications
- You always have to search for the specific API to use to get anything done
- There is no central way of managing these APIs and you get a lot of code bloat
To solve these issues, web services were born. Now web services may sound like voodoo or black magic but they are very, very simple. Everyone, and I mean everyone (including SAS), agreed to have a common means (XML) of transporting information between each other. I won't go into the ugly details of web services because the web is rife with them but let's talk about how they could be used to solve the typical SAS scenario I mentioned above.
You have SAS running on a Unix server and all of your users want it in Excel.
Old solution: Use SAS\Access to create an Excel file, use ODS to create a very bloated Excel file, write out to CSV, etc. Run the code, ftp the file to a server for delivery, have the end users read in the data and parse it themselves, or again use ODS and figure out the coding needed to create an Excel report.
New solution: Create a web service on Unix that reads in the SAS data using OleDB, ODBC, etc. and just expose a service (let's call it GetSasData("ExcelData"). Next have Excel consume that service and parse the data into the exact Excel report you need.
Ok. You may say that the new solution doesn't sound much better than the old. But wait!! Your boss now comes along and says can you please make that same data available to Lotus 1-2-3 and StarOffice. AHHHHH!!!! Under the old method you need to rewrite all of that ODS or just create an entirely new package. The boss then asks you to also support SAP and Oracle. AHHH!!
Ok, web services wouldn't require any changes because Oracle, SAP, etc. support web services. They can just consume that service the same as Excel. But, you claim, CSV is supported by everyone as well.
Actually, it isn't. Take the following CSV file:
Name Age Gender
Bill 29 M
Mary 32 F
Now is name a numeric, string, what does Name mean? CSV doesn't tell you and never will. Web services have support for typing information so you know what it is.
This blog merely scratches the surface. Don Henderson and I have put up some sample web services for people to play with over here:
http://demo.savian.net/SasWebServicesDemo/Service.asmx
I urge you to check them out and see what the possibilities are.
Out in left field and loving it,
Alan
SAS throwing RPC error
If you are doing code in C# and get this error when creating a LanguageService: The RPC server is unavailable. (Exception from HRESULT:...
-
I was just tasked to read in LDAP records so we could cross-reference userids with login identifiers and general ledger information. Using...
-
I am finally ready with my SAS dataset reader/writer for .NET. It is written in 100% managed code using .NET 3.5. The dlls can be found here...
-
Well, around 14 months ago, I started on a journey to understand the SAS dataset so I could read and write one independently. Originally, I ...