200 WebSphere Business Integration Adapters
As an example, a high-level API call to create a new record in a database table
might evaluate the input data against a range of values, or it might update
several associated tables as well as the specified table. Using SQL statements to
write directly to the database, on the other hand, might bypass the data
evaluation and related table updates performed by an API.
If no API is provided, the application might allow its clients to access its database
directly using SQL statements. If you use SQL statements to update application
data, work closely with someone who knows the application well so that you can
be sure that your connector will not bypass application business logic. This
aspect of the application has a major impact on connector design because it
affects the amount of coding that the connector requires. The easiest application
for connector development is one that interacts with its database through a
high-level API. If the application provides a low-level API or has no API, the
connector will probably require more coding.
The following questions to ask about the API can help you decide if it is a good
candidate for an adapter:
1. Is there an existing mechanism that the connector can use to communicate
with the application?
Ye s
2. Does the API allow access for CRUD operations?
Ye s :
– Create, Retrieve, and Update are possible.
–Delete.
There is no physical delete. A delete request would result in the status of
cancelled or deleted only.
3. Does the API provide access to all attributes of a data entity?
No, some data entities are internal to the application.
4. Are there inconsistencies in the API implementation?
No
5. Is the navigation to the CRUD functions the same regardless of the entity?
Ye s
6. Describe the transaction behavior of the API.
Each Create, Update, or Delete operation operates within its own
transactional unit.
7. Does the API allow access to the application for event detection?
Ye s