installing and configuring microsoft biztalk adapters for enterprise applications

79
Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications Published: March 2009

Upload: ashwini-upadhyay

Post on 22-Nov-2014

118 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Published: March 2009

Page 2: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

ContentsInstalling and Configuring Microsoft BizTalk Adapters for Enterprise Applications..........................5

Adapter Requirements................................................................................................................. 5Requirements for BizTalk Adapter for J.D. Edwards EnterpriseOne.........................................6

Prerequisites for Installing BizTalk Adapter for J.D. Edwards EnterpriseOne........................8Copying the J.D. Edwards .Jar Files from the EnterpriseOne Server to the BizTalk Server..8Installing the JDK 1.4.2 or Later............................................................................................8Installing the JDBC Driver.....................................................................................................8Understanding Jdeinterop.ini................................................................................................8

Requirements for BizTalk Adapter for J.D. Edwards OneWorld XE........................................10BizTalk Adapter for J.D. Edwards OneWorld XE Installation Process Overview.................11Installing Planner Update Electronic Software Update (ESU).............................................13

Creating/Updating the Internet Code Change ODBC Data Source.................................13Copying New Object Configuration Mappings to the Planner ODBC Data Source and the

System ODBC Data Source.........................................................................................13Copying Control Table Information to the Planner Update Access Database..................15Copying Bitmaps to Planner............................................................................................17

Installing BTSREL Application Software Update (ASU)......................................................17Applying BTSREL ASU to J.D. Edwards OneWorld XE Environments...............................17Creating and Building the BTSREL Custom Business Function Library Manually..............18

Step 1: Creating the BTSREL Custom Business Function Library..................................18Step 2: Building the Library to Create the DLL................................................................19Step 3: Copying the Custom Business Function Library DLL..........................................19

Building and Deploying the Full Package............................................................................20Creating BTSLIBInterop.jar.................................................................................................22Copying the BTSLIBInterop.jar File and the J.D. Edwards .JAR Files................................23Installing the JDK 1.4.2 or Later on the BizTalk Server.......................................................24

Requirements for BizTalk ODBC Adapter for Oracle Database..............................................24Prerequisites for Installing BizTalk ODBC Adapter for Oracle Database.............................24Installing the Oracle Client..................................................................................................25Configuring a Database Connection...................................................................................25Upgrading Oracle Driver.....................................................................................................25

Requirements for BizTalk ODBC Adapter for Oracle E-Business Suite..................................25Prerequisites for Installing BizTalk ODBC Adapter for Oracle E-Business Suite.................26Installing the Oracle Client..................................................................................................26Configuring a Database Connection...................................................................................26Upgrading Oracle Driver.....................................................................................................27

Requirements for BizTalk Adapter for PeopleSoft Enterprise.................................................27Prerequisites for Installing BizTalk Adapter for PeopleSoft Enterprise................................27Send Handler PeopleSoft Requirements............................................................................28Receive Handler PeopleSoft Requirements........................................................................28Uploading a Custom Component Interface into PeopleSoft................................................28Creating a New Component Interface.................................................................................28Checking the Component Interface....................................................................................30

Page 3: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Setting the Component Interface Security..........................................................................31Testing the Component Interface........................................................................................32

Requirements for BizTalk Adapter for Siebel eBusiness Applications....................................32Requirements for BizTalk Adapter for TIBCO Enterprise Message Service...........................36Requirements for BizTalk Adapter for TIBCO Rendezvous....................................................37Requirements for BizTalk Adapter v2.0 for mySAP™ Business Suite Service Pack 1...........38

Installing BizTalk Adapters for Enterprise Applications..............................................................38Installation Information for BizTalk Adapter for J.D. Edwards EnterpriseOne.........................39

Installed Components.........................................................................................................40Registering BizTalk Adapter for J.D. Edwards EnterpriseOne to the BizTalk Server...........40Enterprise Single Sign-On..................................................................................................41Creating Send Ports to Communicate with J.D. Edwards EnterpriseOne Servers..............41

Installation Information for BizTalk Adapter for J.D. Edwards OneWorld XE..........................50Installed Components.........................................................................................................50Registering BizTalk Adapter for J.D. Edwards OneWorld XE to the BizTalk Server............51Enterprise Single Sign-On..................................................................................................51Creating Send Ports to Communicate with J.D. Edwards OneWorld XE Servers...............51Handling String Values........................................................................................................54

Installation Information for BizTalk ODBC Adapter for Oracle Database................................55Installed Components.........................................................................................................56Registering BizTalk ODBC Adapter for Oracle Database to BizTalk Server........................56Enterprise Single Sign-On..................................................................................................56Creating Send Ports and Receive Ports Using BizTalk ODBC Adapter for Oracle Database

........................................................................................................................................ 57Installation Information for BizTalk ODBC Adapter for Oracle E-Business Suite....................57

Installed Components.........................................................................................................57Registering BizTalk ODBC Adapter for Oracle E-Business Suite to BizTalk Server............57Enterprise Single Sign-On..................................................................................................58Creating Send Ports and Receive Ports by Using BizTalk ODBC Adapter for Oracle E-

Business Suite................................................................................................................. 58Installation Information for BizTalk Adapter for PeopleSoft Enterprise...................................58

Installed Components.........................................................................................................58Registering BizTalk Adapter for PeopleSoft to BizTalk Server.............................................59Enterprise Single Sign-on...................................................................................................59Creating Send Ports and Receive Ports by Using BizTalk Adapter for PeopleSoft.............59

Installation Information for BizTalk Adapter for Siebel eBusiness Applications.......................59Installed Components.........................................................................................................60Registering BizTalk Adapter for Siebel eBusiness Applications to BizTalk Server...............60Enterprise Single Sign-on...................................................................................................60Creating Send Ports and Receive Ports by Using BizTalk Adapter for Siebel eBusiness

Applications.....................................................................................................................61Installation Information for BizTalk Adapter for TIBCO Enterprise Message Service..............61

Installed Components.........................................................................................................61Registering BizTalk Adapter for TIBCO EMS to BizTalk Server..........................................62Enterprise Single Sign-On..................................................................................................62Creating Send Ports and Receive Ports by Using BizTalk Adapter for TIBCO EMS...........62

Page 4: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Limitations........................................................................................................................... 62Installation Information for BizTalk Adapter for TIBCO Rendezvous......................................62

Installed Components.........................................................................................................63Registering BizTalk Adapter for TIBCO Rendezvous to BizTalk Server..............................64Enterprise Single Sign-On..................................................................................................64Creating Send Ports and Receive Ports by Using BizTalk Adapter for TIBCO Rendezvous

........................................................................................................................................ 64Activating Tracing for all the Adapters.......................................................................................64

Using Windows Trace Event..................................................................................................64ETW Components..............................................................................................................65

Adding the BizTalk Adapters for Enterprise Applications to BizTalk Server................................66Copyright................................................................................................................................... 66

Page 5: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Installing and Configuring Microsoft BizTalk Adapters for Enterprise ApplicationsThis document provides instructions for installing and configuring Microsoft® BizTalk® Adapters for Enterprise Applications for both BizTalk Server 2006, BizTalk Server 2006 R2 and BizTalk Server 2009. As auxiliary information, it also provides instructions for installing and configuring Microsoft BizTalk Adapter v2.0 for mySAP™ Business Suite Service Pack 1.

Microsoft BizTalk Adapters for Enterprise Applications includes the following adapters:

Microsoft BizTalk Adapter for J.D. Edwards EnterpriseOne

Microsoft BizTalk Adapter for J.D. Edwards OneWorld XE

Microsoft BizTalk ODBC Adapter for Oracle Database

Microsoft BizTalk ODBC Adapter for Oracle E-Business Suite

[This Oracle E-Business Suite has been deprecated for Microsoft BizTalk Server 2009] Microsoft BizTalk Adapter for PeopleSoft Enterprise

Microsoft BizTalk Adapter for Siebel eBusiness Applications

Microsoft BizTalk Adapter for TIBCO Enterprise Message Service

Microsoft BizTalk Adapter for TIBCO Rendezvous

Important You must be experienced with the specific enterprise application before you make any configuration changes to your enterprise applications.

Caution You should back up all data before making any configuration changes.

This document has two parts. The first part describes the requirements before installing each adapter. The second part describes how to install each adapter. To make sure that you are reading the most up-to-date information, download the latest version of this document at http://go.microsoft.com/fwlink/?LinkId=56392.

Adapter RequirementsThis section describes software requirements and preparation steps for each adapter. For installation information, see Installing BizTalk Adapters for Enterprise Applications later in this document.

5

Page 6: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Requirements for BizTalk Adapter for J.D. Edwards EnterpriseOneBizTalk Adapter for J.D. Edwards EnterpriseOne enables you to use J.D. Edwards EnterpriseOne business functions within BizTalk Server. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about J.D. Edwards EnterpriseOne, see the documentation for the application.

Supported Operating SystemsBizTalk Adapter for J.D. Edwards EnterpriseOne runs on the following operating systems:

Microsoft Windows Server® 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows® 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported J.D. Edwards EnterpriseOne VersionsBizTalk Adapter for J.D. Edwards EnterpriseOne supports the following J.D. Edwards EnterpriseOne versions:

J.D. Edwards EnterpriseOne 8.10, 8.11, and 8.12

Tools Release 8.93, 8.94, 8.95, 8.96 and 8.97

Required ServersBizTalk Adapter for J.D. Edwards EnterpriseOne requires the following servers to install and configure the adapter:

BizTalk server

EnterpriseOne Server. It is needed for copying the .jar files to the BizTalk server.

Required ComponentsBizTalk Adapter for J.D. Edwards EnterpriseOne requires the following components on the server where the adapter is installed.

BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Sever 2009

Sun Microsystems Java Development Kit (JDK) version 1.4.2 or later

JDBC drivers for J.D. Edwards EnterpriseOne databases

Required FilesBizTalk Adapter for J.D. Edwards EnterpriseOne uses the following .jar files at both runtime and design time:

Version Required Files

8.10 with Tools Release version 8.93, 8.94, 8.95, and 8.96

Connector.jar

Kernel.jar

database.jar

6

Page 7: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Version Required Files

jdeutil.jar

log4j.jar

xerces.jar

8.11 with Tools Release version 8.94, 8.95, and 8.96

Connector.jar

Kernel.jar

database.jar

jdeutil.jar

log4j.jar

xerces.jar

8.12 with Tools Release version 8.96 and 8.97 ApplicationAPIs_JAR.jar

ApplicationLogic_JAR.jar

Base_JAR.jar

BizLogicContainer_JAR.jar

BizLogicContainerClient_JAR.jar

Connector.jar

jdbj.ini

JdbjBase_JAR.jar

JdbjInterfaces_JAR.jar

jdeinterop.ini

jdelog.properties

JdeNet_JAR.jar

log4j.jar

PMApi_JAR.jar

Spec_JAR.jar

System_JAR.jar

xalan.jar

xerces.jar

All versions The JDBC files for the corresponding database (For Microsoft SQL Server™ 2000 JDBC driver, the adapter requires msbase.jar, mssqlserver.jar, and msutil.jar.)

All versions JDEDynAccess.jar (installed with the adapter)

7

Page 8: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Prerequisites for Installing BizTalk Adapter for J.D. Edwards EnterpriseOneBefore installing BizTalk Adapter for J.D. Edwards EnterpriseOne, you must configure the BizTalk server for the adapter installation by following these basic steps:

1. Copy the J.D. Edwards .jar files from the EnterpriseOne server to the BizTalk server

2. Install the JDK 1.4.2 or later

3. Install the JDBC driver

Copying the J.D. Edwards .Jar Files from the EnterpriseOne Server to the BizTalk ServerThe J.D. Edwards .jar files are listed in the previous Required Files section. As previously mentioned, you must copy the .jar files to the BizTalk server. They can be copied to any location on the BizTalk server. These files will be referenced from the Transport Properties dialog box while you create the send ports.

Installing the JDK 1.4.2 or LaterYou can download the JDK 1.4.2 or later from the Sun Microsystems Web site. Follow the instructions on the site to install it on the BizTalk server.

Installing the JDBC DriverBizTalk Adapter for J.D. Edwards EnterpriseOne calls the J.D. Edwards EnterpriseOne API that uses JDBC, which needs a driver for the database. If you install J.D. Edwards EnterpriseOne with a SQL Server database, you need MS-SQL drivers. Similarly, if you installed J.D. Edwards EnterpriseOne with an Oracle database, you will need Oracle drivers; or if you installed with a DB2 database, you will need DB2 drivers.

If you are using Oracle DatabaseType, you must add extra information to the jdeinterop.ini file. Specifically, you must add the database parameter to the [JDBj-ORACLE] section, which defines the Oracle tnsnames location. You must also ensure that Oracle’s SQLNET.ORA file is present on the BizTalk server. Using the information from the J.D. Edwards EnterpriseOne’s jde.ini file, add the following to the adapter’s jdeinterop.ini file:

[JDBj-ORACLE]

tns=c:\Oracle\ora92\network\Admin\tnsnames.ora

[JDBj-BOOTSTRAP DATA SOURCE]

Database=sys810

Understanding Jdeinterop.iniThe Connect.jar and Kernel.jar files use the jdeinterop.ini file to configure connection parameters to the J.D. Edwards OneWorld XE server. We recommend that you not edit this file manually because it interacts with the Transport Properties dialog box for the BizTalk send port.

8

Page 9: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Specifically, you should not modify those fields marked as Configured_by_BizTalk in the following table.

