(April 2016: Lab new for IIB10004) This lab shows you the steps to enable an IIB application (integration service) to connect to SQL Server, and retrieve some rows from a specific SQL Server table.


  • Basic configuration of SQL Server
  • Defining a new SQL Server data and table
  • Setting SQL Server permissions for IIB
  • Configuring IIB node for SQL Server
  • Testing IIB application with the Flow Exerciser

7 comments on"[iib10] Lab 31: Creating an Integration Service to access Microsoft SQL Server"

  1. @Ian_Larner,Thanks for uploading the labs with clear instructions.Can you please share the IIB log monitor. My email- pkasarla1@gmail.com
    Thank you

    • Hi @Kasarla12
      I’ve sent you an email about how to get and use the IIB log monitor.
      Regards, Ian

  2. I an doing this lab and would like to know where can I get the IIB Log Monitor for Windows?

    Also, when executing the step Create a Database Definition for HRDB I have no DB2 database running on my machine. I am not running the lab with a Virtual Machine that it is described in some pdfs of this lab that it is completely set for the course.

    Any ideas how to solve this?

    • Hi Daniel,
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      If you want to try the labs with DB2, you should be able to download and use DB2 Express-C or DB2 Trial; see DB2 Trials. The schema and command files are provided in the resource ZIP file for the Lab 1 (in student10\Create_HR_database\). The command files were created for the IBM Betaworks VMware lab environment, which is not available outside IBM, and you’ll likely want to make some changes for your environment. For information, see the summary in Self-study labs and more detail in the PDF for Lab 1. If you want to use Microsoft SQL/Server for example, you should be able to adapt the DDL and command files.
      Regards, Ian

  3. https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bc46200_.htm

    Based on the knowledgecenter link above, it states that Database Service can only interact with IBM DB2. Does it support MS SQL Server now?

  4. I’m unable to access the lab instructions or file via the link.

Join The Discussion

Your email address will not be published. Required fields are marked *