Together Forever: Retail and Technology Walk Down The Endless Aisle

My daughter Kyra discovered Ted Baker when she was working in London. “The first items I ever bought were a mint green T shirt with a white bow and a cosmetic bag with the French bulldog signature bow,” she says. “And I love how Ted delivers. My cashmere sweater arrived in a beautiful green box in a nest of colored tissue paper.”

Ted sure knows how to delight and deliver. Shops used to be the only point of sale, but with the opportunity to add digital channels, Ted can deliver even better.

Ted ticks all the boxes when it comes to the top trends in fashion retail. The company is thriving because it produces quintessential quality fashion in a sustainable way. The company  deftly “retailtains” its customers by giving them a unique, personalized experience in the store, and at the same time, making shopping so convenient there is no excuse not to indulge.

“Customers don’t have time to wander around endless aisles in large stores. If people can easily shop online and have things delivered at home within hours, you need something really enticing to get them into the physical store,” says Maria Morais, who helped Salmon implement the entire SAP Hybris solution back in 2013 when Ted Baker started its successful digital transformation journey.

“Small specialized stores are perfect for the urban environment,” she goes on to explain. “Although there is no space to stock a large selection of items, technology enables the customer to virtually browse ‘endless aisles’ of goods in the store and have their purchases delivered at home, at work or via click-and-collect at other stores.”

Salmon helps retailers like Ted implement end to end solutions that drive and support ongoing expansion into new markets, helping them gear up for future growth. Most recently they helped Ted introduce a slick payment app using PayPal technology which is used on the employee’s tablet in the store to help the customer securely order and pay for any item in the entire product range, whether it is in stock or not.

 New opportunities for a balanced approach

Ted’s story is just one example of how technology and retail are joined at the hip as they cater to customer demand for convenience. While current trends present enormous challenges to retailers operating out of large stores, they also open a world of opportunity for start ups and entrepreneurs.

“For many retailers, the store is a big black box,” says Guillaume Waline who co-founded Indigo-Media, a futurist shopping solution, with Laurent Meoni in 2015. “There is a lot of information in that box, but they can’t see it, and don’t understand its potential impact on sales. Many players in the retail service industry have come up with solutions to help retailers access data, but there is still a lot of room for improvement in terms of a complete merchandising dashboard.”

Indigo’s solution enables brands and retailers to set up ‘responsive shops’ that collect data to interpret the customer’s behavior in the store as they enjoy interactive shopping experiences.

“Retailers should not sit around waiting,” warns Guillaume. “Those who don’t deliver enhanced in-store experiences and who don’t respond to product performance data during the purchasing situation won’t thrive in the new commercial environment. They’ll have alienated the modern customer and their competitors will outperform them. We can help them transform their stores into smart spaces for a modern society.”

Plenty of space for start ups

Guillaume and Laurent know the current customer in-store experience is not interactive enough. “People still feel lost in the store. If they can’t find products or information, they get frustrated and walk away,” says Guillaume.

Indigo provide brands and retailers with a big data platform, running on SAP HANA with powerful analytical tools, that enables real time merchandising based on data collected through invisible units in the store. “We saw a business opportunity when we realized that retail is an open market for big data. Early on, we applied to the SAP Startup Focus Program,” he adds.

SAP Startup Focus is an accelerator program that works with startups in the big data, predictive and real-time analytics space (machine learning, AI, data security, IoT, mobile, AR/VR), to develop new applications on SAP technology and accelerate market traction.

“The program has been enormously helpful in terms of business development, helping us scale and build a base of new clients. We got to work with leaders in the data market, giving us a cutting edge position and accelerating our go-to market.”

Innovative tools, bright minds and startup programs are all helping retailers like Ted delight customers. “My face lights up when I see a Ted Baker shop,” says my daughter Kyra. And I must say, that ankle length, high neck, floral gown she wore to the registry office for her civil wedding really was stunning.

Follow me on Twitter @magyarj

  http://bit.ly/2oS6FSO #SAP #SAPCloud #AI

Database Administration Using the DBA Cockpit: News

As you might know, the DBA Cockpit is a database monitoring and administration tool for SAP systems. I would like to share a few news with you about it:

DBA Cockpit Documentation Now Public

So far, the documentation for the DBA Cockpit was available on SAP Service Marketplace, which was open to SAP customers and partners, but required a login with user name and password. You might be pleased to hear that this has changed. The documentation is now public on SAP Help Portal, no login is required anymore:

http://help.sap.com/viewer/db6_dbacockpit

Network Statistics

Some of you might have already noticed the latest enhancement, which has been available for quite a while now: a new monitoring screen for network statistics. If you haven’t seen it yet, watch our three-minute video to get an idea:

DBA Cockpit: Network Statistics (3:25 min.)

Outlook into the Future: The Technical Monitoring Cockpit

If you have used the DBA Cockpit for monitoring SAP systems on IBM Db2 for Linux, UNIX, and Windows, watch out for a new tool that might replace the DBA Cockpit in the future – the technical monitoring cockpit. In comparison to the DBA Cockpit, the technical monitoring cockpit has the following advantages:

* The technical monitoring cockpit provides a unified user interface for monitoring the operating system, the database, and the application server of your SAP system.
* There’s also no need to wait for the next support package. We provide content update, that is, you can download updates from SAP Support Portal and upload the updates to your system – no need for an upgrade.

The technical monitoring cockpit comes with a SAP UI5 user interface and the possibility to switch to SAP’s older UI technology, SAP GUI, if you prefer this.

The technical monitoring cockpit is already available, but bear in mind that you probably won’t find all the features that you know and like from the DBA Cockpit yet – but we are working on more. By the way, the network statistics are already available in the technical monitoring cockpit.

Have a look at our video to get a first impression:

