Archive by Author | ccmehil

eGeeks Down Under



We were recently at the Mastering SAP Technology Event in Melbourne and decided it was high time we did another podcast!

Season 5
Episode 3

Tom and Rich at Mastering SAP Technology

Tom and Rich at Mastering SAP Technology

Join us as we cover a broad range of topics from Pachinko to Tech, personality tests and of course HANA and our world travels.


Recently as I’ve dug more and more into HANA (how could I not with Tom and Rich publishing so many cool things?) I found that I could take many of my existing demos from PHP and MySQL and port them to HANA. The pain though has always been migrating DB content so I decided to make a simple little tool to make life easier.

It was during the SAP InnoJam event in Madrid that I sat down and coded something that I was able to test with Rich’s help, HOWEVER this is not something SAP supports or even validates or approves this is just me and my own HANA Cloud instance having some fun and deciding to share!

GitHub - Move to HANA

GitHub – Move to HANA

I call it Move to HANA and you can find the code on GitHub. It’s fairly simple and I used JQuery Mobile (don’t hate me SAP UI5 lovers) to put it together, just upload it to your PHP server and run it.

The idea behind it, is to give a simple migration tool that will help generate the HANA specific SQL to get your same tables and fields generated and your data uploaded via the HANA Studio. Right now it’s setup for MySQL but is easily expanded for any DB you are working on; oh and of course it’s not 100% yet it’s only got a handful of the different field types but hey – it’s GitHub go ahead and make some changes!

As for execution – again very simple.

Database selection

Database selection


Once your select your database then you will need to log into the database to select which “database” you want to migrate.

Login into your database

Login into your database


Then select your “database” at which point the script will generate the 3 step process for data migration.

Simple 3 Steps

Simple 3 Steps


Step 1, will provide your the “copy and paste” script you need to enter into your HANA Studio.

HANA SQL to generate SCHEMA

HANA SQL to generate SCHEMA

Step 2, will provide the command line code for MySQL to generate the CSV files you can then upload via the HANA Studio

Command Line for MySQL Dumps

Command Line for MySQL Dumps

Step 3, will provide the SQL command to ensure the proper permissions for the newly generated SCHEMA


SCHEMA permissions

SCHEMA permissions

I’ve used the script a dozen times already to get sample data and other MySQL data moved into HANA to allow myself more and more opportunities to try my hand at HANA coding and it’s worked quite well. If you give a try feedback would be great and if you find new data types or if you want to try a different database than MySQL by all means have at it!!


** SAP does not support nor endorse this tool and there is no support other than the very little free time that I personally have to answer comments. **

Madrid and the Annual eGeeks Dinner!

Well with the Madrid SAP TechEd just around the corner, we’ve finally decided it was time to announce the Annual Enterprise Geeks dinner! However, those who went last year know there were some minor glitches along the way and therefore we’ve been forced to do things slightly differently this year! We still expect it to be awesome so you won’t want to miss out!

The dinner will be 9:30 PM on Tuesday the 13th of November; we’ll meet at 8:30 PM after the Demo Jam event and figure out how best to get to the location.

We’ve a special menu price of 29,00 EURO per person plus tip.

You have to sign up to come, otherwise you are on your own for finding a seat in this place which is usually packed tight! We’ve 35 seats available for us at a group table – so again – SIGN UP (<– LINK TO SIGN UP, SO CLICK IT!)!

We’ve no wiggle room on this so if you don’t sign up we can’t help you 😦


As Sandy approaches…

I’m so used to Florida and the Southern US being a target, heck having lived in Florida for so long Hurricanes were just part of the norm and now as I sit in Germany and hearing about it and the mass of people and the problems with evacuations and the estimated damage reports and such I reached out to my friends here on Enterprise Geeks to make sure they were OK and then I realized that I have a whole heck of a lot of friends up and down the Eastern Seaboard and many of them are in the danger zones right now.

So please be safe everyone!

Here are some links that you should check while you still have power and please continue to do what you can to prepare; I’ve gone days without power and it’s not a fun thing. Oh and if you don’t have a bucket of water handy to flush the toilet then chances are you are forgetting something else as well!

Some solid tips!

  • Stay in Secure Room.
  • Stay away from windows.
  • Do not use the phone, or candles.
  • Monitor Weather and Civil Service Bulletins on either regular or NOAA radio.
  • Have supplies on hand.
  • Remain indoors when the eye moves over your area because the storm will resume shortly.

A new coat of paint, some power washing…

Well we finally decided it was time to throw on a new coat of paint, do some power washing, some scrubbing and some trimming here and there and what you get is the brand new design/layout of the Enterprise Geeks website.

I’d love to have associated this change with a podcast but as you can tell we are all quite overloaded with that crazy thing called “our jobs” at the moment so it looks like the podcast will follow next week at the SAP TechEd Las Vegas event? Are you going? Coming to the dinner as well?