The J.D. Edwards EnterpriseOne connector classes in Connector.jar and Kernel.jar require that you use a configuration file named jdeinterop.ini. This file is defined by the J.D. Edwards EnterpriseOne application and uses its terminology. For more information about the purpose and terminology of this file, see the J.D. Edwards Interoperability Guide. There is a sample jdeinterop.ini file in: C:\Program files\Program Files\Microsoft BizTalk Adapters for Enterprise Application\J.D. Edwards EnterpriseOne\config folder. The following table gives a short description of the entries in that file:

Parameters Description

[SERVER]

glossaryTextServer=Configured_by_BizTalk

codePage=1252

glossaryTextServer: the enterprise server and port that provide glossary text information, for example, JDED:6010.

This is the server that returns text descriptions for errors. This is often the same host and port as the J.D. Edwards EnterpriseOne application server. There may be more than one glossary server for different supported language encodings.

codePage: the encoding scheme.

Here is a list of commonly used code page numbers:

1252 English and Western European

932 Japanese

950 Traditional Chinese

936 Simplified Chinese

949 Korean

[JDENET]

serviceNameConnect=Configured_by_BizTalk

enterpriseServerTimeout=1200000

maxPoolSize=30

netTrace=false

enterpriseServerTimeout: the time-out value for a request to the enterprise server, for example, 90000.

maxPoolSize: the JDENET socket connection pool size, for example, 30.

[JDBj-BOOTSTRAP SESSION]

User=Configured_by_BizTalk

Password=Configured_by_BizTalk

Environment=Configured_by_BizTalk

Role=*ALL

The information in this section should match the corresponding information specified in the [DB SYSTEM SETTINGS] section of this installation's jde.ini file.

9

Page 10: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Parameters Description

[JDBj-BOOTSTRAP DATA SOURCE]

name=Configured_by_BizTalk

server=Configured_by_BizTalk

databaseType=Configured_by_BizTalk

physicalDatabase=Configured_by_BizTalk

serverPort=Configured_by_BizTalk

owner=Configured_by_BizTalk

The information in this section should match the corresponding information specified in the [DB SYSTEM SETTINGS] section of this installation's jde.ini file.

Requirements for BizTalk Adapter for J.D. Edwards OneWorld XEBizTalk Adapter for J.D. Edwards OneWorld XE enables you to use J.D. Edwards OneWorld XE business functions within BizTalk Server. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about J.D. Edwards OneWorld XE, see the documentation for the application.

Supported Operating SystemsBizTalk Adapter for J.D. Edwards OneWorld XE runs on the following operating systems:

Microsoft Windows Server 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported J.D. Edwards OneWorld XE VersionsBizTalk Adapter for J.D. Edwards OneWorld XE supports the following J.D. Edwards OneWorld XE versions:

B7.3.3.3 with Service Pack 23

B7.3.3.4 with Service Pack 23

Required ServersBizTalk Adapter for J.D. Edwards OneWorld XE requires the following servers to install and configure the adapter:

J.D. Edwards enterprise server. This server can be on any of the operating systems supported by J.D. Edwards OneWorld XE.

J.D. Edwards Deployment server. This server is used for installing the BTSREL Application Software Update and creating BTSLIBInterop.jar. This server has to be on a Windows operating system.

BizTalk server. This is the server where the adapter is installed. The adapter can run on BizTalk Server 2006 , BizTalk Server 2006 R2 and BizTalk Server 2009.

10

Page 11: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Note The architecture of BizTalk Adapter J.D. Edwards OneWorld XE is documented in the BizTalk Server Help. For more information about the architecture, see http://go.microsoft.com/fwlink/?LinkId=95285.

Required ComponentsBizTalk Adapter for J.D. Edwards OneWorld XE requires the following components on the server where the adapter is installed:

BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009

Sun Microsystems Java Development Kit (JDK) version 1.4.2 or later. It is required on the deployment server in order to create BTSLIBInterop.jar.

BizTalk Adapter for J.D. Edwards OneWorld XE Installation Process OverviewThe following figure shows the installation and configuration process for BizTalk Adapter for J.D. Edwards OneWorld XE.

1. Providing BTSREL.exe

2. Installing the planner update Electronic Software Update (ESU)

11

Page 12: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

3. Installing the BTSREL application software update (ASU)

4. Applying the BTSREL ASU to J.D. Edwards OneWorld XE environments

5. Creating and building the BTSREL custom business function library manually

6. Creating and deploying a full package

7. Creating BTSLIBInterop.jar

8. Copying the J.D. Edwards .jar files and BTSLIBInterop.jar to the BizTalk server

9. Installing the JDK 1.4.2 or later

10. Installing BizTalk Adapter for J.D. Edwards OneWorld XE

11. Adding BizTalk Adapter for J.D. Edwards OneWorld XE to BizTalk Server

12. Creating send ports

13. Communication is established from the BizTalk server to the enterprise server

You must perform the following steps before installing BizTalk Adapter for J.D. Edwards OneWorld XE and after J.D. Edwards OneWorld XE has been installed and configured on the deployment server and the enterprise server. These steps must be performed by a J.D. Edwards Configurable Network Computing (CNC) specialist or administrator:

1. Installing planner update Electronic Software Update (ESU)

2. Installing the BTSREL application software update (ASU)

3. Applying the BTSREL ASU to J.D. Edwards OneWorld XE environments

4. Creating and building BTSREL custom business function library manually

5. Creating and deploying a full package

6. Creating BTSLIBInterop.jar

7. Copying the J.D. Edwards .jar files and the BTSLIBInterop.jar to the BizTalk server

You need to repeat step 3 through 5 on each environment that BizTalk Server will connect to.

In some of the procedures, we use the following names for common J.D. Edwards environments:

Environment Name Description

JDEPLAN Common name for the planning environment.

DV7333 Common name for the development environment.

PY7333 Common name for the prototype environment.

PD7333 Common for name for the production environment.

DEP7333 Common for name for the deployment environment.

12

Page 13: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Installing Planner Update Electronic Software Update (ESU)You must perform this step on the deployment server. You can skip this step if the deployment server has got a planner update with SAR #4533357 already installed.

The planner update must be installed before installing the BTSREL application software update (ASU) provided by Microsoft. BizTalk Adapter for J.D. Edwards OneWorld XE requires SAR #4533357 in the planner update. The planner update gets superseded each time. You can install JD24819 or later that includes SAR #4533357.

To install the planner update ESU

1. Download the planner update that includes SAR #4533357 from J.D. Edwards - Update Center on the Oracle Web site.

2. Extract the planner update.

3. Run setup.exe, and follow the steps in the wizard.

After the planner update is installed, you need to complete the following steps:

1. Creating/updating the Internet Code Change ODBC data source

2. Copying the new Object Configuration Mappings to the Planner ODBC data source and the System ODBC data source

3. Copying control table information to the planner update Access database

4. Copying bitmaps to the planner update directory

Creating/Updating the Internet Code Change ODBC Data SourceThis step needs to be performed every time you install a new planner update on the deployment server.

Each planner update includes a Microsoft Office Access database. The database is in the <J.D. Edwards OneWorld XE installation folder>\<OneWorld XE version>\PLANNER\DATA directory. It is a requirement to have an ODBC data source called "Internet Code Change" pointing to the Access database on the deployment server. When the planner update is installed for the first time, you need to make sure that there is an ODBC data source with the name. Otherwise, you must create one through the ODBC Data Source Administrator from Administrative Tools. When you create the data source, you must choose Microsoft Access Driver (.mdb). For the subsequent planner update installations, you just need to re-map the data source to the appropriate Access database.

Copying New Object Configuration Mappings to the Planner ODBC Data Source and the System ODBC Data SourceThis step needs to be performed every time you install a new planner update on the deployment server.

This step copies the new object configuration mappings (OCM) into the Planner ODBC data source and the System ODBC data source.

13

Page 14: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

To copy new OCM mappings into the Planner ODBC data source and the System ODBC data source

1. Click Start, point to Programs, and click JDEdwards OneWorld to open J.D. Edwards OneWorld Explorer.

2. Log on to the JDEPLAN environment as user JDE, the default administrator account.

3. In the fast path box, enter P98305 (batch version), and then press Enter.4. In Batch Application, enter R98403 (report), and press Enter.5. Highlight version XJDE0029, and then click Processing Options on the left panel to

open the Processing Options dialog box.

6. In the Processing Options dialog box, click the Environment tab, and then enter the following values:

Processing Option Value

1 (The name of the planner environment, for example, JDEPLAN)

2 (Leave it blank)

3 2

4 Internet Code Change

5 (Leave it blank)

7. In the Processing Options dialog box, click the Update tab, and then enter the following values:

Processing Options Value

6 1

7 (Leave it blank)

8 (Leave it blank)

9 Y

8. In the Processing Options dialog box, click the Print tab, and then verify that option 10 is blank.

9. In the Processing Options dialog box, click the Licensing tab, and then verify that options 11 and 12 are blank.

10. In the Processing Options dialog box, click OK to close the dialog box.

11. Double-click XJDE0029 to run the version.

12. Select the Data Selection check box, and click OK to submit.

14

Page 15: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

13. Double-click XJE0029.

14. Select the Data Selection check box, and then click Submit menu button.

15. In the Data Selection dialog box, change Data Selection to:

Where ‘BC Object Name’ = F986101

16. Click OK to close the Data Selection dialog box. The Processing Options dialog box opens.

17. Click OK to close the Processing Options.

18. Double-click XJDE0029 to run the version again.

19. Highlight XJDE0029, and then click Processing Options on the left panel to open the Processing Options dialog box.

20. In the Processing Options dialog box, click the Environment tab, and then enter the following value:

Processing Option Value

1 (The name of the deployment environment, for example, DEP7333.)

21. In the Processing Options dialog box, click OK to close the dialog box.

22. Double-click XJDE0029 to run the version.

23. Select the Data Selection check box, and then click OK to submit.

24. Double-click XJE0029.

25. Select the Data Selection check box, and then click Submit menu button.

26. In the Data Selection dialog box, change Data Selection to:

Where ‘BC Object Name’ = F986101

27. Click OK to close the Data Selection dialog box. The Processing Options dialog box opens.

28. Click OK to close the Processing Options dialog box.

29. Double-click XJDE0029 to run the version again.

Copying Control Table Information to the Planner Update Access DatabaseThis step only needs to be performed once on the deployment server. You can skip it if you have already performed it during a previous planner update installation.

This step copies new Data Dictionary items and new Universal Data Connection (UDC) codes into the planner update Access database.

Note When you apply the planner update after installing J.D. Edwards OneWorld XE, you will see errors in jde.log indicating that you are trying to insert duplicate values into F0004

15

Page 16: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

and F0005. This is expected behavior, since you have already copied the new UDC values in this step.

To copy control table information to the planner update Access database

1. Double-click version XJDE0029.

2. Select the Data Selection check box, and then click the Submit menu button.

3. In the Data Selection dialog box, change Data Selection to:

Where BC Object Type = TBLE and BC Object Name = F0004 F0005 F9200 F9202 F9203

F9207 F9210

4. Click OK to close the Data Selection dialog box. The Processing Options dialog box opens.

5. In the Processing Options dialog box, click the Environment tab, and then enter the following values:

Processing Option Value

1 JDEPLAN

2 (Leave it blank)

3 2

4 Internet Code Change

5 (Leave it blank)

6. In the Processing Options dialog box, click the Update tab, and then enter the following values:

Processing Options Value

6 1

7 (Leave it blank)

8 (Leave it blank)

9 Y

7. In the Processing Options dialog box, click the Print tab, and then verify that option 10 is blank.

8. In the Processing Options dialog box, click the Licensing tab, and then verify that option 11 and option 12 are blank.

9. In the Processing Options dialog box, click OK to close the dialog box.

10. Click OK to run the report.

16

Page 17: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Copying Bitmaps to PlannerYou perform this step only once using the deployment server. You can skip it if you have already performed it during a previous planner update installation.

You need to copy all the bitmaps from the following folder: <J.D. Edwards OneWorld XE installation folder>\<OneWorld XE version>\PLANNER\Package\<current ESU version>\res folder to <J.D. Edwards OneWorld XE installation folder>\<OneWorld XE version>\PLANNER\res.

Installing BTSREL Application Software Update (ASU)You must perform this step needs on the deployment server.

BTSREL is a custom package, or an Application Software Update (ASU) in J.D. Edward terms. An ASU is a post-release update that provides software changes for specific purposes, such as regulatory changes or enhancements. It contains business functions to extract metadata and custom functions within J.D. Edward environments.

These ASUs are created for specific functionality. For example, BTSREL is created to extract metadata. When the BTSREL ASU is installed, it updates selected modules in the J.D. Edwards OneWorld XE environment. To update, BTSREL objects must be merged into the appropriate J.D. Edwards OneWorld XE environment.

You can download BTSREL from http://go.microsoft.com/fwlink/?LinkId=93673. You must install it on the deployment server which runs on a Windows operating system, and then deployed it to the enterprise server.

Note When applying the ASU to the deployment server, check the processing option to verify that you are in Update mode. The Proof mode verifies that there are no bugs in the ASU, whereas Update mode is for when you apply the ASU.

To install BTSREL on the deployment server

1. Log on to Windows on the deployment server as user JDE.

2. Create a new folder named BTSREL in the <J.D. Edwards OneWorld XE installation folder>\<OneWorld XE version> folder.

3. Copy BTSREL.exe to the newly created folder.

4. Run BTSREL.exe to start the J.D. Edwards OneWorld XE Installation Manager.

