1 - The page you requested cannot be displayed - IBM

ovalscissorsInternet και Εφαρμογές Web

30 Ιουλ 2012 (πριν από 4 χρόνια και 11 μήνες)

273 εμφανίσεις


Thursday, December 13, 2007

1

of
47



IBM WebSphere Adapter for

JD Edwards
EnterpriseOne
Quick Start Scenario V
6.1














Thursday, December 13, 2007

2

of
47



Table of Contents


1.0

Introduction

................................
................................

3

1
.1

Learning Objectives

................................
................................
................................
.......

3

1.2

Audience

................................
................................
................................
........................

3

1.3

Software prerequisites

................................
................................
................................
....

3

2.0

Preparing to run through the tutorial

...........................

3

2.1

Configuration prerequisites

................................
................................
............................

3

2.2

Extracting the sample files

................................
................................
.............................

4

3.0

Tutorial 1: Sending data to JD Edwards
EnterpriseOne AddressBook using a business
function(outbound processing)

................................
...........

6

3.1

Configuring the
adapter for outbound processing

................................
..........................

6

3.1.1

Creating the project
................................
................................
................................
....

6

3.1.2

Adding external software dependencies

................................
................................
....

8

3.1.3

Setting connection properties for the external service wizard

................................
...

9

3.1.4

Selecting the business objects and services to be used with the adapter

.................

10

3.1.5

Generating business object definitions and related artifacts

................................
....

16

3.2

Deploying the module to the test environment

................................
............................

24

3.3

Testing the assembled adapter application

................................
................................
...

25

3.4

Clearing the sample content

................................
................................
.........................

26

4.0

Tutorial 2: Retrieving data from JD Edwards
EnterpriseOne table using XML List query (outbound
processing)

................................
................................
........

27

4.1

Configuring the adapter for outbound processing

................................
........................

27

4.1.1

Creating the project
................................
................................
................................
..

27

4.1.2

Setting properties for the external service wizard

................................
...................

30

4.1.3

Selecting the business objects and services to be used with the adapter

.................

31

4.1.4

Generating business object definitions and related artifacts

................................
....

37

4.2

Deploying the module to the test environment

................................
............................

44

4.3

Testing the assembled adapter application

................................
................................
...

45

4.4

Clearing the sample content

................................
................................
.........................

45

5.0

Troubleshooting

................................
........................

45




Thursday, December 13, 2007

3

of
47

1.0

Introduction



The WebSphere Adapter fo
r JD Edwards EnterpriseOne 6.1

exchanges
in
formation with EnterpriseOne application via two types of JDE calls
-

Business Function calls and XML List calls.


To gain practical knowledge in setting up and deploying the adapter, complete
one or more of the tutorials. Everything you need to complete e
ach tutorial is
contained in the tutorial. If you have performed the prerequisite tasks, you
can complete each tutorial in under an hour.


1.1

Learning Objectives

After completing a

tutorial, you should be able to

perform the following tasks:



Create an adapter

project in We
bSphere Integration Developer.



Discover services and associated business objects from the enterprise
information system
(EIS)
and make the
m part of the adapter project
.



Create a deployable module that you install on WebSphere Process
Server o
r Web
Sphere Enterprise Service Bus
.



Test the module and
validate the
results.

1.2

Audience

These tutorials are for integration developers who design, assemble, test, and
deploy business integration solutions.

1.3

Software pre
requisites

To use these tutorials, you
must have the following applications installed
:




WebSphere Integration Developer version 6.1



WebShpere Process Server version 6.1



JD

E
dwards Enterprise Tools


2.0

Preparing to run through the tutorial


2.1

Configuration p
re
requisites

Before doing any tutorial test
ing, complete
the
following tasks:


The adapter requires the following libraries

which are supplied by Oracle
except the JDBC drivers for the database. They should be copied to a folder
on the system where the JD

E
dwards EnterpriseOne

EMD will be executed
.



8.9 (SP1,SP2), 8.93

8.94

8.95,8.96

kernel.jar

kernel.jar

Connector.jar


Thursday, December 13, 2007

4

of
47

connector.jar

Connector.jar

JdbjBase_JAR.jar

database.jar

database.jar

JdbjInterfaces_JAR.jar

log4j.jar

log4j.jar

JdeNet_JAR.jar

xerces.jar

xerces.jar

Spec_JAR.jar

xalan.jar

xa
lan.jar

System_JAR.jar

jdeinterop.ini

jdeutil.jar

Base_JAR.jar

jdeLog.properties

jdbj.ini

log4j.jar

