ADB Adapter

How can u fine-tune anADBAdapter? What are the different parameters that can be used?

a) we can use publish by value or publish by reference for high speed and datatype support like oracle long respectively.
b) Can use polar or alerter for frequent and infrequent data changesrespectively.
c) Adb.PollingInterval, _ADB.DUPDECT.adapter_instance_name parameters can beused to do flow control and avoid duplication respectively.

What are the quality of services we canhave in adapter publishing services?

reliable, certified, transactional

What are the objects, which will becreated if you configure and save ADB adapter?

Publishing table for source table, Trigger acts as abridge between source and publishing table

Explain the internal functioning of ADBpublication service?

When we configure ADB publishing service it createsPublishing table for source table, Trigger acts as a bridge between source andpublishing table. Whenever data is being inserted/updated/deleted from sourcetable, it will be inserted into publishing table by means of trigger. ADB hasanother component called polling agent. Polling agent will be keep looking fornew inserts into publishing table and if it finds any then converts the recordin p table into the specified wire format and publishes on specified quality ofservice

What is the difference between anADBAdapter and JDBC palette activities?

• Using ADB we can only pick up the data from onedatabase and put it in onother one.
• But using JDBC we can Query using JDBCQuery and manupulate data using JDBCUpdate. like we can use selectstatements and insert and update statements to selective query and update.
• ADB adapters might be useful in scenarios where we have large amount of data.

What is the difference between JDBCactivities and ADB Adapter?

• ADB uses ODBC to connect, JDBC uses JDBC
• ADB is more suitable for instances where you have a lot of processing
• ADB is more suitable for instances where you want that a particular action ona DB Table triggers a BW process.
• ADB adapter is best for publishing from database.
• For simple inserts and updates then ADB subscriber is best.
• ADB is an adapter which is used to capture the events and take action, thishas pub and sub mechanisms, pub is used to capture the events and publish themessages and sub will be used to upsert the operations.
• Jdbc is a collection of activities that can be used for custom operations
• In case of insert or update to database then check if you have complex JDBCinserts, transaction management and other dynamic queries then JDBC activitiesare best.
• JDBC is more suitable for running dynamic code where in runtime you canexecute statements with different values depending on process execution.

What are the transport types supported by ADB adapters?

The transport types supported by ADB adapters are:
1) Rendezvous
2) JMS

Rendezvous

Quality of service supported by Rendezvous:
1) Reliable
2) Certified
3) Transactional

Wire Formats Supported by Rendezvous:

1) Active EnterpriseMessage
2) Rendezvous Message
3) XML Message

JMS

Wire Formats Supported by JMS:
1) XML Message

Connection Factory Type Supported by JMS:

1)Topic
2)Queue

Delivery Mode Supported by JMS:

1) Persistent
2) Non-Persistent