5. Click Next.6. Click Finish. After the installation finishes, a dialog box informs you if the installation was

successful.

Applying BTSREL ASU to J.D. Edwards OneWorld XE EnvironmentsThis step needs to be performed on the deployment server.

After BTSREL is installed on the deployment server, you must apply it to the environments where you want the update installed.

17

Page 18: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

To apply BTRREL ASU to a J.D. Edwards OneWorld XE environment

1. Log on to the JDEPLAN environment as user JDE on the deployment server.

2. In the fast path box, enter GH9612, and then press Enter.3. Double-click Application Software Update.

4. On the Work with Software Updates screen, double-click the BTSREL ASU to select BTSREL ASU, and then click Next menu button.

5. Double-click the environments where you want the update installed, and then click Next menu button.

a. If you want the software update to run in unattended mode, select the Unattended Workbench check box.

b. If you want the backup of the specifications (so that the original specifications can be restored), select the Backup check box.

6. Click Next to apply it to the environment. See the automatically generated PDFs for any errors that may occur after the installation is finished.

Note If errors occur, refer to the J.D. Edwards OneWorld XE Software Update Guide for troubleshooting tips, or contact J.D. Edwards OneWorld XE directly.

Creating and Building the BTSREL Custom Business Function Library ManuallyThis step needs to be performed on the deployment server.

Because of a limitation of the J.D. Edwards OneWorld XE product packaging process, you must manually register the custom Business Function Library DLL created by BTSREL with J.D. Edwards OneWorld XE. This process consists of the following three steps:

1. Creating the Custom Business Function Library

2. Building the library to create the DLL

3. Copying the Custom Business Function Library DLL

Step 1: Creating the BTSREL Custom Business Function LibraryUsing J.D. Edwards OneWorld XE Object Management Workbench (OMW), create the Custom Business Function Library. You must perform the following procedure on the initial setup.

To create the BTSREL custom business function library

1. Click Start, point to Programs, and then click JDEdwards OneWorld to open J.D. Edwards OneWorld Explorer.

2. Log on to the environment with which the BizTalk server will communicate, for example, DV7333, as user JDE.

3. In the fast path box, enter P98220 (OMW), and then press Enter.

18

Page 19: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

4. Click the Add menu button.

5. In the Object Librarian Objects area, click Business Function.

6. Enter the following information for the New Business Function Library Object:

Name Value

Name BTSLIB

Description Microsoft BizTalk JDE Adapter DLL

Product Code 55

Product System Code 55

7. Click OK.

Step 2: Building the Library to Create the DLLYou must perform the following procedure on the initial setup.

To create the dll

1. Click Start, and then click Run.

2. From the Run window, enter busbuild.exe, and then click OK. You are prompted to log on to J.D. Edwards OneWorld XE.

3. Log on to the J.D. Edwards environment where the BizTalk server will talk as user JDE.

4. Right-click BTSLIB from the function list, and then select Build.

5. In the output screen, verify that all DLLs have been built successfully.

Step 3: Copying the Custom Business Function Library DLLCopy the custom DLL from the path code directory to the parent package directories on the deployment server and on the enterprise server as follows:

To copy the custom DLLs by using the deployment server

1. Copy BTSLIB.dll from <J.D. Edwards OneWorld XE installation folder>\<OneWorld XE version>\<environment>\BIN32 to <J.D. Edwards OneWorld XE installation folder>\<OneWorld XE version>\<environment>\PACKAGE\<environment>FA\BIN32.

2. Copy BTSLIB.def, BTSLIB.dmp, and BTSLIB.mak from <J.D. Edwards OneWorld XE installation folder>\<OneWorld XE version>\<environment>\obj folder to <J.D. Edwards OneWorld XE installation folder>\< OneWorld XE version>\<environment>\PACKAGE\<environment>FA\obj folder.

3. Copy BTSLIB.exp, BTSLIB.lib, and sBTSLIB.lib from <J.D. Edwards OneWorld XE installation folder>\< OneWorld XE version>\<environment>\lib32 folder to <J.D.

19

Page 20: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Edwards OneWorld XE installation folder>\< OneWorld XE version>\<environment>\PACKAGE\<environment>FA\lib32 folder.

4. On the enterprise server, create a folder called BTSLIB under <J.D. Edwards OneWorld XE installation folder\<OneWorld XE version>\packages\DV7333FA\source folder. After the folder is created, verify the folder access authorization.

5. Copy b5500901.c from the <J.D. Edwards OneWorld XE installation folder\<OneWorld XE version>\DV7333\source directory on the deployment server to the <J.D. Edwards OneWorld XE installation folder\<OneWorld XE version>\packages\DV7333FA\source\BTSLIB directory on the enterprise server.

6. Copy b5500901.h from the <J.D. Edwards OneWorld XE installation folder\<OneWorld XE version>\DV7333\include directory on the deployment server to the <J.D. Edwards OneWorld XE installation folder\<OneWorld XE version>\packages\DV7333FA\include directory on the enterprise server.

Building and Deploying the Full PackageThis step needs to be performed on the deployment server.

The full package is mandatory to get the latest specifications of BTSREL ASU.

Because of a limitation of the J.D. Edwards package-build process, you must build a full package for each of the J.D. Edwards environments to which you applied the BTSREL ASU. Otherwise the update package build will not work correctly. For more information about building a full package, see the J.D. Edwards OneWorld XE documentation.

To build a full package

1. Log on to the J.D. Edwards deployment environment, for example, DEP7333, as user JDE on the deployment server.

2. In the fast path box, enter P9601, and then press Enter.3. In the Work With Packages screen, click Add.

4. In the Package Assembly Director screen, click Next.5. In the Package Information screen, enter the Package Name, Description, and Path

Code, and click Next.

Field Name Value

Package Name DV7333FC

Description DV7333 full package

Path Code DV7333

6. In the Package Type Selection screen, click Full, and then click Next.7. In the Foundation Component screen, click Next.

20

Page 21: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

8. In the Help Component screen, click Next.9. In the Database Component screen, click Next.10. In the Default Object Component screen, click Next.11. In the Features Component screen, click Next.12. In the Language Component screen, click Next.13. In the Package Component Revisions screen, click End.

14. In the Work with Packages screen, highlight the package, for example, DV7333FC, and then click Active/Inactive. The box icon in front of the package will change from an opened box icon to a closed box icon.

15. In the Work with Packages screen, highlight the package, for example, DV7333FC, and then click Define Build.

16. In the Package Build Definition Director screen, click Next.17. In the Package Build Location screen, select the Client check box and the Server

check box, and then click Next.18. In the Server Selection screen, select the enterprise server that you would like to build

the package for, and then click Next19. In the Build Specification Options screen, click Next.20. In the Business Function Options screen, clear the Clear Output Destination First

check box, and then click Next.21. In the Compression Options screen, click Next.22. In the Package Build Revisions screen, click End.

23. In the Work With Package Build Definition screen, highlight the package, for example, DV7333FC, and then click Active/Inactive.

24. In the Work With Package Build Definition screen, highlight the package, for example, DV7333FC, and then click Submit Build.

25. In the Report Output Destination screen, click On Screen, and then click OK. Two automatically generated PDFs (R9621 and R9622) appear on the screen. If there are any errors, you can check the jde.log build logs.

26. In the fast path box, enter GH9083, and then press Enter.27. Double-click Package Deployment.28. Enter the package name, and then click Find to find the package that you build.

29. Highlight the package, and then click Add menu button.

30. In the Package Deployment Director screen, click Next.31. Select the package, and then click Next.32. In the Package Deployment Targets screen, select both Client Workstation and

Enterprise Server, and then click Next.33. In the Package Deployment Attributes screen, select the Mandatory Installation

check box, and then click Next.

21

Page 22: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

34. In the Enterprise Server Selection screen, select the enterprise server name, and click Next.

35. In the Work with Package Deployment screen, click End.

36. Click Close.

37. In the fast path box, enter P9631, and then press Enter.38. Enter the package name, for example, DV7333FC, and then click Find to find the

package.

39. Expand the package, expand the enterprise server, select the build, and then click Active/Inactive.

40. Click Deploy to deploy the package on the enterprise server. A PDF file with the deployment status will open. You can check the PDF output to see whether the package installed successfully.

Creating BTSLIBInterop.jarOnce the BTSREL is installed, you need to generate the BTSLIBInterop.jar file on the deployment server, and copy this .jar file along with Kernel.jar and Connector.jar to the BizTalk server.

To generate BTSLIBInterop.jar

1. From a Command Prompt, change the directory to C root.

2. Include the path to javac by executing the following command with the appropriate path on the command prompt:

path=%path%;[Path to the JDK installation folder]\bin

3. Set the CLASSPATH environment variable to point to the Kernel.jar and Connector.jar files by executing the following command with the appropriate path on the command prompt:

Set CLASSPATH=[path to Kernel.jar]\Kernel.jar;[path to Connector.jar]\

Connector.jar

Important Do NOT include any spaces - especially around the equal sign and after the semicolon.

4. Create a text file named MSBTSLIB.cmd on the C root folder with the following text:

define library JDEJAVA_BTSLIB

login

library %library%

interface B5500901

import B5500901

build

22

Page 23: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

logout

5. Generate the BTSLIBInterop.jar by executing the following command:

C:\>genjava /Cmd MSBTSLIB.cmd /Out C:\MSGENJAVA /TempOut C:\MSGENJAVA /ErrFile

c:\MSGENJAVA\comerror.log

Enter UserID, password, and environment when prompt. The output should resemble the following:

MSGENJAVA\comerror.log

J.D.Edwards OneWorld XE(tm) Interoperability Interface Generator

Copyright (C) 1996-2000 J.D. Edwards World Source Company

All Rights Reserved.

BTSGetFunctionDefinition [D5500901A]

BTSGetFunctionList

BTSGetLibraryList

BTSGetObjectList

javac C:\MSGENJAVA\com\jdedwards\application\interop\btslib\*.java

javadoc -d C:\MSGENJAVA\com\jdedwards\application\interop\btslib\doc -sourcepath

C:\MSGENJAVA com.jdedwa

rds.application.interop.btslib >

C:\MSGENJAVA\com\jdedwards\application\interop\btslib\javadocoutput

see C:\MSGENJAVA\com\jdedwards\application\interop\btslib\javadocoutput for any

javadoc warning/error messages.

jar -cf C:\MSGENJAVA\JDEJAVA_BTSLIBInteropDoc.jar *

jar -cf C:\MSGENJAVA\JDEJAVA_BTSLIBInterop.jar BTSLIB.xml

com\jdedwards\application\interop\btslib\*.class.

You need to move the generated .jar file to the BizTalk server. The detailed steps are described in the next section.

Copying the BTSLIBInterop.jar File and the J.D. Edwards .JAR FilesYou must copy BTSLIBInterop.jar, Connector.jar and Kernel.jar to the BizTalk server. BTSLIBInterop.jar is created in the last step of the previous procedure with the following name: JDEJAVA_BTSLIBInterop.jar. It is located in the C:\MSGENJAVA\ folder on the deployment server. The other two J.D. Edwards .jar files are located in the <J.D. Edwards OneWorld XE installation folder>\System\classes\ folder of the deployment server.

You can copy these files to any location on the BizTalk server. You need to point to these files while creating send ports.

23

Page 24: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Installing the JDK 1.4.2 or Later on the BizTalk ServerDownload the JDK 1.4.2 or later from the Sun Microsystems Web site, and follow the instructions to install it on the BizTalk server.

Requirements for BizTalk ODBC Adapter for Oracle DatabaseWith BizTalk ODBC Adapter for Oracle Database, you can access stored procedures, tables, and views for Oracle databases that run on Oracle 8i or 9i or 10g databases. The interfaces are made available as schemas that you can use when Oracle database items are imported into BizTalk Server projects. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about Oracle database, see the documentation for the application.

Supported Operating SystemsBizTalk ODBC Adapter for Oracle Database runs on the following operating systems:

Microsoft Windows Server 2008

Microsoft Windows Server 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported Oracle Database VersionsBizTalk ODBC Adapter for Oracle Database supports the following Oracle Database versions:

Oracle Database 8i, 9i, 10g

Required ServersBizTalk ODBC Adapter for Oracle Database supports the following servers to install and configure the adapter:

BizTalk server

Required Components BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009

Oracle Client 9, 10

Oracle Driver 9.02.00.65 and above

Prerequisites for Installing BizTalk ODBC Adapter for Oracle DatabaseBefore installing the adapter on the BizTalk server, you must perform the following steps:

1. Installing the Oracle Client

2. Configuring a database connection

3. Upgrading the Oracle driver

24

Page 25: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Installing the Oracle ClientYou must have an Oracle Client installed on the BizTalk server to use BizTalk ODBC Adapter for Oracle Database. The adapter uses databases registered through the ODBC Data Source Administrator. The Oracle Client installation includes the Oracle ODBC driver, which must be updated to Oracle ODBC driver 9.02.00.65 and above after you install the client.

Note Oracle Client 9.2 only - The ODBC driver that is installed with the Oracle Client 9.2 contains a bug that prevents the enumeration of items that contain Japanese characters.

For the instructions on installing Oracle Client, see http://go.microsoft.com/fwlink/?LinkId=96008.

Configuring a Database ConnectionYou must set several ODBC variables before you can configure BizTalk ODBC Adapter for Oracle Database. For the instructions of configuring the database connection, see http://go.microsoft.com/fwlink/?LinkId=96012.

Upgrading Oracle DriverThe Oracle Client installation includes the Oracle ODBC driver, which must be updated to Oracle ODBC driver 9.02.00.65 and above after you install the client. For instructions on how to upgrade the Oracle driver, see http://go.microsoft.com/fwlink/?LinkId=96009.

Requirements for BizTalk ODBC Adapter for Oracle E-Business Suite

[This Oracle E-Business Suite has been removed in Microsoft BizTalk Server 2009]

BizTalk ODBC Adapter for Oracle E-Business Suite is a development and run-time environment for line-of-business process management and automation that enables you to reuse your existing Oracle E-Business Suite procedures and applications with other applications. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about Oracle E-Business Suite, see the documentation for the application.

Supported Operating SystemsBizTalk ODBC Adapter for Oracle E-Business Suite runs on the following operating systems:

Microsoft Windows Server 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported Oracle E-Business Suite VersionsBizTalk ODBC Adapter for Oracle E-Business Suite supports the following Oracle E-Business Suite versions:

25

Page 26: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Oracle E-Business Suite Application 11.5.10.2

Required ServersBizTalk ODBC Adapter for Oracle E-Business Suite requires the following servers to install and configure the adapter

BizTalk server

Required Components BizTalk Server 2006 or BizTalk Server 2006 R2

Oracle Client version 9 or 10

Oracle ODBC Driver version 9.02.00.65

Prerequisites for Installing BizTalk ODBC Adapter for Oracle E-Business SuiteBefore installing the adapter on the BizTalk server, you must perform the following steps on the BizTalk server:

1. Installing the Oracle Client

2. Configuring a database connection

3. Upgrading the Oracle driver

Installing the Oracle ClientYou must have an Oracle Client installed on the BizTalk server to use BizTalk ODBC Adapter for Oracle E-Business Suite. The adapter uses databases registered through the ODBC Data Source Administrator. The Oracle Client installation includes the Oracle ODBC driver, which must be updated to Oracle ODBC driver 9.02.00.65 after you install the client.

Note Oracle Client 9.2 only - The ODBC driver that is installed with the Oracle 9.2 client contains a bug that prevents the enumeration of items that contain Japanese characters.

For the instructions on installing Oracle Client, see http://go.microsoft.com/fwlink/?LinkId=96026.

Configuring a Database ConnectionYou must set several ODBC variables before you can configure BizTalk ODBC Adapter for Oracle E-Business Suite. For the instructions on configuring the database connection, see http://go.microsoft.com/fwlink/?LinkId=96029.

Upgrading Oracle DriverThe Oracle Client installation includes the Oracle ODBC driver, which must be updated to Oracle ODBC driver 9.02.00.65 after you install the client. For the instructions on upgrading Oracle driver, see http://go.microsoft.com/fwlink/?LinkId=96031.

26

Page 27: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Requirements for BizTalk Adapter for PeopleSoft EnterpriseBizTalk Adapter for PeopleSoft Enterprise enables you to communicate with PeopleSoft via the PeopleSoft JOLT protocol (over TCP/IP). This adapter is a send adapter. If you need to have PeopleSoft Enterprise to initiate the call to BizTalk Server, we recommend using the HTTP adapter. You must install a custom component interface (CI) on the PeopleSoft system in order for the BizTalk Adapter for PeopleSoft Enterprise to browse the component interfaces available and get the metadata to call into the existing component interfaces.

This section describes how to prepare the server before installing the adapter. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about PeopleSoft Enterprise, see the documentation for the application.

Supported Operating Systems BizTalk Adapter for PeopleSoft Enterprise runs on the following operating systems:

Microsoft Windows Server 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported PeopleSoft PeopleTools VersionsBizTalk Adapter for PeopleSoft Enterprise supports the following PeopleSoft PeopleTools versions:

PeopleTools 8.17.02, 8.43, 8.45, 8.46, 8.48 and 8.49

Required ServerBizTalk Adapter for PeopleSoft Enterprise requires the following servers to install and configure the adapter:

BizTalk Server

Required ComponentsBizTalk Adapter for PeopleSoft Enterprise requires the following components on the server where the adapter is installed:

BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009

Sun Microsystems Java Development Kit (JDK) 1.4.2 or later

Prerequisites for Installing BizTalk Adapter for PeopleSoft EnterpriseBefore installing BizTalk Adapter for PeopleSoft Enterprise, you must perform following steps:

For the instructions about how to use PeopleTools 8.17.02, see "Uploading a Custom Component Interface into PeopleSoft," later in this document.

For the instructions about how to use PeopleTools versions other than 8.17.02, see "Creating a New Component Interface," later in this document

27

Page 28: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Send Handler PeopleSoft RequirementsBizTalk Adapter for PeopleSoft Enterprise provides a GET_CI_INFO.pc. It is a custom component interface (CI) that you must upload to PeopleSoft system. It can provide metadata information that is required by BizTalk Adapter for PeopleSoft Enterprise. You must have access to the PeopleSoft Application Designer to deploy GET_CI_INFO.pc; however, the PeopleSoft Application Designer does not have to be on the BizTalk server.

Receive Handler PeopleSoft RequirementsThe BizTalk Adapter for PeopleSoft Enterprise is a send adapter only. To be able to receive calls from PeopleSoft Enterprise, you must use the BizTalk Server default HTTP adapter.

Uploading a Custom Component Interface into PeopleSoftBizTalk Adapter for PeopleSoft Enterprise requires a modification to the PeopleSoft application. To use component interfaces, you must upload GET_CI_INFO into PeopleSoft. GET_CI_INFO.pc is located in C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\PeopleSoft Enterprise(r)\Config\. The adapter uses GET_CI_INFO to obtain information about other existing component interfaces in PeopleSoft.

To import the custom component interface, you can use one of the following methods:

Creating a new component to import the custom methods.

Using an existing component that contains no keys, for example, INSTALLATION_RS.

Creating a New Component InterfaceThe following steps are performed on PeopleSoft Application Designer 8.1 and 8.4.

To create a component interface on Application Designer 8.1

1. Click Start, point to All Programs, point to PeopleSoft, and then select Application Designer.

2. Enter a three-tier connection type, and then click OK.

For example, select Application Server from the list.

3. On the File menu, click New.

4. In the New dialog box, select Component Interface, and then click OK.

In the Select Source Component for Component Interface window, select the component to use as a basis for the component interface, and then click Select.

Note The custom methods do not use or modify any properties of the component interface that they are installed in.

Note This simple component interface must not contain keys. If you are not sure

28

Page 29: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

whether a particular component interface contains keys, you can run the following simple SQL statement using your SQL Query tool. It will give you a list of all the component interfaces in your application that have no keys. To verify that your GET_CI_INFO has no keys, run the PeopleTools Application Designer Component Interface Test tool.

select distinct BCNAME

from PSBCITEM bc1

where not exists

(select 1

from PSBCITEM bc2

where bc1.BCNAME = bc2.BCNAME

and bc2.BCTYPE in (1, 2))

Note You can also follow PeopleSoft documentation to create a unique simple component for storing custom methods for BizTalk Adapter for PeopleSoft Enterprise.

5. On the File menu, click Save As.

6. In File Name, enter GET_CI_INFO, and then click OK.

7. Right-click any method of your new component interfaces, and then click View PeopleCode.

8. Copy and paste the contents of <PeopleSoft installation directory>\PeopleSoft Enterprise\config\get_ci_info.pc into the window.

9. On the File menu, click Save. You now have a new component interface.

To create a component interface on Application Designer 8.4

1. Click Start, point to All Programs, point to PeopleSoft, and then select Application Designer.

2. Enter a three-tier connection type, and then click OK.

For example, select Application Server from the list.

3. On the File menu, click New.

4. In the New dialog box, select Component Interface.

5. Select the component on which this Component Interface will be based on.

After you select the appropriate component, you see a message asking if you want the fields exposed in the selected component to become the default properties of the Component Interface.

Note Not all fields on the component interface can have automatic defaults created for

29

Page 30: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

them.

6. Click Yes to confirm the Default Property Definitions or No if you don’t want any properties initially created.

If you select to have the Property Definitions automatically defaulted by the system, then all properties that appear on the pages of the underlying component are added to the component interface. Even though the system adds the default properties, you may need to move other properties into the component view for the component to work.

An untitled Component Interface appears, showing the Get keys and Find keys. Create keys are produced only if the underlying component is able to run in Add mode (the example preceding this procedure does not have Create keys, because the search record of the underlying component cannot run in Add mode). PeopleSoft Application Designer generates the keys for you as you drag definitions.

The standard methods Cancel, Find, Get, and Save are automatically created. The Create method is not automatically created unless the component supports the Add mode.

Note You can begin adding properties to a new component interface at any point. However, you cannot add any user-defined methods to the component interface until you have saved the component interface.

7. On the File menu, click Save As.

8. In File Name, enter GET_CI_INFO, and then click OK.

9. Right-click any method of your new Component Interfaces, and then click View PeopleCode.

10. Copy and paste the contents of <PeopleSoft installation directory>\PeopleSoft Enterprise\config\get_ci_info.pc into the window.

11. On the File menu, click Save. You now have a new Component Interface.

Note Once you have saved the component interface, you can further define user-defined methods.

Checking the Component InterfaceYou have completed uploading the BizTalk Adapter for PeopleSoft GET_CI_INFO into your PeopleSoft System. The GET_CI_INFO is a user-defined custom component interface. It contains user-defined methods. The GET_CI_INFO component interface lets you browse component interfaces in your PeopleSoft system by using the BizTalk Add Adapter Wizard. You can locate and expand GET_CI_INFO to view its user-defined methods. For more information about user-defined methods, see http://go.microsoft.com/fwlink/?LinkId=96136.

30

Page 31: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Setting the Component Interface SecurityAfter you install the custom GET_CI_INFO PeopleSoft component interface on PeopleSoft, set the security settings for GetCINamespace, GetDetails, and GetCollections methods for BizTalk Adapter for PeopleSoft Enterprise. This is standard practice when you create custom components or user-defined methods.

Note The following procedure describes how to configure security for all supported releases of PeopleSoft in all supported modes.

To configure security for the component interface on Application Designer 8.1

1. Log on to the PeopleTools browser-based GUI.

2. From the menu, expand PeopleTools, and then click Security.3. From the Permissions & Roles category, click Permission Lists.

4. Click Search.5. In the Permission Lists Search pane, double-click the hyperlink of the relevant

Permission List.

6. Click the right arrow next to the Sign-on Times tab to display the Component Interfaces tab.

7. Click the Component Interfaces tab.

8. Click the Find hyperlink.

9. In the Explorer User Prompt dialog box, enter GET_CI_INFO in the text box, and then click OK.

10. From the Component Interfaces panel, click the Edit hyperlink for the GET_CI_INFO component interface.

11. To give the full access to all the methods, click Full Access (All), and then click OK.

12. Click Save.

To configure security for the component interface on Application Designer 8.4

1. Log on to the PeopleTools browser-based GUI.

2. From the menu, expand People Tools, expand Security, expand Permissions & Roles, and click Permission Lists.

3. Select the Permission List for which you want to set security.

The Permission List component appears.

4. Access the Component Interfaces page.

5. Select GET_CI_INTO, the Component Interface for which you want to set security, and then click Edit.The Component Interface Permissions page appears, showing all of the methods (both standard and user-defined) in the Component Interface and their method access.

31

Page 32: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

6. Set the access permission for each method.

Select Full Access or No Access. You must grant full access to at least one method to make the Component Interface available for testing and other online use.

7. Click OK.

8. Click Save.

Testing the Component InterfaceYou have finished configuring security for the GET_CI_INFO component interface delivered with BizTalk Adapter for PeopleSoft Enterprise. Your PeopleSoft component interface is ready, and you can browse PeopleSoft component interfaces.

Follow these steps to test the component interface in the Application Designer.

To test the component interface

1. Start Application Designer.

2. On the File menu, point to Open, and then select Definition = Component Interface.

3. From the list of component interfaces, select GET_CI_INFO.

4. After you open GET_CI_INFO, right-click anywhere in the right pane of your component interface definition, and then select Test Component Interface.

The Component Interface Tester window appears.

There should be no keys listed. If your GET_CI_INFO contains keys or if there is another option for selection, return to the Application Designer and eliminate all keys from GET_CI_INFO.

Requirements for BizTalk Adapter for Siebel eBusiness ApplicationsBizTalk Adapter for Siebel eBusiness Applications is a development and run-time environment for line-of-business process management and automation. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about Siebel eBusiness Applications, see the documentation for the application.

Supported Operating SystemsBizTalk Adapter for Siebel eBusiness Applications runs on the following operating systems:

Microsoft Windows Server 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported Siebel Platforms

32

Page 33: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

BizTalk Adapter for Siebel eBusiness Applications supports the following Siebel eBusiness Application versions:

Version 6.2.1 with patch 110 or later

Version 7.0.*

Version 7.5.*

Version 7.7

Version 7.8

Required ServersBizTalk Adapter for Siebel eBusiness Applications requires the following servers to install and configure the adapter:

BizTalk server

Required ComponentsBizTalk Adapter for Siebel eBusiness Applications requires the following components on the server where the adapter is installed.

BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009

Siebel software:

Version Components

Siebel, version 6.2.1 with patch 110 or later Siebel Thin Client Enterprise Component

Siebel Java Data Bean using the JDK 1.1.8 or the JDK 1.3