Technical Monitoring Cockpit: Introduction (3:23 min.)

You’re interested in more details? Here’s our full documentation and the release note:

Documentation

Release Note http://bit.ly/2oOOE7N #SAP #SAPCloud #AI

The new ArcGIS Enterprise Geodatabase for HANA – First Impressions

Early next year, Esri will release a version of the Enterprise Geodatabase that supports SAP HANA.  You’ll need ArcGIS Pro 2.1 and ArcGIS Enterprise 10.6.  You will also need HANA 2.0 SP2 or greater. If you’re interested in signing up for the early adopter program, please visit this website.

I’ve been putting ArcGIS Pro 2.1 and ArcGIS Enterprise 10.6 through its paces for the last 2 or 3 weeks and am happy to say that I was able to create an Enterprise Geodatabase in HANA and load some of the utility model sample datasets.  As you’d expect with any early release, there are a few bumps, but with the help of the early adopter forums and a few helpful tips, I was able to easily navigate them.

In this blog, I’ll look at what it takes to create an enterprise geodatabase for HANA, enable it and copy some feature classes from another enterprise geodatabase into the HANA one.  I’ll discuss the creation and loading of utility models in another post.

As many of you know, the ArcGIS platform has been able to access tables in HANA using query layers since ArcGIS Server and Desktop – 10.3 and Pro 1.2 was released in 2014.  This enabled spatial data in HANA to be consumed and updated by the ArcGIS platform.  As of ArcGIS Server 10.3.1, feature services against HANA were supported.  This is commonly known as an agile spatial datamart or “sidecar” scenario.  There are other blogs that describe the possibilities created by query layer support – here (page is in Dutch, but Google Translate handles the translation to English easily), here and here.  Have other questions on ArcGIS/HANA integration? See this blog.

The second scenario is creating an enterprise geodatabase in HANA.  Esri is referring to this scenario as Esri ArcGIS on HANA. This site explains both of these scenarios.

The first release of the enterprise geodatabase for HANA will support the following:

* subtypes/domains
* relationship classes
* attachments
* editor tracking
* non-versioned archiving
* offline editing with sync capabilities
* new service based long transaction model for editing
* utility network

Other networks (including the current utility network) won’t be supported in the first release.  See this link and this link for more information on the new enterprise geodatabase for HANA.

Assuming you have installed or have access to ArcGIS Enterprise 10.6 and Pro 2.1, the steps for creating an enterprise geodatabase are:

* Install and configure the SAP HANA 64 bit ODBC drivers (part of the SAP HANA Client) on both the Enterprise and Pro instances.  See this blog for more details.  Use the same connection name on the Enterprise instance.  Record the name of your ODBC connection for later (step 6)
* Using the HANA Cockpit or HANA Studio, create an SDE user in your HANA instance.  The SDE user will need CATALOG READ permissions.  If you don’t have USER ADMIN privs, get the HANA DBA to create the SDE user for you.
* Test your ODBC connection using the SDE user from both the Pro and Enterprise instances
* Start ArcGIS Pro and create a new project

* Right click the Databases group in the Catalog pane on the right and select New Database Connection

* The following dialog will appear.  First, select SAP HANA as the Database Platform.  Then use the ODBC connection name you recorded earlier (when you later register the enterprise geodatabase with ArcGIS Enterprise, you’ll use the same ODBC data source name).  Specify the password for the SDE user.
* If you’ve correctly done the proceeding steps, you should now have a connection to the SDE database in HANA.  In HANA, each user has its own schema.
* Now, you’ve reached the cool part – actually enabling a HANA database to be an enterprise geodatabase.  Note that the enterprise geodatabase must be owned by the SDE user.  You’ll need a keycode file from your Enterprise instance that authorizes you to enable HANA as an enterprise geodatabase.  It is typically located as shown below on your Enterprise instance C:Program Files (x86)ESRILicense10.6sysgen​

* Copy the keycode file over to your Pro instance.  You’ll provide the keycode file path in the Authorization File field and the specify the database connection you created in Step 7 above.  Click run and in about 5 seconds, you’ve successfully enabled a HANA enterprise geodatabase.

* Now, I’ll copy some feature classes from another enterprise geodatabase using the Import geoprocessing tool.  You’ll first need to create a database connection to that database like what was done in Steps 5 and 6.  You’ll specify the database connection to the other enterprise geodatabase, the feature class(es) you want to import and the target (the HANA enterprise geodatabase or a dataset inside it).  Click Run and in a few minutes, you’ve easily copied feature classes into your new HANA enterprise geodatabase.   Of course, the more feature classes you copy, the longer the Import will take…

So that’s it… assuming you’ve installed ArcGIS Enterprise 10.6 and Pro 2.1 and installed the ODBC 64 bit drivers, the rest of the steps I did above took about 10 minutes.  Once you’ve enabled the geodatabase (Step 9), you can easily copy additional feature classes or datasets (a dataset is simply a group of feature classes – you can create one with the Create Dataset geoprocessing tool in less than a minute.  Learn more here).

I went on to create and share a webmap to ArcGIS Enterprise.  I navigated to Portal and simply right clicked and selected Add and Open as shown here:

…and the following map was created in ArcGIS Pro.

The above map uses map services served up by the ArcGIS Enterprise instance – which is obtaining the geometries from the HANA enterprise geodatabase.  Just to make sure, I logged into the ArcGIS Server Manager on the ArcGIS Enterprise instance and looked at the feature layer used by the above map:

From here, there’s a lot you can do – you can author maps and utilize the advanced ArcGIS enterprise geodatabase features – and do all of that against an enterprise geodatabase in HANA…starting early next year.  All-in-all, a great reason for 2018 to hurry up and arrive! http://bit.ly/2oNPPnP #SAP #SAPCloud #AI