Course description: Incorporating SQL with IBM DataPower V4.0.1 (with lab exercise)

NOTE: THIS IS A SELF-PACED COURSE WITH A FIXED START AND END DATE.

You will be given access to the course material, and to a DataPower appliance in order to perform the labs, for a period of 4 days from the designated start date. At the end of the class period, your access will be removed. No extensions to the access period are possible.

This self-paced course does not involve a live instructor.

Please note that your enrollment will be confirmed shortly after you enroll, but you will not be sent the details on how to access the course and the lab environment until approximately 3 days before the designated class start date.

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 4-day access period.

There is no live instructor for this course, so it may not be appropriate for you who require the guidance of a live instructor.

Course overview:

This self-paced course combines streaming lecture with a hands-on lab exercise to introduce participants to the integration of the structured query language (SQL) with the DataPower appliance.

In the course lecture, you will 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 a hands-on lab exercise that shows 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 understand. The content of an element of the message is changed to a value returned from a SQL database.

You will implement three use cases during the lab exercise.

• In the first use case, a SQL Action communicates directly with a DB2 database and configures the DataPower policy.
• The second use case incorporates the use of a Transform Action, which is configured with a custom style sheet to create an XSLT Transformation. The syntax of the custom style sheet includes the sql-execute function. The sql-execute function is the logic, or access point, as to where the SQL database command actually gets executed.
• The final use case calls a stored procedure that is executed from within a style sheet that uses the returned value to populate an xml document; the xml document is then sent to a web service.

Online enrollment:

THIS IS A SELF-PACED VIRTUAL CLASS. ONCE YOU REGISTER, YOU HAVE 4 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 containing your online link, your ID and password, and additional instructions for starting the course.

You can start the course at any time. Once you start the course, you have 4 days to complete it. You are billed for the course when you submit the enrollment form.

ONCE YOU ARE ENROLLED IN THIS COURSE, YOU WILL NOT BE ABLE TO CANCEL YOUR ENROLLMENT.

View this course in other countries

Training Paths that reference this course are:

• Implementer skills for IBM WebSphere DataPower SOA Appliances

Back to top

IBM Education Advantage Program Eligibility:

• Yes - Education Pack - online account

Back to top

This intermediate course is for developers who configure SQL integration on IBM WebSphere DataPower SOA Appliances.

Back to top

You must have experience:

• using the WebGUI to develop services and service policies on a DataPower appliance.

Back to top

• Describe DataPower as an IaaS (Information as a Service) design pattern
• Use DataPower appliances to enable information as a service and perform message enrichment
• Perform SQL queries on a database from a DataPower service policy
• Execute database stored procedures in a DataPower service policy

Back to top

• Incorporating SQL with IBM DataPower V4.0.1
• Exercise: Incorporating SQL with IBM DataPower V4.0.1

Back to top

System requirements:

After you enroll in this course, you will be directed to a link to help you prepare your system to access the course.

The computer you use to access the labs should meet the following requirements:

• Microsoft Windows XP Professional SP3, Microsoft Vista SP1, or Microsoft Windows 7
• Internet Explorer V6.0 SP2 (or higher) or Mozilla Firefox V2.0 (or higher)
• 256 kbps or faster Internet connection

For information about other related WebSphere courses, visit the WebSphere Education Training Paths website:

• www.ibm.com/software/websphere/education/paths/

Back to top