Note Patch 110 for version 6.2.1 resolves a memory leak on the Siebel server when you use any kind of remote client. You must follow all instructions in the patch 110 Maintenance Release Guide from Siebel Systems. Note that you can avoid the server side memory leak by specifying the Siebel server component parameter recyclefactor to a value greater than the default, zero. The guide recommends a value of 3. This improves server performance and memory usage. You must do this for all object managers that are being used.

33

Page 34: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Version Components

Siebel, version 7.0.3 Siebel Java Data Bean (using the JDK 1.1.8, JDK 1.3, or JDK 1.4)

Siebel, version 7.5.2 and 7.7 Siebel Java Data Bean (JDK 1.4)

Required FilesBizTalk Adapter for Siebel eBusiness Applications uses Siebel Object Interface API as implemented in the Siebel Java Data Bean. The following Siebel .jar files must be available to support the adapter:

34

Page 35: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Version Files

Siebel 6.2.1 SiebelTcOM.jar

SiebelTcCommon.jar

SiebelTC_%lang%.jar, where %lang% is the installed language pack; for example, SiebelJI_enu.jar is for English and SiebelJI_jpn.jar is for Japanese. You can install the .jar files through the Siebel Enterprise Server installation, or by installing Siebel Tools. For more information, see the Siebel documentation.

SiebelDataBean.jar

Siebel 7.0.3 and 7.5.2 SiebelJI_%lang%.jar, where %lang% is the installed language pack; for example, SiebelJI_enu.jar is for English and SiebelJI_jpn.jar is for Japanese. You can install the .jar files through the Siebel Enterprise Server installation, or by installing Siebel Tools. For more information, see the Siebel documentation.

SiebelJI_Common.jar

SiebelJI.jar

SBLJAccess.jar

Siebel 7.7 and Siebel 7.8 Siebel_%lang%.jar, where %lang% is the installed language pack; for example, SiebelJI_enu.jar is for English or SiebelJI_jpn.jar is for Japanese. You can install the .jar files through the Siebel Enterprise Server install, or by installing Siebel Tools. For more information, see the Siebel documentation.

Siebel.jar

SBLJAccess.jar

Note Excerpt from Siebel Knowledge Base 38-683408651: If you receive an 8859_1 not supported error, you must set your Java Virtual Machine (JVM) environment. The JVM encoding must match the Siebel FileEncoding setting. You must add this setting in the

35

Page 36: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Windows registry or systemsettings.txt file: Adapters/Siebel/Compatibility.FileEncoding: string = ISO8859_1

Requirements for BizTalk Adapter for TIBCO Enterprise Message ServiceBizTalk Adapter for TIBCO Enterprise Message Service enables you to publish and subscribe to queues and topics managed by TIBCO EMS by using BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about TIBCO EMS, see the documentation for the application.

Supported Operating SystemsBizTalk Adapter for TIBCO Enterprise Message Service runs on the following operating systems:

Microsoft Windows Server 2008

Microsoft Windows Server 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported TIBCO Enterprise Message Service VersionsBizTalk Adapter for TIBCO Enterprise Message Service supports the following TIBCO Enterprise Message Service versions:

TIBCO Enterprise Message Service (EMS) version 4.2, 4.4.3 and 5.0.0

Required ServersBizTalk Adapter for TIBCO Enterprise Message Service requires the following servers to install and configure the adapter:

BizTalk server

Required ComponentsBizTalk Adapter for TIBCO Enterprise Message Service requires the following components on the server where the adapter is installed:

BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009

