Step 4(b): Create LOB Relay and Targets for Insert Operation
Updated: January 16, 2014
In this step, you create an LOB Relay and an LOB Target for the Insert operation on the OrderDetails table.
To create a SQL Server LOB Target
In the BizTalk Service project, from Server Explorer, right-click BizTalk Adapter Services, and then click Add BizTalk Adapter Service. This prompts for the BizTalk Adapter Service Management URL. Specify the management URL. The BizTalk Adapter Service Management URL is path to the ManagementService.svc WCF service hosted in IIS. Runtime Components: BizTalk Adapter Service provides more information on the BizTalk Adapter Service components within IIS.
If the BizTalk Adapter Service Runtime is installed locally with the default settings, enter: http://localhost:8080/BAService/ManagementService.svc/
If the BizTalk Adapter Service Runtime is installed remotely with the default settings, enter: http://ServerName:8080/BAService/ManagementService.svc/
- If the BizTalk Adapter Service Runtime is installed locally with the default settings, enter: http://localhost:8080/BAService/ManagementService.svc/
Expand the newly added server, expand LOB Types, right-click SQL, and select Add SQL Target. The Add a Target wizard starts.
Read the information on the Before You Begin page, and then click Next.
On the Connection Parameters page, specify the details for the SQL Server to connect to and the credentials to use for the connection. Click Next.
Note You can use the Advanced button to build the SQL Server connection URI and also specify the binding properties for the connection.The SQL Server Connection URI provides additional information about how to build the URI. For information about binding properties, see Working with BizTalk Adapter for SQL Server Binding Properties. For this tutorial, leave the default setting as-is for the binding properties.
On the Operations page, do the following:
From the left box, expand Tables, expand OrderDetails, select Insert, and then click the right arrow. The Insert operation must now be listed under the Selected operations section.
In the Runtime Security page, specify the security type. This security type determines how the client message is authenticated with the LOB Target. Options include:
Select this option if you are using a username and password created locally on the LOB system.
Fixed Windows credential
Select this option to use a Windows domain account.
Custom SOAP Header
Select this option if you create a custom SOAP header to include the username and password.
Select this option if you are including the logon credentials in the WS-Security header of the message.
For this tutorial use the Fixed Windows credential option, specify the credentials, and then click Next.
On the Deployment page, choose an existing LOB Relay or create a new LOB Relay.
Tip A single LOB Relay can be used with multiple LOB Targets. There are restrictions based on the security model. As a best practice, group the same security method in one LOB Relay. For example, use the same LOB Relay to host the LOB Targets that use Message Credential or Fixed Windows security type.
To create a new LOB Relay:
Required. Enter your Service Bus namespace because the LOB relay will be created in the Service Bus. The namespace name is available in the Azure Management Portal after you sign-in.
For example, if myNamespace is the namespace, this will update the Management address to be:
Required. Specify the Service Bus Issuer Name.
Required. Specify the Service Bus Issuer Secret key..
Required. Enter the desired name of the relay path. For this tutorial, set this property to SQLLOBRelay.
Required. Enter a sub-path to make this target unique. For example, you can enter OrderDetails.
Target runtime URL
This is automatically populated with the namespace name, relay path and target sub-path specified. If using the examples above, it will be populated with something like:
On the Summary page, review the values you specified in the previous steps, and then click Create.
When the wizard completes, click Finish. The following activities occur in the background:
The LOB Target is created in Server Explorer. It can be disabled, started and deleted. Its configuration can also be exported.
The LOB Target is created as an application in IIS. This application uses the Runtime for this specific LOB Target. Runtime Components: BizTalk Adapter Service describes the IIS components.
To use the LOB Target:
Set the Runtime Security property for the relay endpoint.
Right-click the relay endpoint in Server Explorer and select Properties.
In the Properties grid, click the ellipsis (…) against the Runtime Security property.
In the Edit Security dialog box, select Fixed Windows Credentials and specify username and password to connect to the SQL Server.
- Right-click the relay endpoint in Server Explorer and select Properties.
Drag and drop the LOB Target onto the design surface. Note the Entity Name property of the LOB Target. The default value is Relay-Path_target-sub-path. If using the examples above, it will be sqllobrelay_orderdetails.
Open the .config file for the LOB target, which typically has the naming convention as YourRelayPath_target-sub-path.config. Specify the Service Bus issuer name and issuer secret, as shown below:
<tokenProvider> <sharedSecret issuerName="owner" issuerSecret="issuer_secret" /> </tokenProvider>
- The LOB Target is created in Server Explorer. It can be disabled, started and deleted. Its configuration can also be exported.
Other ResourcesStep 4: Create and Configure the LOB Target