SMP 3.0 : Integration Gateway with MySQL Datasource (Part 1)
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.
Let us start it.
|PART 1||PART 2||PART 3||PART 4
Installation of MySQL server
- If you don’t have a running MySQL Installer then you can download it from below link. It is for free.
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 8)
- 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