{"id":12432,"date":"2014-09-29T12:50:43","date_gmt":"2014-09-29T11:50:43","guid":{"rendered":"http:\/\/timoelliott.com\/blog\/?p=6804"},"modified":"2014-09-29T12:50:43","modified_gmt":"2014-09-29T11:50:43","slug":"a-slice-of-raspberry-pi-with-sap-lumira","status":"publish","type":"post","link":"https:\/\/timoelliott.com\/blog\/2014\/09\/a-slice-of-raspberry-pi-with-sap-lumira.html","title":{"rendered":"A slice of Raspberry Pi with SAP Lumira"},"content":{"rendered":"

\"lumira<\/a><\/p>\n

No, you can\u2019t actually run Lumira desktop on the $35 Raspberry Pi computer<\/a>, and sadly, even with the new Epiphany<\/a> browser, there doesn\u2019t yet seem to be a way to connect to Lumira Cloud<\/a>, but you can run Sybase SQL Anywhere on the device, and connect to it from Lumira Desktop.<\/p>\n

Why would anybody want to do this? \u2013 because we can! Or more realistically, you might just want to use a Raspberry Pi and SQL Anywhere in an internet of things scenario, collecting data from sensors<\/a>.<\/p>\n

I followed the recommended steps to install<\/a> and configure<\/a> the SQLAnywhere 16 demo database on my Raspberry Pi (although note that version 12 is currently the recommended version for the BusinessObjects tools, including Lumira).<\/p>\n

Here\u2019s a quick summary of those steps — refer to the links above for more details.<\/p>\n

Register for the latest SAP SQL Anywhere 16 Developer Edition<\/a>.\u00a0After registering you will be sent a registration key over email.<\/p>\n

Fire up your Raspberry Pi, then download and extract the SQL Anywhere Developer Edition (it\u2019s easiest to do this by connecting to the Pi from another computer using SSH, i.e. using a program like PUTTY<\/a> for Windows, or Terminal for Mac \u2013 you can\u00a0use “sudo ifconfig” to find out the Raspberry Pi’s current ip address \u2013 you can then just copy and paste the lines below.)
\n
\ncd \/tmp
\nwget http:\/\/d5d4ifzqzkhwt.cloudfront.net\/sqla16developer\/bin\/sqla16developerlinuxarmv6.tar.gz<\/a>
\ntar -xvf sqla16developerlinuxarmv6.tar.gz\u00a0 <\/code><\/p>\n

Install SQL Anywhere using the key your received earlier over email (accept all of the defaults)
\n
\ncd ga1600
\nsudo .\/setup\u00a0 <\/code><\/p>\n

Return to your home directory
\n
\ncd ~<\/code><\/p>\n

Add the path variables to the current<\/em> shell’s environment (see posts above on how to do this permanently).
\n
\n. \/opt\/sqlanywhere16\/bin32\/sa_config.sh\u00a0 <\/code><\/p>\n

To test out the environment, the following should return the current version of the server (e.g. 16.0.0.1972)
\n
\ndbsrv16 -v\u00a0 <\/code><\/p>\n

If everything is working, create a copy of the demo database and start it as \u201cmydemo\u201d
\n
\nmkdir dbscratch
\ncd dbscratch
\ncp \/opt\/sqlanywhere16\/demo.db .
\ndbspawn -f dbsrv16 -n mydemo -o server.out demo.db<\/code><\/p>\n

You can then switch to Lumira on another PC connected to the same network, open a new document, choose \u201cSybase SQL Anywhere 12 \u2013 JDBC Drivers\u201d, and fill in the following fields:
\n
\nusername: dba
\npassword: sql
\nserver: 192.168.0.35:2638 <replace with the IP address of the Raspberry PI
\ndatabase: mydemo<\/code>\u00a0<\/code><\/p>\n

\"lumira<\/p>\n

The drivers seems to work OK, although I didn’t get a list of the available tables. To get data, you can do a SQL query such as \u201cSELECT * From Customers\u201d (you can see the full demo schema here<\/a>)<\/p>\n

\"lumira<\/p>\n

You can then manipulate the data in Lumira as from any other data source to create visualizations:<\/p>\n

\"lumira<\/p>\n

And Infographics:<\/p>\n

\"lumira<\/a><\/p>\n

To stop the database on the Raspberry Pi you can use:
\n
\ndbstop -c \u201cServer=mydemo;UID=DBA;PWD=sql\"<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

Accessing data on the Raspberry Pi with Sybase SQL Anywhere and SAP Lumira<\/p>\n","protected":false},"author":2,"featured_media":12834,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[10],"tags":[706,867,911,936,1010,1011,1012],"class_list":["post-12432","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-products","tag-lumira","tag-raspberry-pi","tag-sap","tag-saplumira","tag-sql","tag-sql-anywhere","tag-sqlanywhere"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2014\/09\/lumira-pi-banner-608x353-2.jpg?fit=608%2C353&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3X9RF-3ew","_links":{"self":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/comments?post=12432"}],"version-history":[{"count":0,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12432\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media\/12834"}],"wp:attachment":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media?parent=12432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/categories?post=12432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/tags?post=12432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}