JDBC driver

jdeinterop.ini

xerces.jar


jdelog.properties

xalan.jar


JDBC driver

PMApi_JAR.jar



BizLogicContainer_JAR.jar



BizLogicContainerClient_J
A
R.jar



ApplicationAPIs_JAR.jar



ApplicationLogic_JAR.jar



jdeinterop.ini



jdbj.ini



jdelog.properties



JDBC driver



2.2

Extracting the sample files

Replicas of the artifacts that you create when using the external service
wizard are provided as
sample files for your reference. Use these files to
verify that the files you create with the external service wizard are correct.


Go to
the

<WID_installation>
\
ResourceAdapters
\
JDE_6.1.0.0_IF01
\
samples
\
referencefiles

folder and unzip
Tutorial1
.zip
/Tutor
ial2.zip

into a directory of your choice (you
may want to create
a new directory
).


Tutorial1.zip

File name

Description

BusinessFunction
Sample
/

JDEOutboundInterface.import

Contains the SCA import for the
resource adapter.

BusinessFunction
Sample
/

GetEffec
tiveAddress.xsd

Business Object definition for the
GetEffectiveAddress business
function.

BusinessFunction
Sample
/

GetEffectiveAddressContainer.xsd

Business Object definition for the
business object container.

BusinessFunction
Sample
/

GetEffectiveAddressCo
ntainerBG.xsd

Business Object definition for the
business object graph.

BusinessFunction
Sample
/

JDEOutboundInterface.wsdl

Service interface to invoke the
resource adapter.

BusinessFunction
Sample

/

InvalidRequestFault.xsd

Fault Schema

BusinessFunction
Sam
ple

/

MatchesExceededLimitFault.xsd

Fault Schema

BusinessFunction
Sample

/

Fault Schema


Thursday, December 13, 2007

5

of
47

MissingDataFault.xsd

BusinessFunction
Sample

/

PrimaryKeyPairType.xsd

Fault Schema

BusinessFunction
Sample

/

RecordNotFoundFault.xsd

Fault Schema

BusinessFunction
Sampl
e

/

WBIFault.xsd

Fault Schema



Tutorial2
.zip

File name

Description

XMLList
Sample
/

JDEOutboundInterface.import

Contains the SCA import for the
resource adapter.

XMLList
Sample
/

JDEOutboundInterface.wsdl

Service interface to invoke the
resource adapter.

XMLList
Sample
/

F0116.xsd

Business Object definition for the
F0116 table

XMLList
Sample
/

F0116Container.xsd

Business Object definition for the
business object container

XMLList
Sample
/

F0116ContainerBG.xsd

Business Object definition for the
business object
graph.

XMLList
Sample
/

F0116Query1.xsd

Business Object definition for the
query on F0116 table

XMLList
Sample
/

F0116Query1BG.xsd

Business Object definition for the
business object graph.

XMLList
Sample
/

InvalidRequestFault.xsd

Fault Schema

XMLList
Sample
/

MatchesExceededLimitFault.xsd

Fault Schema

XMLList
Sample
/

MissingDataFault.xsd

Fault Schema

XMLList
Sample
/

PrimaryKeyPairType.xsd

Fault Schema

XMLList
Sample
/

RecordNotFoundFault.xsd

Fault Schema

XMLList
Sample
/

WBIFault.xsd

Fault Schema


Thursday, December 13, 2007

6

of
47

3.0

Tutorial

1:
S
e
nding data to
JD Edwards

EnterpriseOne

AddressBook using a business
function
(outbound processing)


This

tutorial

demonstrates how

WebSphere Adapter for

JD Edwards

EnterpriseOne 6.1

uses the GetEffectiveAddress business function to retrieve
a record from
the AddressBook.




3.1

Configuring the adapter for
outb
ound processing

Run
the external service wizard to specify business objects, services, and
configuration to be used in this tutorial.

3.1.1

Creating the project


1.

Switch to the Business Integration Perspective
in WebSphere
Integration Developer by choosing from the menu: Window
-
> Open
Perspective Business Integration.

2.

Start the
external service wizard

by choosing: File
-
> New
-
> External
Service


Thursday, December 13, 2007

7

of
47

3.

Select Adapters radio button then click Next

Figure 1
.

4.

From the

Select an Adapter window, you can either create a new
project or select an existing project.




To create a new project, perform the following steps:

a.

Select
IBM WebSphere Adapter for JD Ed
wards
EnterpriseOne (IBM : 6.1
)
, as shown in the following figure.


Thursday, December 13, 2007

8

of
47


Figure 2
.

b.

Click
Next
.

c.

In the Adapter Import window, either accept the default name for
the project (
CWYED_JDE
) or provide another name in the
Connector project
field, select the server from the
Target
runtime
list (for example,
WebSphere Process Server
v6.1
),
then click
Next
.



To select an existing project, perform the following steps:

a.

Expand
IBM WebSphere Adapter for JD Ed
wards
EnterpriseOne (IBM : 6.1
)
.

b.

Select a project. For example, if you have an existing project
named CWYED_JDE, you can expand
IBM
WebSphere Ada
pter
for JD Edwards (IBM : 6.1
)CWYED_JDE
, then select the
connection information you used to create the project.

c.

Click
Next
.

3.1.2

Adding external software dependencies


1.

In the Version property, select the version of EnterpriseOne what will
be used
. Using the “Folder containing the required files” property,
specify the folder from which to import the
files required to connect to
EnterpriseOne. Using the “JDBC Libraries” property, specify the
required JDBC driver files.

Thursday, December 13, 2007

9

of
47


Figure 3
.

2.

Click Next



3.1.3

Setti
ng
connection
properties for the
external service

wizard


To connect to JD Edwards EnterpriseOne the following information is necessary:
username, password, environment and role. Provide this information in the next
wizard page.

Then click Next.



Thursday, December 13, 2007

10

of
47


Figure
4
.

3.1.4

Selecting the business objects and services to be used with the
adapter


Follow these steps to select the GetEffectiveAddress business object:


1.

In the
Object

Discover
y and Selection

screen, c
lick the
Run

Query
button
.


Thursday, December 13, 2007

11

of
47


Figure 5
.


2.

In the “
Discovered obj
ects
” list, s
elect

the

Business Functions

node and
expand it
.

Use of the Filter icon may be
helpful as the list can be long.


Thursday, December 13, 2007

12

of
47


Figure 6
.


3.

Select the
CFIN

node and expand it
.


Thursday, December 13, 2007

13

of
47


Fi
gure 7
.


4.

Select the
B0100033

node and expand it
.


Thursday, December 13, 2007

14

of
47


Figure 8
.


5.

Select the
GetEf
fectiveAddress

node
.


Thursday, December 13, 2007

15

of
47


Figure 9
.


6.

Click the
>

Add

button
.


Figure 10
.



Thursday, December 13, 2007

16

of
47

7.

Use the default business object name
GetEffectiveAddress

and click the
OK

button.



Figure 11
.


8.

Click the
NEXT>
.


3.1.5

Generating business object definitions and related artifacts

Follow t
hese steps to generate the business object definitions
.


1.

In the Configure
Composite Properties

screen, u
se the default values

for the
Namespace, Relative Path, and Max Records fields.



Thursday, December 13, 2007

17

of
47


Figure 12
.


2.

Check the
Add c
ontainer
business object

checkbox
.



Thursday, December 13, 2007

18

of
47


Figu
re 13
.


3.

Fill the Container
business o
bject name field with
GetEffectiveAddressContainer
.

4.

Click the
Add

button next to the Business Functions for Retrieve list
.

5.

In the Add screen that appears, select

GetEffectiveAddress

, leaving the Value
field empty, the
n click
OK
.



Thursday, December 13, 2007

19

of
47


Figure 14
.


6.

Click the
NEXT>
.

7.

On the Service Generation and Deployment Configuration screen enter the
connection information. Click next

Thursday, December 13, 2007

20

of
47


Figure 15
.

8.

In the
Service Location Properties

screen, click the
New

button next to the
Module field to
create a new module.



Thursday, December 13, 2007

21

of
47


Figure 16


9.

T
he New Integration

Project

screen appears, select
Create a module
project
, then click
Next


Thursday, December 13, 2007

22

of
47


Figure 17


10.

In the New Module screen, type
BSFNSample

in the Module Name field, then
click
Finish
.



Thursday, December 13, 2007

23

of
47


Figure 18



11.

Click
Finish.

12.

Verify the results.




Thursday, December 13, 2007

24

of
47


Figure
19
.


3.2

Deploying the module

to

the
test environment


The result of running

the

external service

wizard

is an SCA module that
con
tains an EIS import or export.
Install this SCA modul
e in

WebSphere
Integration Developer integrati
on test client
.


1.

Add the

module you created earlier to the server usi
ng the
se
rver

panel in
W
ebSphere Integration Developer
.
Right
-
click on the server,
and
then
sele
ct

Add
and

remove projects
.


Thursday, December 13, 2007

