Hello,

right now, we cannot connect MobiLink to a MS Azure database. mlsrv17 seems to believe it is connecting to a standard MS SQL Server database and tries to retrieve information from system views like dm_os_cluster_nodes which are not present in an Azure database. I know Azure is not on the list of supported consolidated databases but I wonder if someone got it running or wether development has plans to support it?

TIA,

Michael

asked 10 Jul '16, 12:01

Michael%20Fischer's gravatar image

Michael Fischer
630101527
accept rate: 12%

FWIW the "traditional" way to implement a consolidated database running on non-supported software is to use a SQL Anywhere "stand-in" consolidated database with schema that matches the Azure database and ODBC proxy tables (remote server feature of SQL Anywhere) to pass on the insert, update, delete and select statements received from the MobiLink server event scripts.

IMO is far far far far far more likely that the current proxy table middleware will work as-is between SQL Anywhere and Azure, than a MobiLink ODBC driver for Azure will ever be implemented. Consider this: SAP removed the MobiLink driver for HANA from SQL Anywhere 17 altogether, preferring to move (some of) the functionality over to HANA itself... how likely do you think it will be that SAP will implement a MobiLink interface to a competitor's cloud product?

Gosh, lemme think :)...

(10 Jul '16, 13:07) Breck Carter
Replies hidden
2

Breck,

This happens very rarely but this time I disagree with you.

If you were right, Sybase would have never supported consolidated databases other than ASE and SQLA. But they did, from the start. For good reasons. The ML approach of using ODBC to access the consolidated and support various products accepts the fact that there are competitors out there and that customers may already use a particular db product for years and NOW look for a sync solution with notebooks or other mobile devices. Why would SAP skip the opportunity to sell hundreds our thousands of SQLA or UltraLite licences in projects they would never ever get if they really tried to force an existing MS happy camper to switch to HANA - something that is very unlikey and sales suicide.

It has always been ML product policy to embrace existing consolidated environments and use ML to sell SQLA and UltraLite licences. Anything else would be a bad idea.

Kind regards, Michael

(11 Jul '16, 05:37) Michael Fischer

Given the fact that ML usually supports the "newer" versions of consolidated databases(say, v17 support MS SQL Server 2014 and ASE 16.0) and relies on the pecularities of those databases much more than the according remote data access layer (*), and given the chance that an Azure database is just partially different from an on-premise MS SQL Server database (note: I don't know the differences), I could imagine that the MS SQL ML support could add some kind of option/switch to handle both...

@Michael: Is there a chance to add the missing system views as user views to make ML think it's connected as usual?

(*) - Compare Russ's statement here.


IMVHO, the change from v16's "ML to HANA" to v17's "SAP HANA remote data sync" is primarily a result of the HANA-centric SAP product marketing. I do not think that this is a clue for the further development of ML and different vendors...

(11 Jul '16, 06:32) Volker Barth
Replies hidden
1

Breck - Like Michael, I disagree with you rarely but I do about this: "SAP removed the MobiLink driver for HANA from SQL Anywhere 17 altogether, preferring to move (some of) the functionality over to HANA itself..."

Moving MobiLink into the HANA platform provides HANA users with common lifecycle management (install, upgrade etc), a standardised configuration (MobiLink user name and schema), and monitoring. So we think it's a step forward for HANA customers compared to running MobiLink the way it runs in the SQL Anywhere product (separately installed, configured, managed).

Once it is there in HANA Platform, keeping the MobiLink server connectivity for HANA in SQLA created a lot of questions about supported versions etc.

(11 Jul '16, 10:45) Tom Slee
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed

I am confused.

Are you saying SAP did not remove the MobiLink driver for HANA from SQL Anywhere 17?

Are you saying SAP did not prefer to move the functionality over to HANA?

Are you saying SAP will be supporting Azure?

(15 Jul '16, 14:46) Breck Carter

That's great! ...SAP will be supporting Azure with its own MobiLink driver!

...that's what you're saying, right? :)

(15 Jul '16, 14:47) Breck Carter

> I do not think that this is a clue for the further development of ML and different vendors...

So, you think "SAP HANA remote data sync" is going to work with Azure?

Seriously, "HANA-centric SAP product marketing" is itself huge clue that neither MobiLink nor any other SAP product line is going to bring support for Azure to market.

Maybe someone (Michael? Tom?) will tell me where I'm wrong... I know it's impolite to bring the subject up, but that's not the point.

(15 Jul '16, 15:04) Breck Carter

So, you think "SAP HANA remote data sync" is going to work with Azure?

I'm sure you do not think that I was saying or thinking that...)

I'm trying to make the point that "ML to HANA" is in a particular marketing situation where it seems fitting for SAP to put the ML support into the HANA system instead of leaving it at the SA side.

And I'm expecting that support for ML to other databases will develop as before, i.e. as part of the SA suite.

I do not make assumptions whether there will be a separate ML driver for Azure. But I could imagine that it would be technically feasible to enhance the MS SQL Server driver to support Azure, too, but as stated, I do not know the (subtle or not) differences between SQL Server and Azure Databases.

(15 Jul '16, 15:56) Volker Barth

There have been no new non-SAP consolidated databases added to MobiLink since MySQL in SQL Anywhere 11, so tell me again how eager SAP is to support other people's software?

From the various Help files...

10
SQL Anywhere consolidated database
Sybase Adaptive Server Enterprise consolidated database
Oracle consolidated database
IBM DB2 UDB consolidated database
Microsoft SQL Server consolidated database

11
Adaptive Server Enterprise consolidated database
IBM DB2 LUW consolidated database
IBM DB2 mainframe consolidated database
Microsoft SQL Server consolidated database
MySQL consolidated database
Oracle consolidated database
SQL Anywhere consolidated database

12
Adaptive Server Enterprise (no 64-bit Linux support provided) 
IBM DB2 LUW 
Microsoft SQL Server 
MySQL 
Oracle 
SQL Anywhere 
Sybase IQ (not supported by QAnywhere) 

16
Adaptive Server Enterprise (no 64-bit Linux support provided) 
IBM DB2 LUW 
Microsoft SQL Server 
MySQL 
Oracle 
SAP HANA 
SAP Sybase IQ 
SQL Anywhere 

17
Adaptive Server Enterprise 
IBM DB2 LUW 
Microsoft SQL Server 
MySQL 
Oracle 
SAP IQ 
(15 Jul '16, 18:20) Breck Carter

Breck, I do not claim that SAP has added new (non-SAP) consolidated databases to MobiLink in the last releases.

However, they seem to support newer versions (and newer ODBC drivers) of the already supported DBMSs, and that's what I was thinking of:

AFAIK, the MS SQL Server driver used with ML v17 is also able to connect to SQL Azure databases, too, and therefore Azure support may not mean a different consolidated database but just a flavour of an existing one.

Besides that, as I'm not using Azure, I leave further thoughts and comments to SAP:)

(18 Jul '16, 05:31) Volker Barth
showing 2 of 10 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×295

question asked: 10 Jul '16, 12:01

question was seen: 370 times

last updated: 18 Jul '16, 08:24