Prerequisites to create SQL applications using the SQL adapter

What you must do before developing BizTalk applications using the Microsoft BizTalk Adapter for SQL Server. The topic also lists some BizTalk Server tools that are used to develop BizTalk applications.

Create a strong-named key file

You must create a strong-name key file to build projects in Microsoft Visual Studio. A strong name consists of the project's identity—its simple text name, version number, and culture information (if provided)—plus a public key and a digital signature. The strong-name key file contains the public key and the private key.

Important

Creating a strong-name key file is a one-time task. You can use the same key for all the BizTalk applications you develop.

Prerequisites

You must have Microsoft Visual Studio installed on the computer where you want to create a strong-name key.

Create a strong-name key file

  1. Open the developer command prompt for Visual Studio.

  2. At the command prompt, navigate to the location where you want to create the key file. For example, type cd C:\Sample, and then press ENTER.

  3. At the command prompt, type sn -k <key file name>.snk, and then press ENTER.

    Note

    You should receive a message at the command prompt stating that the key pair was written to the strong-name key file.

  4. At the command prompt, type exit, and then press ENTER.

Learn the BizTalk Server tools

The topics on how to use the Siebel adapter in Building blocks to develop BizTalk applications with the SQL adapter are written with the assumption that you have working knowledge of a number of BizTalk Server tools. You use the following tools to develop BizTalk applications using the Microsoft BizTalk Adapter for Siebel eBusiness Applications:

  • Microsoft Visual Studio

  • BizTalk Explorer

  • Orchestration designer

  • Pipeline designer

  • BizTalk mapper

  • BizTalk Server Administration console

Prerequisites

You must install Microsoft BizTalk Server before you can access the BizTalk Server tools.

BizTalk Server Tools

The following table includes topics in the BizTalk Server documentation that explain how to use each of the listed tools.

Tool Topics in BizTalk Server core documentation
Visual Studio - Using Visual Studio
- Working with BizTalk Projects
- Deploying BizTalk Assemblies from Visual Studio into a BizTalk Application

Learn more about Visual Studio solutions, projects, and items at Solutions and Projects in Visual Studio.
Orchestration Designer Creating orchestrations using orchestration designer
Pipeline Designer Creating pipelines using pipeline designer
BizTalk Mapper Creating maps using BizTalk mapper
BizTalk Server Administration console Using the BizTalk Server Administration console

Next

Building blocks to develop BizTalk applications with the SQL adapter