Page Comparison

...

...

Setting up an RDBMS

Follow the steps given below to set up a MySQL database for this tutorial.

1. Install the MySQL server and the MySQL client.

2. Create a MySQL database with the following table:
   

   Code Block
   CREATE TABLE ACCOUNT(AccountID int NOT NULL,Branch varchar(255) NOT NULL, AccountNumber varchar(255),AccountType ENUM('CURRENT', 'SAVINGS') NOT NULL, Balance FLOAT,ModifiedDate DATE,PRIMARY KEY (AccountID));

3. Enter the following data into the table:
   

   Code Block
   INSERT INTO ACCOUNT VALUES (1,"AOB","A00012","CURRENT",231221,'2014-12-02');

...

Expose the RDBMS as an OData service

Follow the steps given below.

1. Log in to the management console and select Create under Data Service menu.

2. Create a data service to expose the MySQL database you created above.

3. When you connect the datasource, select the OData check box as shown below.
   

4. Click Finish to save the data service.

5. Go to the Deployed Services screen and click the data service that you created. The endpoints for accessing data in the datasource will be shown as follows: