A LOB target is our local system business line (Line-Of-Business) and it´s respective operations, for example SQL Server can be viewed as a local LOB system and a Select and Insert it´soperations and is exposed to client applications
(it is integrated in them). Specifically a LOB target controls the connection to the LOB system URI (mssql ://SQLBIZTALK:1433//basededados), its operations (insert, select, update, delete ...) and the connection credentials (username and password).
This LOB target can be used by multiple LOB systems and is stored in a LOB relay. This LOB relay is as it was said the URL that allows the connection to the cloud (Azure) using the Service Bus Relays. It is also a repository of multiple LOB targets.
The creation of a target LOB SQL assumes that you have the Azure SDK EAI and EDI Labs installed and configured on your machine.
So the process starts by configuring a server in ServiceBus Connect Servers located in Server Explorer in Visual Studio:
In my case the option would be https://localhost:8080/SBConnect/ManagementService.svc/ because im working locally.
With the address configured, we get the following expansion in ServiceBus Server in Visual Studio:
We can select a URL to a LOB relay (Provides connectivity for our LOB targets using the Service Bus Connect) existing or create a new one, let's choose the option to create new and we have to specify:
The first three values can be found in the portal Azure AppFabric, located at the following address ->
and in the following location:
WARNING : One of the most common mistakes when setting a LOB target is using a namespace created in conventional Azure portal (Azure Platform), in which case the domain of our namespace would be Namespace.servicebus.windows.net
instead of Namespace. servicebus.appfabriclabs.com as well as management endpoint URL would be namespace-sb.accesscontrol.windows.net instead of Namespace-sb.appfabriclabs.com, this change will cause an error AppFabric because it can not resolve the address
of azure namespace and the following message will be displayed when we select Create in the previous step: