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
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
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.
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
Thanks.
Hi Paul
Do you have the demo updated to SQLA 17 ?
Thanks