Page Comparison

In this tutorial, we will run through the process of exposing and RDBMS as an OData service. When OData is enabled for a datasource, you do not need to manually define CRUD operations. They are automatically created.

...

1. Download the product installer from here, and run the installer.
   

   Insert excerpt
   EI6xx:Installing the ProductEI6xx: Installing the Product nopanel true

   
   
2. Install the MySQL server.
3. Download the JDBC driver for MySQL from here and copy it to your <EI_HOME>/lib directory.
   

4. Create a MySQL database named CompanyAccounts.
   

   Code Block
   CREATE DATABASE CompanyAccounts;

5. Create a table in the CompanyAccounts database as follows.

   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));

6. Enter the following data into the table:
   

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

...

1. Start the WSO2 ESB profile.

   Panel
   borderColor #542989 bgColor #ffffff borderWidth 1
   Localtabgroup Localtab active true title On MacOS/Linux/CentOS Go to <EI_HOME>/bin and open a terminal and execute the following command: Code Block ./integrator.sh Localtab title On Windows Go to Start Menu -> Programs -> WSO2 -> Enterprise Integrator 6.4.0 Integrator. This will open a terminal and start the ESB profile.

2. Open the ESB profile's Management Console using https://localhost:9443/carbon, and log in using admin as the username and the password.

3. Click Create under Data Service.

4. Enter ExposeMySQLDatabaseService as the name of the data service, and click Next.

5. Click Add New Datasource and enter details for the new datasource as follows.
   

   Datasource ID	Datasource
   Datasource Type	RDBMS
   Datasource Type (Default/External)	Leave Default selected.
   Database Engine	MySQL
   Driver Class	com.mysql.jdbc.Driver
   URL	jdbc:mysql://localhost:3306/Company
   User Name	Enter your MySQL server's username. Example: root
   Password	Enter your MySQL server's password.  If you have not assigned a password, keep this field empty.
   Enable OData	Select this check box.

6. Click Finish to save the data service.

7. Go to the Deployed Services screen and click the data service that you created.