Category: Enterprise Mobility

Open Source Project: XSImport – a HANA app for importing CSV’s

paschmann
XSImport.jpg

During a recent small migration project from a HCP MaxDB DB to a HCP HANA DB I needed to import multiple CSV files, and go through a series of dry runs during the process. Since I was going to be doing the loads multiple times, I decided it would be helpful to write a small front end to make the processes of uploading failrly large CSV files into HANA simpler.

Over the past few months I have heard the question: “Whats the best way to get data into HANA from CSV?” While there are a few options if you have a HANA appliance and system level access to the system, there are not too many options with a HCP instance. After trying/testing the CSV import from Studio (size limit), a hdbti file (not great for multiple/repetitive options/file size challenges) it does not leave you with too many choices. After doing some digging it seems quite a few people have uploaded data through a server side script (XSJS) successfully and using the BATCH option while processing is pretty fast. read more

Open Source Project: Syscompare

paschmann
/wp-content/uploads/2015/06/compare_icon_726708.png

A couple of weeks ago I was moving code from 1 hana instance to another trying to keep them in sync. However, I thought there might be a better alternative for comparing the contents of the repos across my systems to ensure that the files matched. After doing some digging and not finding a solution, I decided to write a small tool to do just this, called Syscompare. It is a open source HANA app which uses the new File API and compares the files on each system and displays the differences.

You can read more about the application here, and find the files for the HANA app in Github.

Features:

– Compare repos across HANA instances

– Display file differences in the application read more

SAP Netweaver Gateway – A product powering innovation at SAP

paschmann

While SAP Netweaver Gateway is a product not often discussed at keynotes, events and in the media, it is a integral part of the innovative products being launched at SAP and is core component of SAP Fiori. If you are interested in taking advantage of some of the new free Fiori applications to drive value with your ERP investment, understanding SAP Netweaver Gateway is not optional, but rather a requirement.

In a summary, Netweaver Gateway is a ABAP developed add-on powering applications like SAP Fiori, SAP Mobility Platform (SMP), and even Duet Enterprise. This small, but very important component gives your company the ability to turn your monolithic, big and heavy backend systems into lightweight, simple, consumable web services. read more

2013 SAP Demo Jam Prep

paschmann

Preparing for SAP Demo Jam at TechEd in Las Vegas was a huge undertaking, I completely underestimated the time and commitment it takes to prep a simple 5 minute demo on the stage in front of 5,000 people. Attached are my notes and details of some of the script around the project and what I was using as a guide.

The store pills should be bigger and center of the screen for everyone to see?

Tell people what you are clicking on?

– Metric squared Twitter Widget: 385571773112012800

Notes

– In Demo – if System crashes … say that I have little kids, any time this happens, mention that it is HANA having a tantrum.

– In Demo – if does not do something … say HANA is a little like my daughter – she doesn’t always listen 😉 read more

Simple Sample: Writing an entry to SAP Netweaver Gateway using JSON

paschmann

Skill Level: Beginner

Time Needed: 20 minutes

I recently assisted someone on the forums when they were having trouble creating records in their SAP ECC instance while using Gateway. I thought I would share some very simple code showing what it takes to write an entry into a service via JSON from iOS (Objective C). The reason the title of the document is “Simple Sample” – there are no frills. Whenever I develop a new app, I start small, get the basic functionality working, and proof out the process before getting too creative.

*** If you do not have your own gateway server, you might be able to connect this to the SAP Gateway System which can be found here. Create an account and utilize this service *** DISCLAIMER: Untested as the signup form does not work 🙁  read more

zSCN – A iPad SCN Community Reader

paschmann

After spending a couple of months traveling in 2012, I wrote a personal app for reading and following content created on the SAP Community Network. Although it was slightly buggy and ghetto, I found it way faster than firing up my MBA to check if a comment or something helpful had been posted in my local Netweaver Gateway hangout. I spent the last +- 6 months using the app and after reading a few comments on the new Idea place and in the forums, I decided a couple of others may find it helpful and set out to build a user friendly version. 

Now on to the app …. firstly, starting up the app you are presented with a list of spaces (thanks to Jason Lax for creating a helpful list here!), secondly, the app uses the RSS feeds from each SCN “Space” to curate the content, each time you select a space the content is cached on the device (in a little SQLite DB) and refreshes each time the space is opened. You can also select the number of items which are downloaded in each category (blogs, documents and forums). After logging into SCN using your SCN username/password, it will download your spaces, people and saved content. Keep in mind that you cannot “save” or create content from the app, since the SCN API’s are not currently publicly available (I am hoping for some change on this!). However, each item can be selected and the original content will be displayed on the website where you can login and respond/comment. You can also easily email the item to a friend in need, or tweet it if you are a social butterfly 😉  read more

iOS App: Blaze for SAP Netweaver Gateway

paschmann
72-App-Store-Icon.png

A couple of months ago I was working on creating services for a SAP App store app called Production Insight for SAP. While working on the app I constantly found myself using RESTClient for Firefox to test, debug and view the attributes of my service while I was developing in XCode. Eventually I pulled up the metadata and service implementation on my iPad and used it as a second screen for reference. This made my life much easier. After having done this a couple of times over the past few months, I figured it wouldn’t be a bad idea to create an app which not only lets you view the service and its details, but also save requests, test them against multiple servers and also view the details easily. Which is why I built “Blaze”, it does all this and a little more. It is a free app and available in the app store as of yesterday, if I could put a “demo” or “beta” sticker on it: I would. (but apple won’ approve anything like that!) for all you “gatewayers” out there, please test it out and let me know what you like and don’t. My intention is to create a iOS client for gateway which is useful to developers like myself. The app can also handle other OData servers and services like Netflix and XS Engine from HANA. read more

S2F – Building a custom iPad app using Netweaver Gateway

paschmann

S2F is a blog series around building custom native iOS apps using SAP Netweaver Gateway, you can read Part 1and Part 2, as well as the introduction from talk at TechEd in Las Vegas.

Last Week Guy Stoffer, put together a great blog outlining how quick and easy it was to create an iOS app using the SAP Netweaver Gateway Tool for XCode. The tool creates proxy classes and even handles the security which makes creating a starter gateway app simple. In my previous post covering my talk at TechEd in LV, I mentioned I would show an alternative to using the Gateway Tool for XCode and this blog outlines this. read more