<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extable ] failed in the evaluation of <p> The [company_name] BizTalk Adapter for [service] enables you to execute SQL commands, updategrams, and stored procedures on [datasource] in BizTalk. This article provides a walk-through of an application that uses an updategram to insert [datasource]. </p> <ol> <li>A one-way file receive location picks up the XML document that contains the updategram. <li>The document is routed to a solicit-response send port configured for the adapter. <li>The adapter executes the command. The results of an insert contain the [primarykey|def('Id')] of the new record. <li>The response from [service] is routed to a one-way file send port, which writes the BizTalk message to a file. </ol> <h2>Create the Sample Application</h2> <p> The following sections walk through creating the sample application: </p> <ol> <li><a href="#xsd">Generate the Schema and an Updategram Instance</a></li> <li><a href="#frport">Configure a Receive Port</a></li> <li><a href="#floc">Configure a File Receive Location</a></li> <li><a href="#adapterconf">Configure the Adapter in a Solicit-Response Send Port</a></li> <li><a href="#fsport">Configure a File Send Port</a></li> <li><a href="#rt">Create Filters to Route BizTalk Messages Through the Application</a></li> <li><a href="#enlist">Enlist and Enable the Locations and Ports</a> <li><a href="#error">View Application Logs</a> </ol> <h2 id="xsd">Generate the Schema and an Updategram Instance</h2> <p> You can use wizards in Visual Studio to generate the schema and updategram instance: </p> <ol> <li><a href="#add">Add theAdapter to Your Project</a></li> <li><a href="#gen">Generate a Schema to Insert into the [extable] table</a></li> <li><a href="#inst">Generate an Updategram Instance</a> </ol> <h3 id="add">Add the Adapter to Your Project</h3> <p> Use the Add Adapter wizard to add the adapter to your project. You will use the adapter to query [service] for metadata about the table you want to insert to; for example, "[extable]". </p> <ol> <li>Right-click on the project in the Solution Explorer and click Add -> Add Generated Items. <li>Select Add Adapter Metadata in the resulting dialog box. <li>In the resulting Add Adapter Wizard, select the [company_name] BizTalk Adapter for [service] from the list view. <li>In the Port menu, leave the selection blank. Or, if you want to use the connection string for an adapter you have already configured, select the send port or receive location from your BizTalk application. <img src="../articles/biztalk-tutorial-updategram-1.png" title="[company_name] Adapters in the Select Adapter wizard. (Salesforce is shown.)"/> </li> </ol> <h3 id="gen">Generate a Schema to Insert into the [extable] Table</h3> <p> You will use the schema as a template for creating an updategram that will insert [service] data. The schema is an .xsd file that defines the XML request and response. As an example, an insert updategram is generated. You can follow the same process to create update and delete updategrams. </p> <ol> <li>In the Connection String page of the Schema Wizard, enter authentication credentials and other connection properties, if you have not already configured them in your BizTalk application. <img src="../articles/biztalk-tutorial-updategram-2.png" title="The connection string used by the adapter. (Salesforce is shown.)"/> </li> <li>Select the Send Port option. <li>Disable the One-Way option. The One-Way option ignores any response from the adapter for the updategram, such as the AffectedRows value that is returned.. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/qoo10-biztalk-tutorial-updategram.rst