Over that last few years, 20 to be precise (man that makes me feel old) I have used a really cool product to deal with the need to have a local database available to applications. Originally it was in the Laptop era with PowerBuilder, then the Mobile era with the launch of PocketBuilder for PocketPC2003/Windows Mobile, and the latest, before now, iOS. In each case I was using SAP Sybase SQLAnywhere, including Mobilink.
What has always been great is having the strength of a self tuning Enterprise Database, along with the capability to securely synchonize bi-directionally the data within the remote & consolidated databases. This is no mean feat and something that SQLAnywhere has been excelling at for years, even when it was Watcom SQL. Making it an industry leader!!
So I was really excited a month ago to be included in the news that SQLAnywhere was going to become available on Linux for ARM. This now opens the door for Developers of the ever popular low cost Raspberry Pi, which is being used more and more for embedded IoT type of stuff, to create apps that can store information from sensors etc and synchronise them back to other databases, such as SAP HANA & SAP ASE, for further analysis etc.
This was my first attempt at such an Interesting ingredient in the Pi Mix! My initial project getting the office temperature every 10 minutes
1. Getting to grips with the Raspberry Pi Linux, Including installing Raspian and wiring up a digital temp sensor to a breakout breadboard
2. Installing SQLAnywhere on the Pi & my Macbook (in my case the mac was where I would connect remotely from and run the Mobilink Server)
3. Running SQLAnywhere on the Pi, after adding a new table in the Database to store, Datetime, Temperature
4. Having a Python scrip running to get the temperature from the sensor & write a record into the database
NOTE Rather than repeat every step check out Eric Farrar's, (Product Manager at SAP)cool blog here to get you started and here are some useful URLs...
This Flipboard magazine uses current content from the SAP Community NetworkSCN, during the months of June, July and August 2014
Mobile is now a part of most of our lifestyle and reaches most areas of our everyday lives… Relaxation, Shopping, Social etc. It is also now a foundation of Enterprise Business, allowing the extension of business data and existing systems into the hand of the mobile information worker, out on the road.
Within the magazine you will find content covering the SAP Mobile Platform , Mobile Secure and more.
Check out SAP Devs - Mobile (Summer 2014) by SAP Developers here
Over the next few weeks I will be speaking with Sanjay Kalyanasundaram, Director Developer Program at Mocana, to get an overview of SAP Mobile Secure by Mocana. In future CodeTalks Sanjay will explain a number of MAP (Mobile App Protection) policies supported.
The first 'Introduction' CodeTalk is available here and the others will follow on a Thursday from April 10 onwards.
CodeTalk #1 (Email Enforcement , App Federation, Copy and Past Protection, App Expiration) here
CodeTalk #2 (Browser Single Sign On, Require Password, Data Wipe, User Agreement) here
CodeTalk #3 (Encrypted Data - at Rest, Smart Firewall, Jail Broken Root Detection) here