Step 5(c): Generate Schema for the Insert Operation
Important
Microsoft Azure BizTalk Services (MABS) is being retired, and replaced with Azure Logic Apps. If you currently use MABS, then Move from BizTalk Services to Logic Appsprovides some guidance on moving your integration solutions to Logic Apps.
If you're brand new to Logic Apps, then we suggest getting started here:
-
Create your first logic app, or quickly get started using a pre-built template
-
View all the available connectors you can use in your logic apps
So far, we have the schema for the flat-file message, the FTP source that represents the FTP Server, and the LOB Relay and LOB Target for connectivity to the on-premise SQL Server. But we still require the schema of the message required to perform an Insert operation on the Claims table in the on-premise SQL Server database. This step demonstrates how to generate that schema.
To generate the schema for Insert operation
In the BizTalk Service project, in the Server Explorer, right click the LOB target you created, and then click AddSchemasToFlatFile_Bridge. The Schema Generation dialog pops up.
Set the file name prefix to FlatFile_Bridge_. Leave the folder name to its default value of LOB Schemas.
Select credential Type as Windows to use Windows authentication to connect to SQL Server, and then click OK.
.jpeg "Generate schema for Insert operation")
The schemas are added to the FlatFile_Bridge project under the LOB Schemas folder. The schema that corresponds to the Insert operation on the Claims table has the name FlatFile_Bridge_TableOperation.dbo.Claims.xsd. The structure of the schema resembles the following:
.jpeg "Schema for the Insert operation")
Save changes to the project.