Open it, connect to the running equidb and execute the following:Īfter creating the table, we will insert some data: You can create it via Interactive SQL (ISQL), a tool that is part of the SQL Anywhere installation. In this example we will have just one table. Scroll all the way down and select "VERIFY ODATA".Right click and select new - Granted System Privileges.The next thing we need to do is to give the user, who will access the OData service, the right privileges. Now connect to it via SQL Central (SQL Anywhere - Connect to database). Once the database is created, you can start it with this command: Here is the SQL statement and the command line:ĬREATE DATABASE 'C:\blog\equidb.db' LOG ON 'equidb.log' CASE RESPECT COLLATION 'UTF8BIN' NCHAR COLLATION 'UTF8BIN' DBA USER 'dba' DBA PASSWORD 'sql' MINIMUM PASSWORD LENGTH 3 ĭbinit -c -z "UTF8BIN" -zn "UTF8BIN" -dba "dba","sql" -mpl 3 -t "equidb.log" "C:\blog\equidb.db" I will spare you the screenshots of the SQL Central Wizard - to start it, open SQL Central, go to SQL Anywhere 17 - Tools - Create database. Please note that the local Web IDE is just a trial and not ment for productive use.Īfter installation, we first need to create a database. Please refer to the installation guide that is provided on the trial download page. For the Web IDE it is a bit more complex. The installation of SQL Anywhere 17 is straightforward. This blog will show how to enable the SQL Anywhere database to become an OData provider and how to consume this service from a locally installed WebIDE.įirst you will need to install SQL Anywhere and the local Web IDE. Therefore it is no surprise that SAP enabled their SQL Anywhere database to speak OData as well. Next to SAP's new flagship HANA we are talking about OData and SAP UI5. There are a number of technologies that are becoming more and more important in the SAP world.
0 Comments
Leave a Reply. |