|Course code||ZE475||Skill level||Intermediate|
|Duration||0.4 days||Delivery type||Self-paced Virtual Class|
|Course type||Public only|
|Public price||See Partner website|
NOTE: THIS IS AN ONLINE SELF-PACED VIRTUAL COURSE. DO NOT MAKE TRAVEL ARRANGEMENTS FOR THIS COURSE.
Self-paced virtual classroom (SPVC) courses provide the same deep technical content as WebSphere Education classroom courses, but allow you to learn on your own schedule. You can stop and start a self-paced virtual class as needed during the 60-day access period.
This self-paced course combines streaming lecture with demonstrations to introduce participants to the integration of the structured query language (SQL) with the DataPower appliance.
In the course lecture, students learn multiple options for accessing a SQL database from within a processing rule of a service policy. SQL calls are issued from a SQL Action, from XSL transformations through the dp:sql-execute(), or from a DataPower extension function. These SQL calls perform create, read, update, delete operations to the data located in the database and execute stored procedures.
DataPower database support consistently grows more sophisticated. Capabilities such as parameter markers and full support for stored procedures invocations enable greater use of native database technologies.
The course concludes with three demonstrations that show how to configure a multiprotocol gateway (MPG) to interact with a SQL database. The MPG receives a SOAP message from an external source. The service policy of the MPG changes the input SOAP message to a format that the back-end web services understands. The content of an element of the message is changed to a value returned from a SQL database.
The demonstrations implement three use cases:
THIS IS A SELF-PACED VIRTUAL CLASS. AFTER YOU REGISTER, YOU HAVE 60 DAYS TO COMPLETE THE COURSE.
Before you enroll, review the system requirements on this page to ensure that your system meets the minimum requirements for this course.
Within 48 hours of enrolling in the course, you will receive a confirmation email that contains your online link, your ID and password, and additional instructions for starting the course.
You can start the course at any time. After you register for the course, you have 60 days to complete it. You are billed for the course when you submit the enrollment form.
AFTER YOU ARE ENROLLED IN THIS COURSE, YOU WILL NOT BE ABLE TO CANCEL YOUR ENROLLMENT.
For information about other related WebSphere courses, visit the WebSphere Education Training Paths website:
Training Paths that reference this course are:
This intermediate course is for developers who configure SQL integration on IBM WebSphere DataPower SOA Appliances.