Friday, September 25, 2009
Saturday, September 12, 2009
SAS iPhone App Architecture
In this example, the iPhone application on the iPhone communicates through standard TCP/IP protocol to a web server. The web server then communicates to an application server which is actually a SAS session processing SAS programs and data. The output resulting from the SAS program is then delivered back to the iPhone in a similar way a web browser would access a web page the serer. The distinction however is that the iPhone application is not a web browser and the SAS session running on the server is more dynamic compare to a static page. The SAS data and macro program it executes may be simple and standard but facilitating the communication takes a little more effort. The request from the iPhone application and the delivery of information from the server is handled by BI Flash. This makes the experience more dynamic and delivers the full power of SAS on the server. The following steps are taken in order to facilitate the access of SAS data from an iPhone App.
Step 1 - Download iPhone Application
Step 2 - BI Flash Application Server
More details on this step will be explained in the "Application Server" section but an administrator would execute the BI Flash server. This server functions as a listener waiting for a request from the iPhone. Upon receipt, it would process the request similar to how you would submit SAS programs from display manager. The server would generate a SAS log and output results in XML which is then sent back to the iPhone to be viewed.
Step 3 - Connect iPhone to Application Server
Host Name - This the name of the server or an IP address of the SAS server.
User Name - A valid user name that has been defined on the server needed during authentication
Password - A user defined password to secure access
Step 4 - Run Application
There may be other configuration options which will set the default behavior of the application but the parameters above show the minimum requirement in order to connect to a SAS server.
The final step taken by the user to access SAS data is to execute the SAS macros from the iPhone. This request is initiated from the iPhone app and sent directly to the server with user selected options. The results are then returned to the iPhone displaying the most updated information on the server.
The system architecture in this example is rather simple compared to other systems that require multiple layers of middleware. This is similar to the SAS/IntrNet where users are on a web browser accessing SAS data and programs on the server through the broker and SAS application server. The difference however is that the client is not a browser, but rather a dynamic iPhone application.
Searching through the iPhone App Store, I could not locate the BI Flash application that Sy references. Regardless, the architecture that Sy describes is very similar to that used by WebFOCUS which I will document in the near future.
Wednesday, September 9, 2009
I never intended to buy an iPhone. Instead, I planned to replace my Treo with a brand new Palm Pre from the same carrier. Unfortunately for Sprint and Palm, the teenagers working at the strip-mall store lost my order. After weeks of strange phone calls with kids who could never find my order nor know when truck shipments would arrive ("Dude, if I could predict the future, I would be rich and not work for Sprint!"), I simply went to the Apple Store and came out with an amazing iPhone.
While waiting in the red velvet line (this was the weekend of the 3Gs release), I was introduced to the Apple Fan subculture. When not tapping away at the touch screen, iPhone users advocated their favorite downloaded apps with cohorts. Apple employees were professionals, passionate about their work.
Literally within seconds, the iPhone was accessing my personal and corporate e-mail accounts and calendars. I could easily connect to WiFi or the AT&T 3G network to browse websites with the Safari browser. Even secure sites were available through a VPN connection.
I even paid the $2.99 per month fee to listen to Sirius XM satellite music on the iPhone. (I also got a sick feeling about having just paid $150 for an MP3 player and $399 for a Sony Book Reader.) Everything I needed to be productive was now at my fingertips; I stopped waiting for the Windows bootup on my PC except for things that required heavy-duty typing.
So far, two individuals have walked away from my personal iPhone demos to go directly to the Apple Store to buy their own. Yes, the same day. Immediately. Others have changed their Christmas, birthday, and other gift-buying/gift-getting plans. One of my straight-laced employees responded to my iPhone enchantment with, "Sorry, I want my phone to be a phone. That's all it needs to do."
So I added some real sizzle.
On my iPhone, I logged into a secure executive dashboard for a well-known restaurant. The Safari browser visually showed corporate-wide key performance indicators for sales, speed of service, food costs, labor costs, and cash register operations. All right there in my hand, blazing fast. From the total level, I tapped down through the company hierarchy until I reached a specific store. I looked at their raw item inventory to see if they had enough cheese. I pointed out a red stoplight where the manager had failed to staff enough people on cash registers the previous day, causing a negative impact to speed of service and revenues. I tapped to get a trend of the past 20 days to see if that was just a new occurrence.
My friend responded, "Boy, I have to get one of those."
We had created this business intelligence application using the WebFOCUS software product from Information Builders. Initially, the plan was to have on-demand access through a PC web browser and push out static reports to e-mails, printers, and Blackberry devices.
Just like my personal use of the iPhone, the restaurant's corporate use of iPhone was accidental. During the development project, somebody tried to access the dashboard directly with a Blackberry but with no luck. It seems that the WebFOCUS BI Dashboard uses web techniques not supported by the Blackberry. Even if the Blackberry user could get past the initial dashboard screens, the reports did not display well on the handheld.
Not so on the iPhone. The Safari browser is top-notch and allows zoom in-and-out of the screen content. Even client-side scripts, cookie techniques, and secure LDAP integration worked on the iPhone. The iPhone even supported dashboard exports of data to PDF and Excel.
My accidental iPhone purchase has caused all sorts of changes for me and the people around me. I would write more about it, but I have to go sign for a FedEx package -- an Apple MacBook Pro just showed up.
With over 20 years of industry experience, Doug Lautzenheiser has provided business intelligence services for well-known organizations such as Procter & Gamble, JPMorgan Chase, Omnicare, Wendy’s International, the State of Indiana, and the State of Oklahoma. ComputerWorld recognized one of Doug's projects with honors for innovative use of technology. Doug is a featured blogger on BI software at Smart Data Collective.
With his broad knowledge of technologies, business processes, and industry best practices, Doug provides client value by performing strategic advisory services; leading tactical BI application development projects; and enabling dramatic reductions in time, cost, and risks through his unique automated BI consolidation application.
Doug has hands-on experience with a variety of enterprise applications. He is degreed summa cum laude in Information Systems from the University of Cincinnati. An experienced trainer and mentor, Doug has provided educational services to organizations such as National Semiconductor, Ford Motor Company, Northwest Airlines, Principal Financial Group, and Target Stores. Doug is the owner of Kencura Systems.
Talk to Doug before manually performing a large BI initiative. Doug will show you how other smart companies saved time and money by following proven methodologies and automating BI processes instead of letting somebody "wing it" with a manual approach.
B2B software vendor leadership. BI implementations, standardization, and consolidation; data warehousing; WebFOCUS; iWay; BI vendors (Cognos, SAP Business Objects/Crystal Reports, Microstrategy, Actuate, Hyperion/Brio, SAS, Tableau Software); ERP; and full SDLC.