Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Jitendra_Kansal
Product and Topic Expert
Product and Topic Expert


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

 



 

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

 



 

 

ℹ 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"

 



 

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

 



 

5. Make sure all the requirements have made.

 



 

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

 



 

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

 



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

 



 

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

 



 

Make sure "Start the MySQL server at System Startup" is checked

 

10. You must see a message "Configuration and Installation complete".

 



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



 

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 😎

  • Click on 'Test Connection'




 

12. Right Click > Open Connections

 



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.




 



 

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'




 



 

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

 



 

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.

 



Next Part 2