25

of
47

Demonstrate this
process.


Figure
20.

2.

Add the SCA module to
the server.

3.

Click Finish


3.3

Testing the assembled adapter
application



Test the assembled adapter application using the
WebSphere Integration
Developer integration test client
.



1.

Select the service you want, and
click
Test > Test Module
.

2.

Populate value
s for input business objects.


Populate the
Mna
ddressnumber

attribute of the
GetEffectiveAddress

business object, with the value 33937.


Thursday, December 13, 2007

26

of
47


Figure 21
.

3.

Execute the service
by clicking the continue button

4.

Check the output of the service, and check the data
in the EIS to ensure it
matches expected values.

3.4

Clearing

the
sample content

Re
turn the data to its original state.



Nothing is required to clean up after this
tutorial
.


Thursday, December 13, 2007

27

of
47

4.0

Tutorial

2
:

Retrieving data from

JD Edwards

EnterpriseOne
table using XML List q
uery
(outbound processing)


This tutorial demonstrates how

WebSphere Adapter for

JD Edwards

EnterpriseOne 6.1

uses an XML List query to retrieve a record from the
AddressBook database.



4.1

Configuring the adapter for out
bound processing

Run
the external ser
vice wizard to specify business objects, services, and
configuration to be used in this tutorial.

4.1.1

Creating the project


1.

Switch to the Business Integration Perspective in WebSphere
Integration Developer by choosing from the menu: Window
-
> Open
Perspective
Business Integration.

2.

Start the
JD Edwards

EnterpriseOne EMD by choosing: File
-
> New
-
>
External Service


Thursday, December 13, 2007

28

of
47

3.

Select Adapters radio button then click Next

Figure 22
.

4.

Expand the “IBM WebSphere Adapter for JD E
dwards EnterpriseOne
(IBM: 6.1
). Select the CWYED
_JDE node and click Next.

Thursday, December 13, 2007

29

of
47


Figure 23
.

5.

In the Version property, select the version of EnterpriseOne what will
be used. Using the “Folder containing the required files” property,
specify the folder from which to import the files required to connect to
Enter
priseOne. Using the “JDBC Libraries” property, specify the
required JDBC driver files.

Thursday, December 13, 2007

30

of
47


Figure 24
.

6.

Click Next



4.1.2

Setting properties for the
external service

wizard


To connect to JD Edwards EnterpriseOne the following information is necessary:
username, pa
ssword, environment and role. Provide this information in the next
wizard page.

Then click Next.



Thursday, December 13, 2007

31

of
47


Figure 2
5
.


4.1.3

Selecting the business objects and services to be used with the
adapter

Follow these steps to select the F0116 data using JDE XML List query:


1.

Edit Query Properties by adding table name F0116
. The following steps
describe how to do this:

a.

In the
Object
Discover
y and Selection

screen, click
Edit Query
.



Thursday, December 13, 2007

32

of
47


Figure 26


b.

In the Query Filter Properties screen, click the
Add

button next to the
Tables list
.


Figure 27



Thursday, December 13, 2007

33

of
47

c.

In the Add screen that appears, type
F0116
, then click
OK
. F0116
appears in the Tables list.




Figure
28


d.

Click
OK

to close the Query

Properties screen.

2.

In the
Object Discovery and Selection

screen, c
lick the
Run

Query
button
.


Figure
2
9



3.

Expand XML List node, select F0116 node and click >

Add button to select
object for importing into the service description
.


Thursday, December 13, 2007

34

of
47


Figure 30


4.

Configure XML List query business object for import into the service
description.


a.

Select OWTABLE from the Table t
ype list.


Thursday, December 13, 2007

35

of
47


Figure 31


b.

Check box Add Condition.





Thursday, December 13, 2007

36

of
47


Figure 32


c.

Set Attribute to Addressnumber

d.

Press OK.


The configured query business object should be imported.

Click
NEXT>
.


Thursday, December 13, 2007

37

of
47


Figure 33


4.1.4

Generating business object definitions and related artifacts


Follo
w these steps to generate the business object definitions.


1.

In the Configure Composite Properties

screen, u
se the default values.



Thursday, December 13, 2007

38

of
47


Figure 34


2.

Click the
NEXT>
.

3.

On the Service Generation and Deployment Configuration screen enter the
connection information.

Click next

Thursday, December 13, 2007

39

of
47


Figure 3
5

4.

In the Service Location Properties screen, click the
New

button next to the
Module field to create a new module.



Thursday, December 13, 2007

40

of
47


Figure 3
6


