欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

程序员文章站 2022-05-27 10:30:59
...
Here we will see how to create a destination in Gateway cockpit and map it manually to deployed OData service and then how to perform CRUD operation on service document.

Test the OData service

  1. Log on to SMP 3.0 Admin: https://smpserver:port/Admin

  2. Create a new security profile with name as ' sap ' (exact name as namespace) under Settings>Security profiles>New

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

3. Log on to SMP3 gateway cockpit https://smpserver:port/gateway/cockpit

4. Go to destinations tab, Create a new destination

Properties Values
Destination Type DATABASE
Destination URL jdbc:mysql://MySQLSeverip/schema_name
Destination Driver com.mysql.jdbc.Driver
Authentication Type Basic Authentication
User Name DB User
Password DB password

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

5. Move to Services tab, click on deployed service employee_MYSQLDB.

    • Click on 'Add Destination ', select MYSQLDB from the drop-down.

    • Save and close.

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

6. Once done, open the service document,

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

http://smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

7. Open service metadata document

    • OData defines a metadata format based on the Entity Data Model in XML (edmx).

    • To access a service's metadata document use the $metadata command.

    • The returned document is the service's edmx metadata + backend metadata

smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/$metadata

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

8. To get the details for the Entity 'employee'

smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

To fetch only first row of the table,

smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1001)

OData operations : RetrieveEntity (READ)

To retrieve details of a specific entity,use HTTP GET verb to execute the same.

    • Open Advanced REST client

REQUEST:

    • URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee

    • Use HTTP GET verb to execute this operation.

    • Pass below header values

Header Values
X-CSRF-TOKEN FETCH
Content-Type application/xml

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

RESPONSE :

    • 200 OK status message

    • X-CSRF-TOKEN value e.g. 1B4687085D8F59B1CA21382DF17D535A

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

OData Operations – InsertEntity (CREATE)

    • The InsertEntity operation creates an entity.

REQUEST :

    • URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee

    • Use HTTP POST verb to execute the InsertEntity operation.

    • Pass below header values

Header Values
X-CSRF-TOKEN 1B4687085D8F59B1CA21382DF17D535A
Content-Type application/xml
    • Pass this xml text into the BODY

1006SACHINSHARMACHANDIGARHINDIA

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

RESPONSE :

    • This operation creates an entity.

    • Successful execution of the operation returns HTTP 201 status code along with the Location of the newly created entity will be returned.

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文) To verify, you can check with smpserver:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1006) OR directly in the MySQL database.

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

OData Operations – UpdatetEntity (UPDATE)

    • The UpdateEntity operation updates an entity.

REQUEST

    • URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1003)

    • Use HTTP PUT verb to execute the this operation.

    • Pass below header values

Header Values
X-CSRF-TOKEN 1B4687085D8F59B1CA21382DF17D535A
Content-Type application/xml
    • Pass this xml text into the BODY

xml version="1.0" encoding="UTF-8"?>

1003CHIPROGSAN FRANSUSA

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

RESPONSE :

    • If the update is successful, the server responds with 204 status code .

    • As the response code text " No Content " signifies, no data is returned in the Response Body.

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

OData Operations – DeleteEntity (DELETE)

  • The DeleteEntity operation deletes an entity.

REQUEST

    • URL: jk:8080/gateway/odata/sap/employee_MySQLDB;v=1/employee(1006)

    • Use HTTP DELETE verb to execute this operation.

    • Pass below header values

Header Values
X-CSRF-TOKEN 1B4687085D8F59B1CA21382DF17D535A
Content-Type application/xml

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

RESPONSE :

    • If the delete is successful, the server responds with 204 status code.

    • As the response code text " No Content " signifies, no data is returned in the Response Body.

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)

NextPart 4

以上就是MYSQL-SMP3.0 : Integration Gateway with MySQL Datasource (Part 3)(图文)的内容,更多相关内容请关注PHP中文网(www.php.cn)!