How to use BizTalk Adapter for Splunk for executing SQL Commands, datagrams, and storing procedures on Splunk data in Biztalk server. I have got this doubt while preparing my project.
With the CData BizTalk Adapter for Splunk, you can use BizTalk to run SQL queries, updategrams, and stored procedures on Splunk data. This article walks you through an application that inserts Splunk data via an updategram.
- The XML document containing the updategram is picked up by a one-way file receive site.
- The document is forwarded to the adapter's solicit-response transmit port.
- The command is carried out by the adapter. The Id of the new record and the rows affected are contained in the insert result.
- Splunk's response is forwarded to a one-way file send port, which records the BizTalk message in a file.
- Include the Adapter in Your Work.
- To add the adapter to your project, use the Add Adapter wizard. The adapter will be used to query Splunk for metadata about the table you want to put into, such as "DataModels."
- In the Solution Explorer, right-click the project and select Add -> Add Generated Items.
- In the resulting dialogue box, click Add Adapter Metadata.
- Select the CData BizTalk Adapter for Splunk from the list view in the Add Adapter Wizard that appears.
- Leave the Port menu's selection blank. Select the send port or receive location from your BizTalk application if you wish to use the connection string for an adapter you've previously configured.
- Make a schema for inserting data.
The schema will be used as a starting point for developing an updategram that will insert Splunk data. The XML request and response are defined by the schema, which is an.xsd file. We'll show you how to make an insert updategram as an example. The same procedure can be used to create and delete updategrams.
Enter authentication credentials and other connection details on the Schema Wizard's Connection String page.
Select the Send Port option in the following step.
Remove the One-Way option from the menu. The One-Way option ignores any adapter response for the updategram, such as the returned AffectedRows value. The newly formed row's Id is also returned.
You can get an updategram schema that permits retrieving the Id by deactivating the One-Way option.
Select Updategram from the Command Type option.
Create an instance of Updategram.
This phase will construct the XML message that will be sent to the adaptor in a later step. Right-click the.xsd file in Solution Explorer and select Generate Instance to construct the updategram. The Output tab displays the place where the updategram is saved.
The updategram is formatted to specify what kind of answer Splunk should provide. See the adapter's help manual for further information about updategrams and other topics.
Set up the Receive Port
You must first add a receive port to your application before you can add a receive location. Data can be received from many receive sites through receiving ports.
- In the BizTalk Server Administration Console, open your application.
- Right-click Receive Ports and select New -> One-Way Receive Port from the drop-down menu. The Properties of the Receive Port dialogue box appears.
- Give the receive port a name.
- Set the File Reception Location
- A BizTalk message containing the updategram will be created via a static one-way file receive location.
- Right-click Receive Locations and select New -> One-Way Receive Location from the menu that appears.
- Choose which receive port the new receive location will be a part of. The dialogue box for the Receive - Location Properties appears.
My only suggestion to you is go with BizTalk Server Training to get certified and know more about BizTalk Server.