Skip to Content
Author's profile photo Former Member

Northwind sample database migrated to SA16 and OData

The Northwind sample database from Microsoft has become an industry-recognized use case, and there are hundreds of sample apps that have been designed against this particular model.

I’ve migrated that sample schema to SQL Anywhere 16, complete with sample data.

The attached linked .ZIP file download contains the following:

  • The Northwind.DB and .LOG file.  These are the SA16 versions of the Northwind database.
  • start_server.bat and sqlanyenv.bat.  These .bat files launch the SA16 database server with the Northwind database, and also launch the new SA16 OData server.  Once started, the Northwind tables can be access via HTTP port 8090 with the service URL: http://localhost:8090/odata
  • Northwind.properties and Northwind.osdl.  These files are used by the SA16 OData Producer to start the OData server and validate the model.

SA16 Northwind OData sample DB

To read more about the OData Producer that’s been added to SA16, you can find out more here.

-Paul Horan-

SAP Global Presales Enablement Lead for Mobility

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Thomas Duemesnil
      Thomas Duemesnil

      Dear Paul.

      Great that you provide some Samples to test oData. But I'm unable to find the attached file.

      Probably give me a hint where I can download the ZIP File.

      my current URL for you post is Northwind sample database migrated to SA16 and OData

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Yes, thanks Thomas...  Apparently, the location where that .ZIP file had been stored has been taken down.

      I've uploaded the .ZIP file to a share on Google Drive.

      Author's profile photo Former Member
      Former Member

      Thomas:  Also review the following sites:

      SQL Anywhere 16 OData Support:

      http://dcx.sybase.com/index.html#sa160/en/dbprogramming/pg-odata.html

      SQLA and OData Overview and example code (pg 30)

      http://download.sybase.com/presentation/TW2011/DATSQL12_SQLAnywhereOData.pdf

      Author's profile photo Thomas Duemesnil
      Thomas Duemesnil

      Thanks.

      Author's profile photo Former Member
      Former Member

      Hi Paul

      Do you have the demo updated to SQLA 17 ?

      Thanks