(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