TIBCO Enterprise Message Service client SDK as applicable (using the TIBCO EMS C# API)

EMS 4.2 Client SDK for EMS 4.2 Server Version

EMS 4.4.3 Client SDK for EMS 4.4.3 Server Version

EMS 5.0.0 Client SDK for EMS 5.0.0 Server Version

36

Page 37: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Requirements for BizTalk Adapter for TIBCO RendezvousBizTalk Adapter for TIBCO Rendezvous enables you to use TIBCO Rendezvous business functions within BizTalk Server. For more detailed information about the adapter, see the specific Help documentation for the adapter that is installed with BizTalk Adapters for Enterprise Applications. For information about TIBCO Rendezvous, see the documentation for the application.

Supported Operating SystemsBizTalk Adapter for TIBCO Rendezvous runs on the following operating systems:

Microsoft Windows Server 2008

Microsoft Windows Server 2003 R2

Microsoft Windows Server 2003 with Service Pack 1

Microsoft Windows 2000 with Service Pack 4

Microsoft Windows XP with Service Pack 2

Supported TIBCO Rendezvous VersionsBizTalk Adapter for TIBCO Rendezvous supports the following TIBCO Rendezvous versions:

TIBCO Rendezvous version 7.3, 7.4.5, 7.5.4 and 8.1.1

Required ServersBizTalk Adapter for TIBCO Rendezvous requires the following servers to install and configure the adapter:

BizTalk server

Required ComponentsBizTalk Adapter for TIBCO Rendezvous requires the following components on the server where the adapter is installed:

BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009

TIBCO Rendezvous run-time component

Other Requirements The TIBCO Rendezvous run-time component must be installed on the computer where

BizTalk Adapter for TIBCO Rendezvous is running.

The TIBCO Rendezvous license must be configured on the computer where BizTalk Adapter for TIBCO Rendezvous is running.

The TIBCO Rendezvous binaries directory must be visible to the adapter: either in the Environment variables PATH value, or specified on each Rendezvous port in BizTalk Server. This is necessary for the Rendezvous assembly to find its libraries and executables.

The TIBCO.Rendezvous.dll assembly must be registered in the global assembly cache (GAC) so that the adapter can find the DLL.

37

Page 38: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Requirements for BizTalk Adapter v2.0 for mySAP™ Business Suite Service Pack 1The Adapter requires that you install the following software on one computer, in the order listed:

1. Microsoft Windows Server 2003 R2, Microsoft Windows Server 2003 SP1 or Microsoft Windows 2000 Server SP4. You can also use Windows XP SP2 for your development environment only.

2. Microsoft Visual Studio 2005 or Microsoft Visual Studio 2008 SP1. This software is not required on your run-time computers.

3. BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009 and all prerequisites. For more information about installing BizTalk Server 2006 and its prerequisites, see the BizTalk Server installation guide at http://go.microsoft.com/fwlink/?LinkId=81041.

4. SAP .NET Connector for Visual Studio, available from the SAP Service Marketplace Web site.

5. You must install the SAP .NET Connector 1.x RUNTIME before installing the Adapter. You can download the SAP .NET Connector from the SAP Marketplace Web site. To download the SAP .NET Connector, you must be an SAP customer with a valid user name and password.

Installing BizTalk Adapters for Enterprise ApplicationsBefore running the Microsoft BizTalk Adapters for Enterprise Applications installation program, make sure that you install BizTalk Server 2006 or BizTalk Server 2006 R2 with Microsoft .NET Framework 1.1 with Service Pack 1, or Microsoft BizTalk Server 2009 with Microsoft .NET Framework 3.5 and all the software prerequisites for the adapters that you want to install. We recommend that you close all applications before running Setup.

Note The BizTalk Adapters for Enterprise Applications setup automatically detects previous versions of adapters and will upgrade the adapters, unless you specify otherwise.

To install Microsoft BizTalk Adapters for Enterprise Applications

1. Double-click setup.exe to run the installation program. The installation program extracts its files and the Introduction page appears.

Note You can also run a silent installation using the following command: msiexec /i <msi> /qn /l* <logfile> -- where <logfile> is optional, but is useful in the event of a failed installation.

Note The installation updates the PATH environment variable. To make sure that you

38

Page 39: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

are using the correct variables, close the installation command window to update your variables.

2. On the Introduction screen, click Next to continue. If you have a previous version of one or more adapters installed, confirm that you want to upgrade the adapter(s), and then click Next.

Note If you do not confirm that you want to upgrade your previously installed adapter(s), a message that you must manually uninstall previous versions of the adapter(s) appears and you exit the installation program.

3. On the End-User License Agreement screen, choose I accept the terms in the License Agreement, and then click Next.

Note If you select I do not accept the terms in the License Agreement, the installation program removes the extracted files and closes.

4. On the Customer Information screen, enter the User Name and the Organization, and then click Next.

5. On the Choose Setup Type screen, click Complete or Custom.

Complete: installs all the Microsoft BizTalk Adapters for Enterprise Applications together with all the program features and is used for development and runtime.

Custom: lets you choose the adapters and features that you want to install and where they will be installed.

6. On the Choose Destination Location screen, enter Location, and then click Next.7. On the Ready to Install screen, click Install. The installer loads files to your selected

location.

8. On the Install Complete page, click Finish.

After BizTalk Adapters for Enterprise Applications is installed, you must register each of the adapters to the BizTalk Management database. For information about how to add the adapters to BizTalk Server, see Adding the BizTalk Adapters for Enterprise Applications to BizTalk Server.

Installation Information for BizTalk Adapter for J.D. Edwards EnterpriseOneBizTalk Adapter for J.D. Edwards EnterpriseOne contains a send adapter that connects supported databases and server systems to BizTalk Server. The send adapter enables you to invoke a server system’s call from BizTalk Server. For more information about the adapter, see the adapter documentation.

39

Page 40: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Installed ComponentsThe BizTalk Adapter for J.D. Edwards EnterpriseOne installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.BizUtil.dll

Microsoft.BizTalk.Adapters.JDEProperties.dll

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

Microsoft.BizTalk.Adapters.JDEProperties.dll

You can verify the registration in the GAC by viewing the assembly folder in your explorer; for example, <%WINDIR%>\assembly, or use the following command from the Visual Studio command prompt:

gacutil /l

The adapter-specific files are installed in the Program Files\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin folder. This folder contains the following files:

Jdecba.dll

Microsoft.BizTalk.Adapters.JDEProperties.dll

The following files are installed in Program Files\Microsoft BizTalk Adapters for Enterprise Applications\JDEEnterpriseOne.

Bin\BTAJDEEnterpriseOneTrace.cmd

Classes\JDEDynAccess.jar

Config\btaJDEEnterpriseOneTrace.mof

Config\jdearglist.txt

Config\jdeinterop.ini

Config\jdelog.properties

Sdk

BizTalk Adapter for J.D. Edwards EnterpriseOne installation includes samples in the \Sdk directory.

Registering BizTalk Adapter for J.D. Edwards EnterpriseOne to the BizTalk ServerAfter the adapter is installed, you must register it to the BizTalk Management database before you can use it in send ports or receive ports. Registration needs to be performed only once on the BizTalk server or a server in the same BizTalk group with the BizTalk Server Administration console installed. For the detailed steps, see http://go.microsoft.com/fwlink/?LinkId=96111 or Adding the BizTalk Adapters for Enterprise Applications to BizTalk Server.

40

Page 41: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Enterprise Single Sign-OnBizTalk Adapter for J.D. Edwards EnterpriseOne provides Enterprise Single Sign-On (SSO) support. When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database; therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96112.

Creating Send Ports to Communicate with J.D. Edwards EnterpriseOne ServersThe adapter accepts XML messages to enable BizTalk applications to communicate and exchange transactions with J.D. Edwards EnterpriseOne by using static solicit-response send ports or static one-way send ports.

Prior to configuring the send ports, a J.D. Edwards CNC specialist or administrator needs to give BizTalk Server developer or administrator the following information:

J.D. Edwards Server name or IP address

J.D. Edwards environment information

TCP port

User name

Password

A BizTalk Server developer or administrator can set the connection and credential parameters that are specific to the J.D. Edwards server and the J.D. Edwards objects in the Transport Properties dialog box:

To create a static solicit response send port using the adapter

1. Click Start, point to Programs, point to Microsoft Visual Studio 2005/ Microsoft Visual Studio 2008, and then click Microsoft Visual Studio 2005/2008.

2. On the View menu, click BizTalk Explorer.3. From BizTalk Explorer, navigate to BizTalk Configuration Database|

<server>.BizTalkMgmtDb.dbo|Send Ports.

4. Right-click Send Ports, and select Add Send Port.5. From the Create New Send Port dialog box, select Static Solicit-Response Port, and

then click OK. The Send Port Properties window opens.

6. In the Name box, enter a send port name, for example, SendToJDE.

7. On the Transport Type list, select the BizTalk Adapter for J.D. Edwards EnterpriseOne adapter by the name you entered in the last procedure, for example, JDE EnterpriseOne.

8. On the Address(URI) property, click … to open the JDE EnterpriseOne Transport Properties dialog box.

9. Expand the Adapter Required Properties category, and then fill in all required information for connection to the J.D. Edwards EnterpriseOne server.

41

Page 42: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Mandatory settings are:

JAVA_HOME (if not set in the system environment); and

JDE environment.

Parameter Description

Host The name or the IP address of the J.D. Edwards server host.

JAVA_HOME

The complete path to the JDK installation folder.

JDEdwards Environment

The name of a J.D. Edwards EnterpriseOne environment, for example, DV810.

JDEdwards .jar files

The complete path and the file name for each of the .jar files:

From Tools Release 8.93 to 8.95: Connector.jar, Kernel.jar, database.jar, jdeutil.jar, log4j.jar, and xerces.jar

Tools Release 8.96: ApplicationAPIs_JAR.jar, ApplicationLogic_JAR.jar, Base_JAR.jar, BizLogicContainer_JAR.jar, BizLogicContainerClient_JAR.jar, Connector.jar, jdbj.ini, JdbjBase_JAR.jar, JdbjInterfaces_JAR.jar, jdeinterop.ini, jdelog.properties, JdeNet_JAR.jar, log4j.jar, PMApi_JAR.jar, Spec_JAR.jar, System_JAR.jar, xalan.jar, xerces.jar.

JDBC driver .jar files for the specific database, for example, msbase.jar, mssqlserver.jar, and msutil.jar for the Microsoft SQL Server 2000 JDBC driver.

JDEDynAccess.jar - installed with the product.

Each .jar file must be separated with a semi-colon (;) and no space. For example:

Tools Release Version

Files

JDE 8.94

C:\JDEJARS\895\database.jar

C:\JDEJARS\895\msbase.jar

C:\JDEJARS\895\mssqlserver.jar

C:\JDEJARS\895\msutil.jar

42

Page 43: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Parameter Description

Tools Release Version

Files

C:\JDEJARS\895\Connector.jar

C:\JDEJARS\895\kernel.jar

C:\JDEJARS\895\jdeutil.jar

C:\JDEJARS\895\log4j.jar

C:\JDEJARS\895\xerces.jar

C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\J.D. Edwards EnterpriseOne(r)\Classes\JDEDynAccess.jar

JDE 8.95

C:\JDEJARS\894\database.jar

C:\JDEJARS\894\msbase.jar

C:\JDEJARS\894\mssqlserver.jar

C:\JDEJARS\894\msutil.jar

C:\JDEJARS\894\Connector.jar

C:\JDEJARS\894\kernel.jar

C:\JDEJARS\894\jdeutil.jar

C:\JDEJARS\894\log4j.jar

C:\JDEJARS\894\xerces.jar

C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\J.D. Edwards EnterpriseOne(r)\Classes\JDEDynAccess.jar

JDE 8.96

C:\JDEJARS\896\ApplicationAPIs_JAR.jar

C:\JDEJARS\896\ApplicationLogic_JAR.jar

C:\JDEJARS\896\Base_JAR.jar

C:\JDEJARS\896\BizLogicContainer_JAR.jar

C:\JDEJARS\896\BizLogicContainerClient_JAR.jar

C:\JDEJARS\896\Connector.jar

C:\JDEJARS\896\jdbj.ini

C:\JDEJARS\896\JdbjBase_JAR.jar

C:\JDEJARS\896\JdbjInterfaces_JAR.jar

43

Page 44: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Parameter Description

Tools Release Version

Files

C:\JDEJARS\896\jdeinterop.ini

C:\JDEJARS\896\jdelog.properties

C:\JDEJARS\896\JdeNet_JAR.jar

C:\JDEJARS\896\log4j.jar

C:\JDEJARS\896\msbase.jar

C:\JDEJARS\896\mssqlserver.jar

C:\JDEJARS\896\msutil.jar

C:\JDEJARS\896\PMApi_JAR.jar

C:\JDEJARS\896\Spec_JAR.jar

C:\JDEJARS\896\System_JAR.jar

C:\JDEJARS\896\xalan.jar

C:\JDEJARS\896\xerces.jar

C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\J.D. Edwards EnterpriseOne(r)\Classes\JDEDynAccess.jar

Password The password of the specified J.D. Edwards user in the User name field. If you choose not to use SSO, you must set this parameter along with the User name parameter for the adapter to access the server.

Port The port number that is used to exchange data, for example, 6012.

User name The user name of the specified J.D. Edwards user. If you choose not to use SSO, you must set this parameter along with the Password parameter for the adapter to access the server.

When a connection is made to J.D. Edwards EnterpriseOne, parameters are passed to the connection object (User, Password, and Environment) and the connection object returns an instance of the J.D. Edwards EnterpriseOne Application business function. The credentials are further defined by the name of the enterprise application server, and the defined TCP/IP port on which BizTalk Server listens.

Note The default values for the enterprise server name and port are configured by BizTalk Server. They are also read from a file called jdeinterop.ini. If you receive

44

Page 45: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

logon errors, carefully check the credentials and values.

Important All entries are case-sensitive.

10. Expand the Bootstrap Data Source Required Properties category, and fill in all required information for connection to the J.D. Edwards EnterpriseOne server.

Bootstrap section information is used for sign-on to provide access to System tables. Bootstrap Data source information defines the data source where the Object Configuration Mapping (OCM) resides.

For the Bootstrap Data Source parameters, not all settings are needed for all platforms. If you are using an uncommon database, you might have to update the [JDBj-JDBC DRIVERS] section of the jdeinterop.ini file to declare your JDBC driver. The following identifies the required settings by platform:

iSeries: Data Source Name, Database Type, Database Server Name, Physical Database Name

Oracle: Data Source Name, Database Type, Database, Database Owner

SQL Server: Data Source Name, Database Type, Database Server Name, Database Server Port, Physical Database Name, Database Owner

SQL Server OLEDB: Data Source Name, Database Type, Database Server Name, Database Server Port, Physical Database Name, Database Owner

UDB: Data Source Name, Database Type, Database, Database Owner

Parameter Description

Data Source Name The database source name is in the jde.ini file located on the enterprise server. The .ini file is usually in the \\Machine_name\PeopleSoft\ddp\e810\System\Bin32 folder:

[SECURITY]

SecurityServer=BVISION02

User=PSFT

Password=PSFT

DefaultEnvironment=DV810

DataSource=System - 810

Default Role=*ALL

History=0

Database Owner The database owner is in the jde.ini file located on the enterprise server.

[DB SYSTEM SETTINGS]

45

Page 46: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Parameter Description

Version=43

Default User=PSFT

Default Pwd=PSFT

Default Role=*ALL

Default Env=DV810

Default PathCode=DV810

Base Datasource=BVISION02 - 810 Server Map

Object Owner=SVM810 — (Data Base Owner)

Server=BVISION02

Database=

Load Library=

Decimal Shift=Y

Julian Dates=Y

Use Owner=Y

Secured=Y

Type=L

Library=

Library List=

DatabaseName2=PS810

DatabaseInstance=

ServerPort=1433

JDBNETUse=N

UnicodeFlag=Y

LOBFlag=N

Database Server Name The database server name.

Database Server Port The database server port, for example, 1433.

Database Type The database type determines which kind of database is used:

Database Name Database Type

iSeries I

Oracle O

46

Page 47: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Parameter Description

Database Name Database Type

SQL Server S

SQL Server OLEDB L

UDB (for example, DB2)

W

Physical Database Name The physical database name is in the jde.ini file located on the enterprise server:

[DB SYSTEM SETTINGS]

Version=43

Default User=PSFT

Default Pwd=PSFT

Default Role=*ALL

Default Env=DV810

Default PathCode=DV810

Base Datasource=BVISION02 - 810 Server Map

Object Owner=SVM810

Server=BVISION02

Database=

Load Library=

Decimal Shift=Y

Julian Dates=Y

Use Owner=Y

Secured=Y

Type=L

Library=

Library List=

DatabaseName2=PS810 — (Physical Database)

DatabaseInstance=

ServerPort=1433

JDBNETUse=N

UnicodeFlag=Y

LOBFlag=N

47

Page 48: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

11. Expand the Concurrency control category, and enter a Concurrency Control value representing the number of calls in Max Concurrent Calls if required, for example, 200. The default value for this field is -1, meaning no protection occurs.

The Max Concurrent Calls parameter activates an overload protection if the back-end server cannot process the amount of data. A concurrent call means a request for which the adapter does not yet have a reply. Set Max Concurrent Calls in instances where the throughput exceeds back-end processing capabilities.

If BizTalk Server submits a request to the send adapter and the number of concurrent calls equals or exceeds the value set for Max Concurrent Calls, the thread submitting the request is saved until the concurrent calls number decreases to below the set value.

Changing this parameter takes effect within a minute as BizTalk Server must retrieve the changes to the adapter configuration saved in the SQL database.

12. Expand the Event Log category, and enter event log information. For the Event Log Level property, you can select Information, Error, or Warning. Logging at the Error or Warning levels captures important run-time information.

The Log provides information on the type of message: Error, Warning, or Information as well as a time stamp indicating when the action occurred. It also provides a brief description of the message and the process information indicating where the message originated.

13. Expand the Refresh Agent category. Select Yes for the Refresh Agent to force the runtimeagent.exe and the browsingagent.exe processes to restart themselves automatically when required. For example, you want the process to restart automatically if it loses connection with the server, or if you added something to the server and it does not appear in the BizTalk Add Adapter Wizard for selection.

Note The browsingagent.exe does not refresh until you terminate the current browsing session. For example, you must exit the “add generated item” browsing session and re-enter to refresh the browsingagent.exe.

14. Expand the Security Server category, and then enter the values for the Security Server parameter:

Parameter Description

Security Server - Security Server Name The name of J.D. Edwards EnterpriseOne host. You can use either the host name or the IP address.

Security Server - Service Name Connect The port number on which the J.D. Edwards EnterpriseOne is listening, for example, 6012.

48

Page 49: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

15. Expand the Use Single Sign-On category, enter Affiliate Application, and then set Use SSO to yes or no.

16. In the <Adapter name> Transport Properties dialog box, click OK to save the changes.

17. From the Static Solicit-Response Send Port Properties - Configurations - Transport - Primary dialog box, click Send from the left panel to configure the send pipeline.

18. In the Send Pipeline list, select the Microsoft.BizTalk.DefaultPipelines.XMLTransmit default pipeline. The BizTalk Adapter for J.D. Edwards EnterpriseOne requires that you select the default XMLTransmit pipeline for the send pipelines.

19. In the Receive Pipeline list, select the Microsoft.BizTalk.DefaultPipelines.XMLReceive default pipeline. The BizTalk Adapter for J.D. Edwards EnterpriseOne requires that you select the default XMLReceive pipeline for the receive pipelines.

20. Click OK to save the configuration.

The following is a sample J.D. Edwards EnterpriseOne Port configuration:

Description Sample Configuration

Host bpi118719

JAVA_HOME C:\Program Files\Java\jdk1.6.0

Environment DV812

.jar files C:\JDEJARS\896\ApplicationAPIs_JAR.jar

C:\JDEJARS\896\ApplicationLogic_JAR.jar

C:\JDEJARS\896\Base_JAR.jar

C:\JDEJARS\896\BizLogicContainer_JAR.jar

C:\JDEJARS\896\BizLogicContainerClient_JAR.jar

C:\JDEJARS\896\Connector.jar

C:\JDEJARS\896\jdbj.ini

C:\JDEJARS\896\JdbjBase_JAR.jar

C:\JDEJARS\896\JdbjInterfaces_JAR.jar

C:\JDEJARS\896\jdeinterop.ini

C:\JDEJARS\896\jdelog.properties

C:\JDEJARS\896\JdeNet_JAR.jar

C:\JDEJARS\896\log4j.jar

C:\JDEJARS\896\msbase.jar

C:\JDEJARS\896\mssqlserver.jar

C:\JDEJARS\896\msutil.jar

49

Page 50: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Description Sample Configuration

C:\JDEJARS\896\PMApi_JAR.jar

C:\JDEJARS\896\Spec_JAR.jar

C:\JDEJARS\896\System_JAR.jar

C:\JDEJARS\896\xalan.jar

C:\JDEJARS\896\xerces.jar

C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\J.D. Edwards EnterpriseOne(r)\Classes\JDEDynAccess.jar

Password JDE

Port 6014

User Name JDE

Data Source Name System - 812

Database Owner SY812

Database Server Name bpi118719

Database Server Port 1433

Database Type S

Physical Database Name JDE812

Security Server Name bpi118719

Service Name Connect 6014

Installation Information for BizTalk Adapter for J.D. Edwards OneWorld XEBizTalk Adapter for J.D. Edwards OneWorld XE consists of a send adapter that connects supported databases and server systems to BizTalk Server. The send adapter enables you to invoke a server system's call from BizTalk Server. For more information about the adapter, see the adapter documentation.

Installed ComponentsThe BizTalk Adapter for J.D. Edwards OneWorld XE installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.BizUtil.dll

Microsoft.BizTalk.Adapters.JDEProperties.dll

50

Page 51: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

You can verify the registration in the GAC by viewing the assembly folder in your explorer; for example, <%WINDIR%>\assembly, or by using the following command from the Visual Studio command prompt:

gacutil /l

The adapter-specific files are installed in the Program Files\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin folder. The folder contains the following files:

Microsoft.BizTalk.Adapters.JDEProperties.dll

jdecba.dll

The following files are installed in Program Files\Microsoft BizTalk Adapters for Enterprise Applications\JDEOneWorld:

Bin\BTAJDEOneWorldTrace.cmd

Classes\JDEJAccess.jar

Config\btaJDEOneWorldTrace.mof

Config\jdearglist.txt

Config\jdeinterop.ini

Sdk\

BizTalk Adapter for J.D. Edwards OneWorld XE installation includes samples in the \Sdk directory.

Registering BizTalk Adapter for J.D. Edwards OneWorld XE to the BizTalk ServerAfter the adapter is installed, you must register the adapter to the BizTalk Management database before you can use it in send ports or receive ports. This step only needs to be performed once on the BizTalk server or a server in the same BizTalk group with the BizTalk Server Administration console installed. For the detailed steps, see http://go.microsoft.com/fwlink/?LinkId=96113, or Adding the BizTalk Adapters for Enterprise Applications to BizTalk Server.

Enterprise Single Sign-OnBizTalk Adapter for J.D. Edwards OneWorld provides Enterprise Single Sign-On (SSO) support. When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database; therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96114.

51

Page 52: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Creating Send Ports to Communicate with J.D. Edwards OneWorld XE ServersThe adapter accepts XML messages to enable BizTalk applications to communicate and exchange transactions with J.D. Edwards OneWorld XE by using static solicit-response send ports or static one-way send ports.

Prior to configuring the send ports, a J.D. Edwards CNC specialist or administrator needs to give the BizTalk Server developer or administrator the following information:

J.D. Edwards Server name or IP address

J.D. Edwards environment information

TCP port

User name

Password

The BizTalk developer or administrator can set the connection and credential parameters that are specific to the J.D. Edwards server and the J.D. Edwards objects in the Transport Properties dialog box:

To create a static solicit response send port by using the adapter

1. Click Start, point to Programs, point to Microsoft Visual Studio 2005/2008, and then click Microsoft Visual Studio 2005/2008.

2. On the View menu, click BizTalk Explorer.3. From BizTalk Explorer, navigate to BizTalk Configuration Database|

<server>.BizTalkMgmtDb.dbo|Send Ports.

4. Right-click Send Ports, and then select Add Send Port.5. From the Create New Send Port dialog box, select Static Solicit-Response Port, and

then click OK. The Send Port Properties window opens.

6. In the Name list, type a send port name, for example, SendToJDE.

7. In the Transport Type list, select the BizTalk Adapter for J.D. Edwards OneWorld XE adapter by the name you entered in the last procedure, for example, JDE OneWorld.

8. On the Address(URI) property, click … to open the JDE OneWorld Transport Properties dialog box.

9. Expand the Adapter Required Properties category, and then fill in all required information for connection to the J.D. Edwards OneWorld XE server.

Mandatory settings are:

JAVA_HOME (if not set in the system environment)

JDE environment.

Parameter Description

Host The name or the IP address of the J.D. Edwards server

52

Page 53: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Parameter Description

host.

JAVA_HOME The complete path to the JDK installation folder.

JDEdwards Environment The name of the J.D. Edwards OneWorld XE environment, for example, DV7333, PY7333, PD7333

JDEdwards .jar files The complete path and the file name for each of the .jar files: Connector.jar, Kernel.jar, JDEJAccess.jar, BTSLIBInterop. Each .jar file must be separated with a semi-colon (;) and no space. For example:

C:\JDEJarFiles\Connector.jar;C:\JDEJarFiles\Kernel.jar;

C:\Program Files\Common Files\Microsoft BizTalk

Adapters for Enterprise Applications\J.D. Edwards

OneWorld\classes\JDEJAccess.jar;C:\JDEJarFiles

BTSLIBInterop.jar.

BizTalk Adapter for J.D. Edwards OneWorld XE provides the JDEJAccess .jar file for use with J.D. Edwards OneWorld XE.

Password The password of the specified J.D. Edwards OneWorld XE user specified in the User name field. If you choose not to use SSO, you must set this parameter along with the User name parameter for the adapter to access the server.

Port The port number of J.D. Edwards OneWorld XE that will exchange data, for example, 6009.

User name The user name of the specified J.D. Edwards OneWorld XE user. If you choose not to use SSO, you must set this parameter along with the Password parameter for the adapter to access the server.

When a connection is made to J.D. Edwards OneWorld XE, parameters are passed to the connection object (User, Password, and Environment) and the connection object returns an instance of the J.D. Edwards OneWorld XE Application business function. The credentials are further defined by the name of the enterprise application server, and the defined TCP/IP port on which BizTalk Server listens.

Note The default values for the enterprise server name and port are configured by BizTalk Server. They are also read from a file called jdeinterop.ini. If you receive logon errors, carefully check the credentials and values in the .ini file.

Note

53

Page 54: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

All entries are case-sensitive.

10. Expand the Concurrency control category, and enter a Concurrency Control value representing the number of calls in Max Concurrent Calls if required, for example, 200. The default value for this field is -1 meaning no protection occurs.

The Max Concurrent Calls parameter activates an overload protection if the back-end server cannot process the amount of data. A concurrent call means a request for which the adapter does not yet have a reply. Set Max Concurrent Calls in instances where the throughput exceeds back-end processing capabilities.

If BizTalk Server submits a request to the send adapter and the number of concurrent calls equals or exceeds the value set for Max Concurrent Calls, the thread submitting the request is saved until the concurrent calls number decreases to below the set value.

Changing this parameter takes effect within a minute as BizTalk Server must retrieve the changes to the adapter configuration saved in the SQL database.

11. Expand the Event Log category, and enter event log information. For the Event Log Level property, you can select Information, Error, or Warning. Logging at the Error or Warning levels captures important run-time information.

The log provides information on the type of message: Error, Warning, or Information as well as a time stamp indicating when the action occurred. It also provides a brief description of the message and the process information indicating where the message originated.

12. Expand the Refresh Agent category. Select Yes for the Refresh Agent to force the runtimeagent.exe and the browsingagent.exe processes to restart themselves automatically when required.

For example, you want the process to restart automatically if it loses connection with the server, or if you added something to the server and it does not appear in the BizTalk Add Adapter Wizard for selection.

Note The browsingagent.exe does not refresh until you terminate the current browsing session. For example, you must exit the “add generated item” browsing session and re-enter to refresh the browsingagent.exe.

13. Expand the Use Single Sign-On category, enter Affiliate Application, and then set Use SSO to yes or no.

14. In the <Adapter name> Transport Properties dialog box, click OK to save the changes.

15. From the Static Solicit-Response Send Port Properties - Configurations - Transport - Primary dialog box, click Send from the left panel to configure send pipeline.

16. In the Send Pipeline list, select Microsoft.BizTalk.DefaultPipelines.XMLTransmit default pipeline. The BizTalk Adapter for J.D. Edwards OneWorld XE requires that you select the default XMLTransmit pipeline for the Send pipelines.

17. I n the Receive Pipeline list, select Microsoft.BizTalk.DefaultPipelines.XMLReceive default pipeline. The BizTalk Adapter for J.D. Edwards OneWorld XE requires that you

54

Page 55: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

select the default XMLReceive pipeline for the receive pipelines.

18. Click OK to save the configuration.

Handling String ValuesThe following section describes how to configure certain string arguments as right-justified (and left padded). J.D. Edwards OneWorld XE exposes two kinds of string values through its interoperability layer:

char: a single character

maximum length string

You will also notice that J.D. Edwards OneWorld XE uses Hungarian notation to name the arguments of these types in the business functions. For example, arguments of these types will begin with:

c

sz

For a majority of sz type arguments, maximum length string or char array, J.D. Edwards OneWorld XE expects a left-justified value. For a street address line, which is of maximum length 40, J.D. Edwards OneWorld XE expects padding the length with blanks. For example:

"701 North Shoreline Blvd "

In the example, 40 blank spaces are padded. It is not necessary for you to enter the padding as the BizTalk Adapter for J.D. Edwards OneWorld XE provides this for you. For example, you only need to enter:

"701 North Shoreline Blvd"

For some subset of values for this type, J.D. Edwards OneWorld XE expects values that are right justified with padding on the left. For example, for business functions in the B4200310 source module, the argument szBusinessUnit is of length 12. This argument represents a Plant, such as a production facility. For a plant number of 30, J.D. Edwards OneWorld XE expects a value of:

" 30"

To enter a value that will be right-justified, you must enter the parameter into a file called jdearglist.txt. The jdearglist.txt is read at the time you generate the schema. Any value that is listed in this text file is automatically converted to a right-justified value and padded on the left with blanks. You must create jdearglist.txt, using a text editor, with entries describing these parameters. A sample of jdearglist.txt is available in the C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\J.D. Edwards OneWorld(r)\config folder. If this file does not exist, or is empty, you will see an informational message in the BizTalk Adapter v1.0 for J.D. Edwards OneWorld XE log when the BizTalk Adapter for J.D. Edwards OneWorld XE first loads.

Note If you change this file after generating your schema, you must re-generate the schema to refresh the data it contains. To verify that you are using the latest information in this file

55

Page 56: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

you can use Task Manager to stop the browsingagent.exe process before re-generating your schema, although this should not be necessary.

The following is an example of the format for entries in the jdearglist.txt file:

<SourceModule>.<BusinessFunction>.<Argument>

For example:

B4200310.F4211FSBeginDoc.szBusinessUnit

For a set of business functions belonging to the same business module, like-named arguments (of the same type) are shared across some or all of the business functions. You can use the wildcard character (*) instead of the business function name. For example:

B4200310.*.szBusinessUnit

Note When importing a J.D. Edwards OneWorld XE business process to another computer you must copy jdearglist.txt manually.

Installation Information for BizTalk ODBC Adapter for Oracle DatabaseBizTalk ODBC Adapter for Oracle Database contains a receive adapter and a send adapter that connect supported databases and server systems to BizTalk Server. The receive adapter listens for calls that are outbound from the server system. For more information about the adapter, see the adapter documentation.

Installed ComponentsBizTalk ODBC Adapter for Oracle Database installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.BizUtil.dll

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

You can verify the registration in the GAC by viewing the assembly folder in your explorer under <%WINDIR%>\assembly folder or use following command in the Visual Studio Command Prompt:

gacutil /l

The adapter specific files are installed in Program Files\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin. The following files are installed in Program Files\Microsoft BizTalk Adapters for Enterprise Applications\Oracle Database.

Bin\BTAOracleDBTrace.cmd

Config\btaOracleDBTrace.mof

Sdk\

56

Page 57: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

BizTalk ODBC Adapter for Oracle Database installation also includes samples in the \Sdk directory.

Registering BizTalk ODBC Adapter for Oracle Database to BizTalk ServerAfter the adapter is installed, you must register the adapter to the BizTalk Management database before you can use it in send ports or receive ports. This step only needs to be performed once on the BizTalk server or a server in the same BizTalk group with the BizTalk Server Administration console installed. For more information about registering an adapter, see http://go.microsoft.com/fwlink/?LinkId=96115.

Enterprise Single Sign-OnBizTalk ODBC Adapter for Oracle Database provides Enterprise Single Sign-On (SSO) support. When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database; therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96116.

Creating Send Ports and Receive Ports Using BizTalk ODBC Adapter for Oracle DatabaseFor more information about creating a send port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96117. For more information about creating receive ports with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96118.

Installation Information for BizTalk ODBC Adapter for Oracle E-Business Suite

[This Oracle E-Business Suite has been deprecated for Microsoft BizTalk Server 2009]

BizTalk ODBC Adapter for Oracle E-Business Suite contains a receive adapter and a send adapter that connect supported databases and server systems to BizTalk Server. The receive adapter listens for calls outbound from the server system. For more information about the adapter, see the adapter documentation.

Installed ComponentsBizTalk ODBC Adapter for Oracle E-Business Suite installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.BizUtil.dll

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

57

Page 58: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

You can verify the registration in the GAC by viewing the assembly folder in your explorer under <%WINDIR%>\assembly folder or use following command in the Visual Studio command prompt:

gacutil /l

The adapter-specific files are installed in Program Files\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin. The following files are installed in Program Files\Microsoft BizTalk Adapters for Enterprise Applications\Oracle E-Business Suite:

Bin\BTAOracleAppsTrace.cmd

Config\btaOracleAppsTrace.mof

Sdk\

BizTalk ODBC Adapter for Oracle E-Business Suite installation also includes samples in the \Sdk directory.

Registering BizTalk ODBC Adapter for Oracle E-Business Suite to BizTalk ServerAfter the adapter is installed, you must register the adapter to the BizTalk Management database before you can use it in send ports or receive ports. This step only needs to be performed once on the BizTalk server or a server in the same BizTalk group with the BizTalk Server Administration console installed. For more information about registering an adapter, see http://go.microsoft.com/fwlink/?LinkId=96119.

If you have already added the adapter to Microsoft BizTalk Server, you do not have to add the adapter again, and you do not have to connect to a database.

Enterprise Single Sign-OnBizTalk ODBC Adapter for Oracle E-Business Suite provides Enterprise Single Sign-On (SSO) support. When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database; therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96120.

Creating Send Ports and Receive Ports by Using BizTalk ODBC Adapter for Oracle E-Business SuiteFor more information about creating a send port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96121. For more information about creating a receive port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96122.

Installation Information for BizTalk Adapter for PeopleSoft EnterpriseBizTalk Adapter for PeopleSoft Enterprise contains a send adapter that connects supported databases and server systems to BizTalk Server. The send adapter enables you to invoke a

58

Page 59: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

server system’s call from BizTalk Server. The send adapter (the BizTalk Server Administration Send Handler) configuration specifies the location of the SQL Server database.

Installed ComponentsBizTalk Adapter for PeopleSoft Enterprise installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.BizUtil.dll

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

You can verify the registration in the GAC by viewing the assembly folder in your explorer under <%WINDIR%>\assembly folder or use following command in the Visual Studio Command Prompt:

gacutil /l.

The adapter-specific files are installed in Program Files\Common Files\ Microsoft BizTalk Adapters for Enterprise Applications\Bin. This folder contains the following files:

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

psosa.dll

The following files are installed in C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\PeopleSoft:

Bin\BTAPeopleSoftTrace.cmd

Config\btaPeopleSoftTrace.mof

Config\GET_CI_INFO.pc

Sdk\

BizTalk Adapter for PeopleSoft installation includes samples in the \Sdk directory.

Registering BizTalk Adapter for PeopleSoft to BizTalk ServerAfter the adapter is installed, you must register the adapter to the BizTalk Management database before you can use it in send ports or receive ports. This step only needs to be performed once on the BizTalk server or a server in the same BizTalk group with BizTalk Server Administration console installed. For more information about registering an adapter, see Adding the BizTalk Adapters for Enterprise Applications to BizTalk Server.

Enterprise Single Sign-onBizTalk Adapter for PeopleSoft provides Enterprise Single Sign-On (SSO) support. When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database;

59

Page 60: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96123.

Creating Send Ports and Receive Ports by Using BizTalk Adapter for PeopleSoftFor more information about creating a send port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96124. For more information about creating a receive port with the HTTP adapter, see http://go.microsoft.com/fwlink/?LinkId=96125.

Installation Information for BizTalk Adapter for Siebel eBusiness ApplicationsBizTalk Adapter for Siebel eBusiness Applications is a send adapter. You can use the adapter in a solicit-response send port to send a query and get a response back. If you only want to receive data from Siebel eBusiness Applications, you must follow these steps:

1. Create a custom receive pipeline using the Set Namespace pipeline component.

2. Create a receive port accessible from Siebel eBusiness Applications such as a port using the HTTP Adapter. You must configure the receive port to use the custom receive pipeline.

For more information about the adapter, see the adapter documentation.

Installed ComponentsBizTalk Adapter for Siebel eBusiness Applications installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.BizUtil.dll

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

You can verify the registration in the GAC by viewing the assembly folder in your explorer under <%WINDIR%>\assembly folder or by using following command in the command prompt:

gacutil /l

The adapter-specific files are installed in Program Files\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin. This folder contains the following files:

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

sblcba.dll

The following files are installed under Program Files\Microsoft BizTalk Adapters for Enterprise Applications\Siebel eBusiness Applications:

Bin\btaSiebelTrace.cmd

60

Page 61: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Classes\SBLJAccess.jar

Config\Siebel\btaSiebelTrace.mof

Sdk\

BizTalk Adapter for Siebel eBusiness Applications installation includes samples in the \Sdk directory.

Registering BizTalk Adapter for Siebel eBusiness Applications to BizTalk ServerAfter the adapter is installed, you must register the adapter to the BizTalk Management database before you can use it in send ports or receive ports. This step only needs to be performed once on the BizTalk server or a server in the same BizTalk group with the BizTalk Server Administration console installed. For more information about registering an adapter, see http://go.microsoft.com/fwlink/?LinkId=96126.

Enterprise Single Sign-onBizTalk Adapter for Siebel eBusiness Applications provides Enterprise Single Sign-On (SSO) support. When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database; therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96127.

Creating Send Ports and Receive Ports by Using BizTalk Adapter for Siebel eBusiness ApplicationsFor more information about creating a send port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96128. For more information about creating a receive port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96129.

Installation Information for BizTalk Adapter for TIBCO Enterprise Message ServiceBizTalk Adapter for TIBCO Enterprise Message Service (EMS) contains receive and send functionality that connect supported databases and server systems to BizTalk Server.

The receive side listens for calls that are outbound from the server system.

The transmit side enables you to invoke a server system’s call from BizTalk Server.

For more information about the adapter, see the adapter documentation.

Installed ComponentsBizTalk Adapter for TIBCO EMS installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.TibcoEMS.dll

61

Page 62: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Microsoft.BizTalk.Adapters.TibcoEMS.Properties.dll

You can verify the registration in the GAC by viewing the assembly folder in your explorer under <%WINDIR%>\assembly folder or by using the following command in the Visual Studio Command Prompt:

gacutil /l.

The adapter-specific files are installed in C:\Program Files\Common Files\ Microsoft BizTalk Adapters for Enterprise Applications\Bin folder. This folder contains the following files:

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

The following files are installed under C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\TIBCO(r) Enterprise Message Service(TM):

Bin\BTATibcoEMSTrace.cmd

Bin\Microsoft.BizTalk.Adapters.TibcoEMS.dll

Bin\Microsoft.BizTalk.Adatpers.TibcoEMS.Properties.dll

Config\btaTibcoEMSTrace.mof

Sdk\

BizTalk Adapter for TIBCO EMS installation includes samples in the \Sdk directory.

Registering BizTalk Adapter for TIBCO EMS to BizTalk ServerAfter the adapter is installed, you must register the adapter to the BizTalk Management database before you can use it in send ports or receive ports. This step only needs to be performed once on the BizTalk server or a server in the same BizTalk group with the BizTalk Server Administration console installed. For more information about registering an adapter, see Adding the BizTalk Adapters for Enterprise Applications to BizTalk Server.

Enterprise Single Sign-OnBizTalk Adapter for TIBCO EMS provides support for Enterprise Single Sign-On (SSO). When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database; therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96130.

Creating Send Ports and Receive Ports by Using BizTalk Adapter for TIBCO EMSFor more information about creating a send port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96131. For more information about creating a receive port with using the adapter, see http://go.microsoft.com/fwlink/?LinkId=96132.

62

Page 63: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

LimitationsBizTalk Adapter for TIBCO EMS uses TIBCO.EMS.dll to communicate with the server. The following are limitations when you use the TIBCO.EMS.dll:

Message compression, which enables the TIBCO EMS client to send messages in a compressed form to EMS, is not available.

Encryption of messages between the adapter and the server is not available. The TIBCO.EMS.dll does not allow for SSL encryption using the OpenSSL libraries.

Administration API for EMS is not supported.

Installation Information for BizTalk Adapter for TIBCO RendezvousBizTalk Adapter for TIBCO Rendezvous contains receive and send functionality that connects supported databases and server systems to BizTalk Server.

The receive side listens for calls that are outbound from the server system.

The transmit side enables you to invoke a server system’s call from BizTalk Server.

For more information about the adapter, see the adapter documentation.

Installed ComponentsBizTalk Adapter for TIBCO Rendezvous installer installs and registers the following components in the global assembly cache (GAC):

Microsoft.BizTalk.Adapters.TibcoRV

Microsoft.BizTalk.Adapters.TibcoRV.Common

Microsoft.BizTalk.Adapters.TibcoRV.Service

Microsoft.BizTalk.Adapters.TibcoRVManagement

Microsoft.BizTalk.Adapters.TibcoRVReceiver

Microsoft.BizTalk.Adapters.TibcoRVTransmitter

Microsoft.BizTalk.Adapters.TibRV.Properties

You can verify the registration in the GAC by viewing the assembly folder in your explorer; for example, <%WINDIR%>\assembly, or by using the following command from the Visual Studio command prompt:

gacutil /l

The adapter-specific files are installed in Program Files\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin. This folder contains the following files:

Microsoft.BizTalk.Adapters.CoreManagement.dll

Microsoft.BizTalk.Adapters.CoreReceiver.dll

Microsoft.BizTalk.Adapters.CoreTransmitter.dll

63

Page 64: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

The following files are installed in Program Files\Microsoft BizTalk Adapters for Enterprise Applications\TIBCO Rendezvous:

Bin\BTATibcoRVTrace.cmd

Bin\mbaRV.exe

Bin\Microsoft.BizTalk.Adapters.TibcoRV.Common.dll

Bin\Microsoft.BizTalk.Adapters.TibcoRV.dll

Bin\Microsoft.BizTalk.Adapters.TibcoRV.Service.dll

Bin\Microsoft.BizTalk.Adapters.BizUtil.dll

Bin\Microsoft.BizTalk.Adapters.TibcoManagement.dll

Bin\Microsoft.BizTalk.Adapters.TibcoReceiver.dll

Bin\Microsoft.BizTalk.Adapters.TibcoTransmitter.dll

Bin\Microsoft.BizTalk.Adapters.TibRV.Properties.dll

Config\btaTibcoRVTrace.mof

Sdk\

BizTalk Adapter for TIBCO Rendezvous installation includes samples in the \Sdk directory.

Registering BizTalk Adapter for TIBCO Rendezvous to BizTalk ServerAfter the adapter is installed, you must register the adapter to the BizTalk Management database before you can use it in send ports or receive ports. This step only needs to be performed once on the BizTalk server or a server in the same BizTalk group with the BizTalk Server Administration console installed. For more information about registering an adapter, see Adding the BizTalk Adapters for Enterprise Applications to BizTalk Server.

Enterprise Single Sign-OnBizTalk Adapter for TIBCO Rendezvous provides Enterprise Single Sign-On (SSO) support. When you use SSO with the adapter, the adapter obtains the credentials from the SSO Credentials database; therefore, you do not have to enter the logon credentials for the server system in the Transport Properties dialog box. For more information, see http://go.microsoft.com/fwlink/?LinkId=96133.

Creating Send Ports and Receive Ports by Using BizTalk Adapter for TIBCO RendezvousFor more information about creating a send port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96134. For more information about creating a receive port with the adapter, see http://go.microsoft.com/fwlink/?LinkId=96135.

64

Page 65: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Activating Tracing for all the AdaptersThe file name used with Windows tracing is up to the administrator. The application writes to the operating system, which ignores all logs until you want the logs for a particular back-end system. You do this by running a separate BizTalk Adapters for Enterprise Applications command file. One of the arguments for that command is the name of the file that will be used to capture the trace information. For more information, see the following section, "Using Windows Trace Event."

Trace files are installed in C:\Program Files\Microsoft BizTalk Adapters for Enterprise Applications\<adapter name>\, as follows:

Bin\BTA<adapter name>Trace.cmd

Config\bta<adapter name>Trace.mof

Using Windows Trace EventThe adapters log error, warning, and information messages to Windows Event Viewer. You can view additional tracing messages by using the Event Tracing for Windows (ETW) tool. When ETW is enabled, it creates an *.etl file to receive the messages. This file is in binary format and must be converted to be read. To do this, you must have a consumer application available to interpret the *.etl file, for example, Windows tracerpt.exe or tracedmp.exe.

ETW ComponentsEvent Tracing for Windows has three components:

Controller application: Activates and deactivates a provider, for example, tracelog.exe or logman.exe. You set your PATH environment variable to point to the location of tracelog.exe. This ensures that BTA<Adapter Name>Trace calls can locate tracelog.exe in the system. By default, BTA<Adapter Name>Trace searches the current path.

Note Tracelog.exe is available from the Windows 2000 Server Resource Kit Tools for Administrative Tasks and is compatible with the commands provided by Microsoft BizTalk Adapters for Enterprise Applications. To use logman.exe, see the logman documentation.

Consumer application: Reads logged events. For the consumer application to be able to read the event in the .etl file, Event Tracing for Windows must dump them into that file. Typically this is done when the controller deactivates the tracing.

To use the consumer application without deactivating the trace, the controller must activate the trace with the real-time option, <Real time> = -rt.

Provider: Used to provide the event. Each adapter includes five different providers. They are registered in Windows Management Instrumentation (WMI). To find the registered providers in the root\WMI\EventTrace path, you can use tools such as WMI CIM Studio.

The five providers enable you to log different kinds of messages:

Receiver Logging Provider: The <Trace element> switch is - receiver.

65

Page 66: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Receiver CastDetails Provider: The <Trace element> switch is - castDetailsReceive.

Transmitter Logging Provider: The <Trace element> switch is - transmitter. Transmitter CastDetails Provider: The <Trace element> switch is -

castDetailsTransmit. Management Logging Provider: The <Trace element> switch is - management.

To use ETW, run the command for the specific adapter, BTA<Adapter Name>Trace.cmd. You use this command as follows:

BTA<Adapter Name>Trace <Trace element> -start [-cir <MB>|

-seq <MB>] [-rt] logfile

BTA<Adapter Name>Trace <Trace element> -stop

Where:

<Trace element> (required) is the kind of provider. The options are as follows:

-castDetailsTransmit-transmitter-castDetailsReceive-receiver-management-start, -stop: Activate or deactivate the provider.

-cir <MB>: Size and kind of file. -cir is a circular file. <MB>: Size in megabytes.

-seq <MB>: Size and kind of file. -seq is a sequential file. <MB>: Size in megabytes.

-rt: Set the real-time mode on.

Logfile: Name of the log file (c:\rtlog.etl is the default).

For example:

BTA<adapter name>Trace -transmitter -start -cir 10 -rt c:\log\mylog.etl

BTA<adapter name>Trace -transmitter -stop

You use the tracerpt.exe command to format the .etl files.

Adding the BizTalk Adapters for Enterprise Applications to BizTalk ServerFollow these steps to add the Microsoft BizTalk Adapters for Enterprise Applications to BizTalk Server.

To register a new adapter

1. Click Start, point to Programs, point to Microsoft BizTalk Server 2006 or Microsoft BizTalk Server 2009, and then click BizTalk Server Administration.

2. Expand BizTalk Server Administration, expand BizTalk Group, expand Platform

66

Page 67: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

Settings, and then expand Adapters.

3. Right-click Adapters, point to New, and then click Adapter.4. Enter a Name for the adapter. For example, PeopleSoft.

5. From the Adapter list, select the adapter, and then click OK.

6. The prompt reads “This configuration changes requires host instance restart. Please restart the associated host instances for the changes to take effect." Click OK to finish the configuration.

7. From the BizTalk Server 2006/2009 Administration console, navigate to BizTalk Server 2006/2009 Administration -> BizTalk Group -> Platform Settings-> Host Instance.

8. Right-click BizTalkServerApplication, and then click Restart. BizTalkServerApplication is the default in-process host instance. If you assigned the adapter to a different host instance, you must restart that host instance instead.

CopyrightInformation in this document, including URL and other Internet Web site references, is subject to change without notice. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted in examples herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

© 2008 Microsoft Corporation. All rights reserved.

Microsoft, BizTalk, Excel, Windows, Windows Server, Windows Vista, and Visual Studio are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.

All other trademarks are property of their respective owners.

67

Page 68: Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications

68