5.

T
he New Integration Project screen appears, select
Create a module
project
, then click
Next


Thursday, December 13, 2007

41

of
47


Figure 3
7


6.

In the New Module screen, type
XMLList
Sample

in the Module Name field,
then click
Finish
.



Thursday, December 13, 2007

42

of
47


Figure 38




7.

Click
Finish.

8.

Verify the results.



Thursday, December 13, 2007

43

of
47


Figure
39



Thursday, December 13, 2007

44

of
47

4.2

Deploying the
module

to the test environment

After

running
the external service wizard, you will have
an SCA module that
con
tains
an EIS import or export. Y
ou must i
nstall this SCA module in the
WebSphere Integration Developer integration

test
client
.


1.

Add the SCA module
to the server using the server

panel in
WebSphere
Integration Developer
.
Right
-
click

on the server,
and
select
Add and
remove projects
.



Figure 40
.

2.

Add the SCA module to the server.

3.

Click Finish





Thursday, December 13, 2007

45

of
47

4.3

Testing the assembled adapter
application


Test the assembled adapter application using the WebSphere Integration
Developer integration te
st client.



1.

Select the service you want, and click
Test > Test Module
.

2.

Populate values for input business objects.

3.

Populate the
Addressnumber

attribute of the
F0116Query1

business object,
with the value 33937.

Figure 4
1

4.

Execute the service by clic
king the continue button

5.

Check the output of the service, and check the data in the EIS to ensure it
matches expected values.


4.4

Clearing the sample content

R
eturn the data to its original state.




Nothing is required to clean up after this
tutorial
.


5.0

T
roubleshooting




Thursday, December 13, 2007

46

of
47

1.

Symptom
: A

SpecFailureException

exception is thrown from EMD or at runtime:


Caused by: com.jdedwards.system.connector.dynamic.spec.SpecFailureException: Cannot connect
to Oneworld Spec Source:Data Source not found in Oneworld Database Da
ta source for F9860,
TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource
SY812.)


at
com.jdedwards.system.connector.dynamic.spec.source.OneworldBSFNSpecSource.<init>(Unknown
Source)


at com.ibm.j2ca.jde.outbound.bsfn.JDEGet
SpecSource.run(JDEGetSpecSource.java:36)


at java.security.AccessController.doPrivileged(AccessController.java:241)


... 9 more


Cause: This is usually caused by configuration issues


Resolution
:

1.

Verify that the appropriate JDBC driver is in the class

path

2.

Verify the JDE configuration files (jdbj.ini, jdeinterop.ini,
jdeLog.properties, tnsnames.ora) are configured correctly for the JDE
server being used and that they are in the class

path.

3.

Verify that the JDE server to which you are trying to connect and al
l
services are started correctly.

4.

Verify that the required JDE

files
have been imported and added to the
class

path.



2.

Symptom
:
A ServerFailureException

exception is thrown from EMD or at runtime:


Caused by: com.jdedwards.system.connector.dynamic.ServerF
ailureException: Cannot connect to
any OneWorld Security Server.FAILURE: null


at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)


at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)


at com.ibm.j2ca.jde.out
bound.JDEConnectionProperties.run(JDEConnectionProperties.java:63)


at java.security.AccessController.doPrivileged(AccessController.java:242)


... 23 more

doPrivileged(AccessController.java:241)


... 9 more


Cause: This is usually caused by configuration i
ssues


Resolution
:

1.

Verify that the appropr
iate JDBC driver is in the class
path

2.

Verify the JDE configuration files (jdbj.ini, jdeinterop.ini,
jdeLog.properties, tnsnames.ora) are configured correctly for the JDE
server being used and that they are in the
c
lass
path.

3.

Verify that the JDE server to which you are trying to connect and all
services are started correctly.

4.

Verify that the required JDE files

have been

imported and added to the
class
path.


3.

Symptom
: Error received attempting to connect to JDE with E
MD

Resolution
:

Verify that the connection parameters have been entered correctly

4.

Symptom
: There are no tables listed in the tree view under XML Lists

Resolution
:

Verify that table names have been added to the ‘Tables for XML List Table
Names’ property in
the Query Filter Properties window


Thursday, December 13, 2007

47

of
47

5.

Symptom
: On Business Object Properties window, error indicating invalid
characters in BO Name

Resolution
:

Follow instructions in message and remove invalid characters from BO name

6.

Symptom
: On Business Object Properties wi
ndow, error indicating unable to
retrieve table column information

Resolution
:

Verify correct table name, table type and table conversion version have been
entered