BizTalk Hands-On Labs (17) ODBC adapter uses

For more information, see: BizTalk Hands-on Labs series catalog

BizTalk Development Series

1 Course Brief

Familiarize yourself with the use of ODBC adapters in this course, this exercise uses the BizTalk ODBC adapter

2 preparatory work

1. Download, install, and configure the BizTalk ODBC adapter

2. Create a new BizTalk Empty project

3. Configure the application name and program signature for the BizTalk project.

Note: The process of creating a BizTalk project is described in the following: Comprehensive BizTalk Development Experiment

3 Demo 3.1 Creating an ODBC data source 3.1.1 Creating TNS in the Oracle client directory

3.1.2 Click on 32-bit ODBC source hypervisor (C:\Windows\SysWOW64\odbcad32.exe)

3.1.3 Selecting Microsoft ODBC for Oracle in the System DSN

3.1.4 Enter the data source name, username and server (TNS name) in the popup dialog box

3.2 Create receive Schema3.2.1 right-click Project, add Build Item 3.2.2 Click Add Adapter Metadata

3.2.3 Selecting ODBC in the Select adapter

3.2.4 Click Set Select the ODBC data source you just created in the data source and enter the user name and password

3.2.5 after setting up the connection, click Next.

3.2.6 Enter namespace, port type and root node in the Schema Information dialog box

3.2.7 Schema Type selection script

Enter SQL script in 3.2.8 Query dialog box

3.2.9 received schema has been created to complete

3.3 Create send Schema3.3.1 as shown in reference 3.1, in the Schema Information dialog box, select Send in the item type

3.3.2 Select Insert,update,delete in the query type, enter the script in the Query box, check override default query processing, click Generate 3.3.3 Click Generate, modify the type of the parameter in the ADO dialog box to match the database field type

3.3.4 Click on the test query to see the input and output schema, clicking on the Update command. 3.4 Creating map mappings and connecting source and target fields

3.5 Deployment and Configuration Application 3.5.1 build and deploy the project 3.5.2 create a receive port and location, select ODBC in the adapter

3.5.3 in SQL configuration, the SQL connection string selects the ODBC source and username password created in the dialog box, and the SQL command selects the corresponding schema, which is read automatically.

3.5.4 Receive Pipeline Selection xmlreceive

3.5.5 Select the map you just created in the Receive port mapping

3.5.6 Create a new send port, select an ODBC adapter, select the appropriate ODBC data source in the connection string and enter the username password

3.5.7 subscribing to receive port data in a Send subscription

3.5.8 Similarly, create a new send port for the file adapter to output to a file

3.6 Restart the BizTalk instance to start the BizTalk Application Test 3.6.1 out folder has the corresponding file output

The 3.6.2 database has corresponding data output