Objective: This blog series with give you a detailed understanding on how to setup MySQL database, create one sample table, creating and deploying OData model to SMP 3.0 server, CRUD operation with OData service document and troubleshooting.


Software
Used


  • MySQL Community Server 5.6.19
  • Eclipse Junos 64 bit with “Toolkit for Integration Gateway (GWPA)” plugin added
  • SAP Mobile Platform 3.0 SP03
  • Chrome Browser, Advanced REST Client

Let us start it.

PART 1 PART 2 PART 3 PART 4

Installation of MySQL server

  1. If you don’t have a running MySQL Installer then you can download it from below link. It is for free.

          http://dev.mysql.com/downloads/windows/installer/5.6.html

          /wp-content/uploads/2014/07/1_491215.png

2. Once download completes, run the installer, select option as required.

          /wp-content/uploads/2014/07/2_491225.png

ℹ Since there was no MySQL binaries installed previously so i selected “Add/Modify Products and Features

3.  Accept the license terms, and click on “Next

          /wp-content/uploads/2014/07/3_491226.png

4. Make sure you have checked MySQL Server 5.6, Applications, MySQL Connectors, Click ‘Next

          /wp-content/uploads/2014/07/4_491227.png

5. Make sure all the requirements have made.

          /wp-content/uploads/2014/07/5_491228.png

6. Click ‘Execute‘ to install/update the listed products/packages

          /wp-content/uploads/2014/07/6_491229.png

7. On the Configuration step, you can change the port value. By default it is 3306

          /wp-content/uploads/2014/07/7_491230.png

8. MySQL Admin is ‘root‘. Set a strong password for MySQL Root.

          /wp-content/uploads/2014/07/8_491231.png

10. You may change the Windows service name as per your convenience. By default it is MySQL56

          /wp-content/uploads/2014/07/9_491232.png

Make sure “Start the MySQL server at System Startup” is checked

10. You must see a message “Configuration and Installation complete”.

     /wp-content/uploads/2014/07/10_491233.png

ℹ You can verify if MySQL56 service is up and running. Go to services.msc (Windows+R)

     11.PNG

Creating a sample database table

11. Launch MySQL workbench>Click on ‘+’ icon

  • Give some Connection Name
  • Type the password (Should be the same as per step 8)
  • Click on ‘Test Connection

         /wp-content/uploads/2014/07/12_491235.png

12. Right Click > Open Connections

               /wp-content/uploads/2014/07/13_491237.png

13. You must see MySQL Workbench as per below screenshot:

    • There are some pre-existing Schemas as well. If wish, you can create a new one and Click on ‘Apply‘.
    • This Workbench will give a guide for Server management, server logs, performance also.
    • You may verify if Server is up and running.

          /wp-content/uploads/2014/07/14_491295.png

14. Since i have created a new Schema, then i have to add a table to it.

    • Right click jk_schema>Tables
    • Give some table name, add parameters
    • Make sure there is one primary key among all columns
    • Click on ‘Apply’

          /wp-content/uploads/2014/07/1_491215.png

15. Below confirmation, you have to review the SQL script to be applied on the Database.

               /wp-content/uploads/2014/07/1_491215.png

16. Now, it’s time for adding some values to this table.

  • Right click Schemas>employee (On left hand side below)> Select Rows-Limits 1000
  • Automatically it will run SELECT query of this table. i.e. SELECT * FROM schema_name.table_name (SELECT * FROM jk_schema.employee;)
  • Add columns value and click on ‘Apply‘.

17. You can verify the inserted columns details again by running SELECT query.

          /wp-content/uploads/2014/07/1_491215.png

Next Part 2

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply