Course description: Incorporating SQL with IBM DataPower V4.0.1 (with demonstration) - Updated

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:

• 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. 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:

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

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
• Demonstration: Incorporating SQL with IBM DataPower V4.0.1

Back to top

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 that 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

Back to top