Feedback of course is welcomed so let us know!

Looking for a summer eGeek fix?

If you are looking for a eGeek fix during our “off season” summer months then come by Newtown Square, PA on July 27th. Rich, Tom and I will be doing a SAP event called the SAP CodeJam during the day all about SAP HANA.

Remember Hacker Night? Well, SAP is bringing it back under a new format calledCodeJam. This new concept offers an opportunity for you as a developer to not only get your hands on SAP’s latest technologies but also to put yourself to the test and to code, hack and create with your peers.

SAP CodeJam Newtown Sq will focus on HANA technologies. As a participant, you’ll get access to SAP HANA including tools, sandboxes, experts, and more! In the days prior to the event, you’ll receive an email with a checklist and a couple of links that will help you get prepared. Additional information can be found here.

The event goes up until about 5pm maybe a bit longer and I can’t speak for Rich or Tom but I will be in town a bit longer if anyone wants to grab a drink or bite to eat.

DJ Adams and a trip down technology lane


Craig Cmehil managed to catch a quick chat with DJ Adams recently in Germany and they discussed everything from MAPICS to SAPUI5 to Gateway and how the past is reconnecting the present.

DJ Adams is an enterprise architect and open source programmer, author, and bread-maker living in Manchester. He has a degree in Latin & Greek (Classics) from the University of London, and despite having been referred to as an alpha geek, can nevertheless tie his own shoelaces and drink beer without spilling it.

So many things discussed… WOW! Big thanks to DJ for joining in.

Direct Download Link:

iPad App of the Week: Contract Killer

Yes, he did! That’s right this time around it’s game time!

Contract Killer by Glu, is what I chose this time around! Oh and it’s free, just watch the in game buy options 😦

They might call you an enforcer, or an assassin. Call it what you like – you’re a CONTRACT KILLER.

Pulled into a world of bounty hunters, mobsters and criminals, you must check in with your contacts and accept SECRET MISSIONS that only you can handle. Select your WEAPON OF CHOICE from an inventory of sniper rifles, assault rifles and machine guns. Locate your target, zoom in, take aim and GO FOR THE HEADSHOT to earn cold hard cash. You might eliminate a crime boss and escape without being spotted, or you might walk straight into an AMBUSH…

Prepare for your mission and then jump into one of many vantage points within 5 gritty 3D locations

17 Story Missions and unlimited Random Missions provide cash, XP and lots of action

20 distinct weapons including handguns, sniper rifles, machine guns and assault rifles

Use the Tranquilizer Gun to capture your target or put them down… permanently


iPad App of the Week: SSH Term Pro

Now who can’t need an SSH terminal app on their iPad or iPhone? I went through several before deciding on SSH Term Pro (yep the paid version) for a whole $1.99!

SSH Term Pro is SSH Client application in which you can connect with your server using SSH protocol

-SSH Console/Emulator Terminal
-RSA Keys Manager and share/send public Key(s) via email
-Connect server with SSH protocol
-Support in both mode portrait and landscape mode
-Configure unlimited server with connection name
-Configurable supported all fonts with custom font size
-Configurable Foreground, Background and Cursor Color
-Support most of text editor like nano, vi or vim and others
-Enable/Disable Auto Scroll within terminal screen, no need go in settings screen
-Configurable terminal type as per your server support/requirement
-Configurable rows and cols (terminal size)
-Configurable port like use non-standard port etc 2202 etc
-Support Up/Down arrow keys
-Show/Hide keyboard to entitle full screen, Just double tapping
-Support Top command
-Support Control, Tab and Esc Keys and F1-12 Keys
-Support multitasking
-Configurable fonts with custom font size
-Configurable terminal type, rows and columns your self as per your server requirement.
-Show/Hide Keyboard and display output in full screen
-Support website link working now
-Access to Sudo and root commands
-Application work with GPRS, EDGE, 3G or WIFI Network
-Very Simple UI and no need to read document or user guide to understand application, however we are here for support, follow support link for any help or any question


Next up will be based on a Twitter request for “air control” type apps.

iPad App of the Week: Adobe Ideas

The app I decided to review this week is Adobe Ideas and it’s for both the iPhone as well as the iPad and it’s free.

Adobe® Ideas is your digital sketchbook, letting you capture and explore ideas anywhere you go. Adobe Ideas is an ideal companion for the professional design applications from Adobe, including Adobe Illustrator® and Adobe Photoshop®. Now with a new in-app purchase option, you can get up to 10 drawing layers plus a photo layer for each sketch as well as layer transformations – move, rotate and scale each layer.
Sketch design concepts while sitting in a cafe, capture and store color themes while browsing through the photos on your phone, or jot down notes on a photo. Any time you need to explore creative ideas, Adobe Ideas is there with you.

Here’s a short demo:

Got a cool app you want reviewed or one you really like you want to share – let us know!