filename: 52660796-eai-tibco-adb-2.ppt
DESCRIPTION
Filename: 52660796-EAI-Tibco-ADB-2.pptTRANSCRIPT
![Page 1: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/1.jpg)
1.
EAI Center Of Excellence
Confidential
Tibco ActiveDatabase Adapter
![Page 2: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/2.jpg)
2.
EAI Center Of Excellence
Confidential
![Page 3: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/3.jpg)
3.
EAI Center Of Excellence
Confidential
Adapter Architecture
![Page 4: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/4.jpg)
4.
EAI Center Of Excellence
Confidential
![Page 5: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/5.jpg)
5.
EAI Center Of Excellence
Confidential
![Page 6: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/6.jpg)
6.
EAI Center Of Excellence
Confidential
![Page 7: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/7.jpg)
7.
EAI Center Of Excellence
Confidential
Message Transports• TIBCO Rendezvous
ActiveEnterprise Message: provides class information and packing rules for the TIBCO Adapter SDK set of data types.
Rendezvous Message basic TIBCO Rendezvous wire format.
XML Message
• TIBCO Enterprise for JMS :Communicate only with the TIBCO Enterprise for JMS server
![Page 8: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/8.jpg)
8.
EAI Center Of Excellence
Confidential
![Page 9: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/9.jpg)
9.
EAI Center Of Excellence
Confidential
TIBCO Runtime Agent
• Provides basic connectivity between the other components and manages the components on each machine.
• Provides the run-time environment; that is, all the shared libraries including third-party libraries
• An agent that runs in the background and starts and stops processes according to deployment information.
![Page 10: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/10.jpg)
10.
EAI Center Of Excellence
Confidential
![Page 11: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/11.jpg)
11.
EAI Center Of Excellence
Confidential
Basic Features – Contd.
• Publish data by value cannot handle data types such as Oracle LONG and LONG RAW.
• Publish by reference - handles data types such as Oracle LONG and LONG RAW
• Publish on parameterized subjects.
• Pre-register certified subscribers with a certified publisher.
• Update both parent and child tables within a publication.
• Subscribe using wildcard subject names
• Use request-response semantics to publish SQL statements, stored procedures.
![Page 12: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/12.jpg)
12.
EAI Center Of Excellence
Confidential
Basic Features – Contd.
• Polling or Alerter : asynchronously alert the adapter of changes in the database
• Exception Table
• Loop Detection
• The adapter supports the following SQL operations for publishing and subscribing:
• INSERT
• UPDATE
• DELETE
• UPDATE/INSERT (update if row exists, otherwise insert)
•Timely Processing of Data : limits the number of messages that are picked up per poll period
![Page 13: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/13.jpg)
13.
EAI Center Of Excellence
Confidential
Configuring a publisher adapter
• Create Tables using scripts
Source table.
Publishing table - the new data from the source table is copied using the trigger. Table has additional columns (prefixed by ADB_) that are used by the adapter.
Destination table ADB update new data.
Exception table
• Configure the adapter in BW designer
• Design Time configurations
• Run Time configurations
![Page 14: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/14.jpg)
14.
EAI Center Of Excellence
Confidential
Configuring a publisher adapter - contd
• Select the publisher
Configure the source table, child tables if any.
Message transport etc.
Save the project
Build Ear file – Multi file format.
Deploy using TIBCO Admin
Run the adapter
![Page 15: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/15.jpg)
15.
EAI Center Of Excellence
Confidential
![Page 16: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/16.jpg)
16.
EAI Center Of Excellence
Confidential
![Page 17: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/17.jpg)
17.
EAI Center Of Excellence
Confidential
![Page 18: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/18.jpg)
18.
EAI Center Of Excellence
Confidential
![Page 19: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/19.jpg)
19.
EAI Center Of Excellence
Confidential
![Page 20: Filename: 52660796-EAI-Tibco-ADB-2.ppt](https://reader033.vdocuments.us/reader033/viewer/2022051314/55313fc54a795943298b4915/html5/thumbnails/20.jpg)
20.
EAI Center Of Excellence
Confidential
THANK YOUTHANK YOU