Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Values for Property('ServerEdition') include 'OEM' and 'Authenticated'. What is the difference between these two?



asked 07 Mar '13, 17:22

Leo%20Tohill's gravatar image

Leo Tohill
accept rate: 0%

edited 15 Mar '13, 22:13

Mark%20Culp's gravatar image

Mark Culp

I'd second that implicit suggestion and Breck's more verbose one from a comment on that similar question on the "ServerEdition" property cited below that these properties should be documented better...

I vote for the string as now defined... as long as the values remain single words, and as long as the values are fully documented in the Help. Right now I'm not sure if all the values are LISTED let alone described individually... the single-Help-topic-for-all-properties is (IMO) an invitation to write sparse descriptions (but that's a separate rant :)

(08 Mar '13, 12:58) Volker Barth

Both editions are used with authenticated SQL Anywhere applications, as defined here:

The 'Authenticated' edition is used when the authenticated application needs to pass the correct authentication string to the database in order of perform write operations. If the app does not do that, then the connection to the db is read-only. You obtain the authentication string by completing a form on our web site.

The 'OEM' edition is used when your application cannot pass an authentication string to the database, but requires write access. In this case, the connection has R/W permission and there's no need to pass an authentication string.

Which edition you are allowed to deploy depends on your SQL Anywhere contract. From a technical perspective, both editions are identical, with the exception of the authentication mechanism used when a db connection is established.

permanent link

answered 08 Mar '13, 10:04

Jos%C3%A9%20Ramos's gravatar image

José Ramos
accept rate: 30%


Thanks José. But if the 'OEM' edition does not require an authentication string, what's the difference between it and a standard edition (one that is neither oem nor authenticated.)?

(08 Mar '13, 11:53) Leo Tohill
Replies hidden

Like Leo, I don't really get the difference:

  • Does it depend on the database one is connected to (i.e. being an authenticated database or not) whether an OEM edition is described as "Authenticated" or "OEM"?

That would somewhat come as a surprise as the "ServerEdition" property is a database-server property and not a database property...

(08 Mar '13, 12:54) Volker Barth
Replies hidden

The difference has to with your licensing. The OEM Edition allows you to deploy any of the add-ons (as per your contract) and has no CPU limit. Non-OEM Editions (Workgroup, Standard, Advanced) have a CPU limit and have a specific set of add-ons. The following web page lists the differences:

(12 Mar '13, 17:03) José Ramos

'ServerEdition' is a database server property, not a database property, although there are similar properties for both database ('Authenticated') and connection (also 'Authenticated').

(12 Mar '13, 17:07) José Ramos

@José: Yes, we do agree that this is a database-server property.

Still I think Leos (and my) underlying question is still unanswered: What exactly is the difference between an "Authenticated" and an "OEM" edition?

Note, in your other new comments, you only mention the "OEM edition", as is in the linked overview, but do not mention an "Authenticated edition". So I'm still puzzled...

(13 Mar '13, 05:10) Volker Barth

Let me give it a try. The OEM edition is as Jose defined it (licensing based and compared to workgroup, standard and advanced editions). The 'authenticated' edition is a special form of the OEM edition that is tied to a specific oem partner application. With the authenticated edition, connections must 'authenticate' with the server (via specific option settings) before they can get full access to the data in the database. This provides the OEM partner a way to ensure that end users only interact with the database using their application.

(13 Mar '13, 11:25) Jason Hinspe...

So you're saying an OEM edition does not need authentication, i.e. it can technically be used for "normal" databases without database authentication, in write-mode, too?

(Well, then we have an v10 OEM contract but have always used an authenticated edition...)

(13 Mar '13, 11:43) Volker Barth

Yes. A database created for the OEM edition does not have to be authenticated.

(15 Mar '13, 10:09) Jason Hinspe...

OK - I guess I think I finally got the difference:)

Thanks for all the efforts to clarify!

(15 Mar '13, 13:10) Volker Barth
showing 2 of 9 show all flat view

OEM edition: This is actually something a Partner needs to discuss with their Sales Representative since the details may vary and has more to do with contractual terms than software technology. But, for what it is worth, my understanding is this.

There are many possible ways to embed the SQL Anywhere software so that it can only be used with the Var/OEM/Partner's application(s). Anyone can chose to do this for any one of many possible reasons but my understanding is something like this would be required of the OEM Edition sales agreement. In contrast the Authenticated Edition is just the main SW mechanism we provide for this purpose.

At least that is the outline as I understand it. Your sales representative can explain the finer details.


permanent link

answered 11 Mar '13, 15:01

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%

I'm guessing Intuit has a unique OEM agreement, not a simple Authenticated copy.

(11 Mar '13, 17:32) Breck Carter

In contrast the Authenticated Edition is just the main SW mechanism we provide for this purpose.

@Nick: Your reasoning seems sound, however, it does not really declare why the software itself would make a difference here - and that's what we still would like to know...

FWIW, we have just older OEM editions (v8, v10) that do not support the ServerEdition() property, so I can't tell what they "call themselves":)

(12 Mar '13, 05:03) Volker Barth
Replies hidden

SQL Anywhere 11.0.0 and earlier had no concept of editions. That was introduced in version 11.0.1 ( so we provided the property to determine what edition the db server was. Also, SA 11.0.1 was the first one to introduce the Authenticated and OEM editions.

(12 Mar '13, 17:11) José Ramos
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 07 Mar '13, 17:22

question was seen: 5,743 times

last updated: 15 Mar '13, 22:13