
TIBCO ADB Adapter Interview Questions and Answers + [ JOB REFERENCES ]
Last updated on 14th Nov 2021, Blog, Interview Questions
In this list of TIBCO ADB Adapter basic interview questions, we have included all regularly asked basic and TIBCO ADB Adapter interview questions for experienced candidates with detailed answers to help you clear the job interview. The following list includes the best important TIBCO ADB Adapter questions for freshers as well as TIBCO ADB Adapter questions and answers for experienced programmers to help them prepare for the interview. This complete guide of TIBCO ADB Adapter interview questions will encourage you to crack your Job interview easily.
1. How can you fine-tune an ADB Adapter? What are the different parameters that can be used?
Ans:
a) We can use publish by value or publish by reference for high speed and data type support like oracle long respectively.
b) Can use polar or alerter for frequent and infrequent data changes respectively.
c) ADB.PollingInterval, _ADB.DUPDECT.adapter_instance_name parameters can be used to do flow control and avoid duplication respectively.
2. What is the quality of services we can have in adapter publishing services?
Ans:
RV: reliable, certified, transactional
3. What are the wire formats we can have in adapter publishing services?
Ans:
- Wire formats:
- RV: active enterprise message, RV message, XML message.
- JMS: XML message
4. What Is Run-time Adapter and Design-time Adapter
Ans:
Once the adapter has been configured using TIBCO Designer, it can be deployed. | Some adapters use a design-time adapter (DTA) to access a vendor application and return design-time configuration information. |
A deployed adapter instance is referred to as a run-time adapter. A run-time adapter operates in a production environment, handling communication between a vendor application and other applications that are configured for the TIBCO environment. | The palette is a client of the DTA process. The DTA connects to the vendor application, fetches data schemas and sends them to the palette. |
5. Explain the internal functioning of the ADB publication service?
Ans:
When we configure the ADB publishing service it creates a Publishing table for the source table, Trigger acts as a bridge between source and publishing table. Whenever data is being inserted/updated/deleted from the source table, it will be inserted into the publishing table by means of the trigger. ADB has another component called polling agent. The polling agent will keep looking for new inserts into the publishing table and if it finds any then converts the record in p table into the specified wire format and publishes on specified quality of service.
6.What is the difference between JMS and EMS?
Ans:
The difference between JMS and TIBCO EMS is that JMS provides two types of delivery modes which are Persistent and Non-Persistent while TIBCO EMS adds another type of delivery mode which is RELIABLE delivery mode.
7. In how any ways can we create EAR files ?
Ans:
We can build EAR files in 2 ways. One method is using the Enterprise Archive pallete in the Tibco designer and adding the process archive we can build EAR file. Other method is from the cmd prompt. We use the command appmanage and buildear.
8. What is the difference between “interface vs type” statements?
Ans:
An interface declaration always introduces a named object type. | A type alias declaration can introduce a name for any kind of type, including primitive, union, and intersection types. |
An interface can be named in an extends or implements clause. | Type aliases for an object type literal cannot be named in an extends or implements clause. |
9. Can we filter the records from publishing when they get updated in the source table? (Data from all regions are coming into the table but I want to publish only New York data)?
Ans:
Yes – By modifying the trigger we can only insert the New York data into the publishing table
10. Describe the TIBCO activemax adapter for the database?
Ans:

11. Can we limit the number of columns to be published from the source table?
Ans:
Yes, using the user field in the adapter publishing table tab. Just uncheck the columns you don’t want to use.
12. Can we publish parent and child table information by using a single adapter configuration and how?
Ans:
Yes, in the adapter publisher table tab create a parent table first by lookup and then add the child table using the add child tab then click on the child table column to specify the foreign key then to establish a relationship between the primary key of the parent and the foreign key of the child go to the column in the child table and specify the primary key of the parent table.
In the subscription service, the destination table is created and the child table mapping tab will have the child table on the left mapped with the parent table on the right. TIBCO ADB Adapter Interview Questions.
13. What Are Adapters?
Ans:
Adapters are connectors to data sources to catch event changes. Once an Adapter catches an event change, Adapter publishes the message to a message box using either EMS or RVD.Adapter is a gateway between different applications using messaging channels.
14. What Are The Different Types Of Adapters?
Ans:
- Functional Adapters ( PeopleSoft Adapter, SAP R3 Adapter)
- Custom Adapters
Technical Adapters ( File Adapter, DB Adapter )
15. What Is Publish By Value And Publish By Reference?
Ans:
In Publish by Value, all the specified columns in the source table are copied into the Publishing table. | In Publish by reference, only the specified key column values are copied to the publishing table. |
16. Explain About Adapter Components ?
Ans:
Each adapter has two main components, an adapter palette and a run-time adapter. In addition, some adapters include a design-time adapter. The adapter palette and design-time adapter are used during configuration, and the run-time adapter is used at production time.
17. Explain About Adapter Palette ?
Ans:
Each adapter includes a palette that is used for configuration. The palette is automatically loaded into TIBCO Designer during adapter installation and available the next time Designer is started. The palette enables you to configure adapter specific options, such as its connection to the vendor application, logging options, and adapter services.
During the design phase, the palette connects to the vendor application and fetches information about connection options and data schemas. You can then graphically select the appropriate items. For example, during configuration of a TIBCO Adapter for ActiveDatabase adapter instance, the palette fetches all pertinent tables in the database. You then choose the tables that the particular service is to send or receive.
18.How to check null and undefined in TypeScript?
Ans:
- By using a juggling-check, we can check both null and undefined:
- if (x == null) {
- }
- If we use a strict-check, it will always be true for values set to null and won’t evaluate as true for undefined variables.
- Example
- var a: number;
- var b: number = null;
- function check(x, name) {
- if (x == null) {
- console.log(name + ‘ == null’);
- }
- if (x === null) {
- console.log(name + ‘ === null’);
- }
- if (typeof x === ‘undefined’) {
- console.log(name + ‘ is undefined’);
- }
- }
- check(a, ‘a’);
- check(b, ‘b’);
- Output
- “a == null”
- “a is undefined”
- “b == null”
- “b === null”
19. What is distributed polling in a DB adapter?
Ans:
Distributed Polling means that when a record is read, it is locked by the reading instance. Another instance which wants to pick up the record skips locked records.
20. What is TIBCO activemax business works concept?
Ans:

21. What Is a Run-time Adapter ?
Ans:
Once the adapter has been configured using TIBCO Designer, it can be deployed. A deployed adapter instance is referred to as a run-time adapter. A run-time adapter operates in a production environment, handling communication between a vendor application and other applications that are configured for the TIBCO environment.
22. What is a Design-time Adapter ?
Ans:
Some adapters use a design-time adapter (DTA) to access a vendor application and return design-time configuration information. The palette is a client of the DTA process. The DTA connects to the vendor application, fetches data schemas and sends them to the palette.
23. Explain About Adapter Lifecycle ?
Ans:
- Install the vendor application to which the adapter connects before installing the adapter. For many adapters, the adapter and vendor application need not be installed on the same machine.
- Adapters depend on other software from TIBCO. Before installing an adapter, the TIBCO Run-Time Agent software must be installed on each computer on which the adapter runs.
- Create an adapter instance and save it in a project using TIBCO Designer™. A project contains configuration information required for a run-time adapter to interact with the vendor application and other applications.
- Deploy the adapter. An adapter instance is deployed using TIBCO Administrator.
- Using TIBCO Designer, create an Enterprise Archive (EAR) file, which contains information about the adapter instances and processes you wish to deploy.
- Using TIBCO Administrator, upload the EAR, then deploy the adapter on the machine(s) of your choice. You can set runtime options before deployment.
- Using TIBCO Administrator, start and stop the adapter.
- Monitor the adapter using the built-in monitoring tools provided by TIBCO Administrator.
24. Explain About Adapter Services ?
Ans:
- Publication Service
- Subscription Service
- Request-Response Service
- Request-Response Invocation Service
Adapters are responsible for making information from different applications available to other applications across an enterprise. To do so, an adapter is configured to provide one or more of the following services:
25. What Is The Difference Between Jdbc Activities And Adb Adapter?
Ans:
JDBC is more suitable for running dynamic code where in runtime you can execute statements with different values depending on process execution. | 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 on a DB Table triggers a BW process. |
26. Define Publication Service
Ans:
- User Interface—————–Application X————–Adapter ————– TIBCO Messaging
- Create record Send to adapter Publishing
- Polls on the source data table (base table).
- Reads data from the source table. Send the data to the message bus.
An adapter publication service recognizes when business events happen in a vendor application, and asynchronously sends out the event data in realtime to interested systems in the TIBCO environment. For example, an adapter can publish an event each time a new customer account is added to an application. Other applications that receive the event can then update their records just as the original application did. When an application receives a request to create a customer record, the application notifies the adapter about the request and the adapter publishes the event.
27. Define Subscription Service?
Ans:
- TIBCO Messaging————Adapter———–Application Y Subscribing Update record
- Reads data from the message bus.
- Gives the data to the destination table
An adapter subscription service asynchronously performs an action such as updating business objects or invoking native APIs on a vendor application. The adapter service listens to external business events, which trigger the appropriate action. Referring to the previous example, an adapter subscription service can listen for customer record creation events (happening in an application and published to the TIBCO infrastructure) and update another application.
28. Define Request-Response Service ?
Ans:
- Receives requests from other applications.
- Parses the requests. Returns response (Sends only the requested data to the message bus).
In addition to asynchronously publishing and subscribing to events, an adapter can be used for synchronously retrieving data from or executing transactions within a vendor application. After the action is performed in the vendor application, the adapter service sends a response back to the requester with either the results of the action or a confirmation that the action occurred. This entire process is called request-response, and it is useful for actions such as adding or deleting business objects.
29. Explain generics in TypeScript?
Ans:
- function identity
(arg: T): T { - return arg;
- }
- let output1 = identity
(“myString”); - let output2 = identity
( 100 ); - console.log(output1);
- console.log(output2);
In generics, a type parameter is written between the open (<) and close (>) brackets which makes it a strongly typed collection. Generics use a special kind of type variable
30. Describe the architecture of enterprise integration patterns?
Ans:

31. Define Request-Response Invocation Service?
Ans:
An adapter request-response invocation service is similar to the request-response service, except that the roles are reversed. The vendor application is now the requester or initiator of the service, instead of the provider of the service. The adapter service acts as a proxy, giving the vendor application the ability to invoke synchronously functionality on an external system.
32. What Are The 3 Main Configuration Elements Common For All Adapters?
Ans:
- Run Time ( For Admin Deployment )
- Service ( Pub / Sub, Request-Reply )
Design Time ( For BW Testing )
33. What is the potential problem with JMS Queue requestor?
Ans:
When we specify a reply to queue there is a chance of other processes sending messages to the same queue and the jms queue requestor interpreting that as the actual response and sending this wrong message to the client.
34. What is the inspector activity does?
Ans:
The inspector activity is used to obtain the output of any activity or all the activities and process variables. Scenario: You can use the inspector activity to write the output of any activity or process variable in the current process. Activities and process variables in a subprocess are not available to the Inspector activity (but the output of a Call Process activity can be written using the Inspector activity). If you wish to obtain the output from one or more activities or process variables in a subprocess, place the Inspector activity in the process definition of the subprocess.
35. What Are Modes Of Operation For File Adapter In Record Mode?
Ans:
Synchronous mode upon receiving an event, the publication service will allow other services in the instance only after it completes the processing and publishing of all the files that match the specified criteria.
In Asynchronous mode the publication service allows other services of the instance to receive events while it is processing and publishing a file. By default Subscription service always operates in Asynchronous mode.
36. What is the use of project template?
Ans:
In project template we can save our standard processes that we want to use in future. These processes are generally the ones which have the commonly used activities.
37. What Are Supported Sql Operations In Database Adapters?
Ans:
- The database adapter supports the following SQL operations for publishing and subscribing:
- INSERT
- UPDATE
- DELETE
- UPDATE/INSERT (update if row exists, otherwise insert)
38. What Are The Transport Types Supported By Adb Adapters?
Ans:
- Rendezvous
- JMS
39. What are the differences between the versions 2.x and 5.2?
Ans:
Type 2.x 5.2 deployment In 2.x deployment is done in the designer Here deployment is done using administrator tool Name spaces Name spaces are prefixed with tib No tib in name spaces pallets Extra pallets added Iterate-reset At the end of each iterate the output is not reset Here the output is reset after each iteration installation Here all the components like BW,ADB,FILE etc come as a package Here we will have to install each component separately File type All files are .dat. we have to convert these manually Multi format file are available so that we do not have to convert the dat files
40. What is supporting multiple oracle application?
Ans:

41. What are break points?
Ans:
Break points are used to check the inputs and outputs of each activity during testing the design so that we can debug our design. We can place the check points for all activities on input and output side.
42. What is sub process and what is its use?
Ans:
Whenever we call a process from another process , the called processbecomes the subprocess. Sub process helps in reducing the complexity of the design by assigning the activity in other process.
43. Explain The Internal Functioning Of Adb Publication Service?
Ans:
when we configure ADB publishing service it creates a Publishing table for the source table, Trigger acts as a bridge between source and publishing table. Whenever data is being inserted/updated/deleted from the source table, it will be inserted into the publishing table by means of trigger. ADB has another component called polling agent. Polling agent will keep looking for new inserts into the publishing table and if it finds any then converts the record in the p table into the specified wire format and publishes on specified quality of service.
44. What is Max jobs, Flow limit, and Activation limit?
Ans:
Max jobs: Max jobs specify the number of process instances that are kept in memory while executing. b. Flow Limit: it is the max number of jobs that can be spawned before the process starter is suspended. c. Activation Limit: Specifies that once a process instance is loaded and it must be placed in memory till it completes execution.
45. What is grouping activity?
Ans:
Grouping activity is used to group certain activities used in the designer so that we can loop those activities and iterate the group with conditions.
46. What are adapters in OIC?
Ans:
What are OIC Adapters? The word Adapter generally means something that adapts or converts incompatible information into compatible information for the end-users. Adapters in the cloud is a program that controls the transfer of information between users and a cloud.
47. What is custom activity?
Ans:
Custom activity is useful when we want others to use our process and not allow them to view the contents of the process. We can add this process into our MY Pallete section. We can directly use this process by dragging it into our process.
48. What is the use of confirm activity?
Ans:
Confirm activity is used to confirm the success of a activity that have confirmable messages. For example if certain process starts on reception of a message then if that process starts the confirm activity sends a confirm message to the sender of the message.
49. What is an ADB adapter in Tibco?
Ans:
TIBCO ADB adapter is a bridge between TIBCO application and database systems allowing bi-directional transfer of data between TIBCO processes and Database Systems by utilizing publication or subscription service on top of JMS or Rendezvous messaging platform.
50. What is the structure of service communication flow in TIBCO?
Ans:

51. What is a file adapter?
Ans:
A File Adapter is an object used to manage file-based information through Clarify. File Adapters support these common operations: Copy.
52. What is Adapter in SOA?
Ans:
Adapters are able to integrate the BPEL process service component with access to file systems, FTP servers, database tables, database queues, sockets, Java Message Services (JMS), MQ, and Oracle E-Business Suite.
53. What is an FTP adapter?
Ans:
The FTP Adapter enables the integration of servers supporting File Transfer Protocol (FTP) and Secure Shell (SSH) File Transfer Protocol (sFTP) into Oracle Integration. The FTP Adapter can connect to FTP and sFTP servers that are publicly available on the internet.
54. What is Schema and why do we create schema ?
Ans:
- Schema is used to create a XML schema file in which we add the variables which we want to use in our designer process. We can create the elements under which we can add the typed variables. The structure formed will be in the form of tree structure.
55. What is the FTP adapter in SAP PI?
Ans:
You create a sender FTP adapter if you want to send file content from an FTP server to the Integration Server or the PCK. … If you are developing a module for the adapter and want to access the file name in the module, see SAP Note 819761. The use of FTPS follows the specification RFC 4217.
56. Does SAP support SFTP?
Ans:
Sap’s recommendation to read/write to SFTP server is by using the PI (Process Integration) solution. … Option 1. Server side scripting commands to write to SFTP server from SAP Application Server with the help of an open Source FTP client (WinSCP).
57. How does SAP Sftp work?
Ans:
Tenant sends requests to SFTP server to write files to the SFTP server. SFTP server authenticates the tenant based on a public key. Using this authentication option, the user (performing the file transfer) is authenticated based on credentials (username/password). Supported by SFTP sender adapter.
58. What is FTP in SAP ABAP?
Ans:
FTP(FileTransferProtocol) is a network protocol built on top of the TCP/IP protocol,allowing transfer of files between two host machines over the network. FTP is used for Application-to-application(A2A) or Business-to-business(B2B) scenarios. SAP provides a built-in client library called ‘SAPFTP Library’.
59. What is the FTP path?
Ans:
“FTP ” stands for File Transfer Protocol and it is a method by which files can be transferred from one host computer to another; over a TCP-based network like the Internet. In Shift4Shop’s case, FTP access is used to transfer your image files, design templates and other site specific files to and from your store’s server.
60. Describe the TIBCO user manual?
Ans:

61. What is FTP image?
Ans:
Glossary: Image transfer via FTP
FTP stands for File Transfer Protocol. This is a network protocol and is a method which can be used by IP security cameras to transfer images from the camera to storage. FTP is a client/server system which means that there must be one FTP server and an FTP client.
62. What is the transition in BW?
Ans:
To move the data from one activity to another or when conditions exist on the data.
63. Is it possible to combine multiple .ts files into a single .js file? If yes, then how?
Ans:
Yes, it is possible. For this, we need to add –outFILE [OutputJSFileName] compiling option.
- $ tsc –outFile comman.js file1.to file2.ts file.ts
The above command will compile all three “.ts”file and result will be stored into single “comman.js” file. In the case, when we don’t provide an output file name as like in below command.
- $ tsc –outFile file1.to file2.ts file.ts
Then, the file2.ts and file3.ts will be compiled, and the output will be placed in file1.ts. So now our file1.ts contains JavaScript code.
64. What is TIBCO and why is it used?
Ans:
TIBCO, a global software company, provides the business software to integrate, efficiently manage, and helps to monitor enterprise applications, information delivery, and so on. The purpose of this TIBCO software helps the trading partners to coordinate the business process and activities easily.
65. What is TIBCO used for?
Ans:
TIBCO ActiveMatrix is a technology-neutral platform for composite business process management (BPM) and service-oriented architecture (SOA) applications. The platform includes products for service creation and integration, distributed service and data grids, packaged applications, BPM and governance.
66. What is TIBCO?
Ans:
Information integration and analytics firm TIBCO is so named because it’s name stands for The Information Bus COmpany. An information ‘bus’ is indeed a transport mechanism i.e. it helps to distribute work around connected components of an application.
67. Is TIBCO an ETL tool?
Ans:
TIBCO Jaspersoft® software supports both of the leading data integration solutions: Extract, transform, and load (ETL) and data virtualization. Use ETL when you want to physically move data from multiple data sources into a single data warehouse.
68. What do you mean by interfaces? Explain them with reference to Typescript
Ans:
- interface interface_name {
- variables’ declaration
- methods’ declaration
- }
An Interface is a structure which acts as a contract in our application. It defines the syntax for classes to follow, it means a class that implements an interface is bound to implement all its members. It cannot be instantiated but can be referenced by the class object that implements it. The TypeScript compiler uses an interface for type-checking (also known as “duck typing” or “structural subtyping”) whether the object has a specific structure or not.
Syntax:
The interface just declares the methods and fields. It cannot be used to build anything. Interfaces need not be converted to JavaScript for execution. They have zero runtime JavaScript impact. Thus, their only purpose is to help in the development stage.
69. What is JMS In Tibco?
Ans:
Java Message Service (JMS) is a specification about sending and receiving messages between two or more applications in a Java environment. The JMS palette is used to send and receive JMS messages in a process. The models supported are: Point-to-Point (queues): Message delivered to one recipient.
70. What is TIBCO EMS?
Ans:

71. Is it good to work with Tibco?
Ans:
76% of employees at TIBCO say it is a great place to work compared to 59% of employees at a typical U.S.-based company.
72. What does Tibco streaming include?
Ans:
TIBCO Streaming includes an enterprise-class, high-performance, and low-latency TIBCO StreamBase® Server, TIBCO StreamBase Studio™, TIBCO LiveView™ Server, TIBCO® Artifact Management Server, broad connectivity to data sources and sinks, and management and monitoring tools.
73. What is the diff between tibco adapter and BW component?
Ans:
Adapters are connectors that use a messaging channel that can be configured over source/target systems which can be used in Pub, Sub or Replyrequest mode. BW components are designer, administrator, bw engine.
74. How can you change the configuration properties of EMS server Answer?
Ans:
You can change in the tibemsd.conf file or you can change using the ems admin console.
75. What is Tibco in Java?
Ans:
It is an Enterprise Application Integration (EAI) which promotes Service Oriented Architecture (SOA). The major portion of its implementation in JAVA. TIBCO is widely used because of its reliability, flexibility, and scalability.
76. How does Tibco EMS work?
Ans:
A TIBCO Enterprise Management Service (EMS) server provides messaging services for applications that communicate by monitoring queues. The TIBCO EMS server ensures that sent messages are directed to the correct receive queue or ensures that messages are routed to another queue manager.
77. What is Tibco Web services?
Ans:
Web services are application components that communicate using open standard protocols. You can develop SOAP-based web services using the Generate Concrete WSDL Wizard. The wizard generates a WSDL file and the appropriate response activities.
78. Is Tibco Java based?
Ans:
TIBCO Business Works is a Java based platform, however normally very little development is done in Java.
79. What is Tibco ESB?
Ans:
The TIBCO® ESB Bundle provides the capability for creating robust ESB solutions for enterprise environments. The bundle includes functionality for integration & orchestration, messaging, adapters and monitoring for a complete ESB solution that can be tailored and configured to specific customer use cases.
80. wWhat are the structures of tibco contents?
Ans:

81. Tell me about flow control on bridges and routes?
Ans:
Flow control has to be specified on both sides of bridges where as on routes it operates differently on sender side and receiver side.
82. Is Tibco public?
Ans:
Tibco launched in 1997 as a provider of software for enabling financial applications to share market data with each other. The company went public just two years later, made it through the dot-com bubble and established itself as one of the leading players in the application integration market.
83. What is Tibco PSG?
Ans:
The TIBCO Professional Services Group (PSG) is the most experienced TIBCO consulting organization in the world and its mission is to ensure our customers’ success. We support projects that are aggressive, strategic to our customers’ business, and that leverage mission critical services and applications.
84. What is Jaspersoft ETL?
Ans:
Jaspersoft ETL is a complete and ready-to-run ETL job designer with an extensive set of data integration capabilities. Display and edit the ETL process with Job Designer, a graphical editing tool. Define complex mappings and transformations with Transformation Mapper and other transformation components.
85. What is Tibco LiveView?
Ans:
TIBCO LiveView Web is a browser-based application empowering users to create a rich display of cards that visualize data from queries and create actions against a TIBCO Streaming server. It displays data in a variety of real-time charting formats, and supports extensions such as custom visuals using JavaScript.
86. What is Tibco data virtualization?
Ans:
TIBCO Data Virtualization combines disparate data sources on-demand instead of copying their data into a Data Warehouse. … TIBCO Data Virtualization connects to virtually any data source and provides business users access to data through JDBC, ODBC, REST and SOAP.
87. What is Tibco designer?
Ans:
TIBCO Designer is a GUI tool for designing your business process integration. It is used for adapter configuration, process design, test, and deployment. TIBCO Designer is a component of TIBCO BusinessWorks.
88. What is the difference between the internal module and the external module?
Ans:
Internal modules were used to logically group the classes, interfaces, functions, variables into a single unit and can be exported in another module | External modules are useful in hiding the internal statements of the module definitions and show only the methods and parameters associated with the declared variable. |
Internal modules were in the earlier version of Typescript. But they are still supported by using namespace in the latest version of TypeScript. | External modules are simply known as a module in the latest version of TypeScript. |
Internal modules are local or exported members of other modules (including the global module and external modules). | External modules are separately loaded bodies of code referenced using external module names. |
89. What is Tibco middleware?
Ans:
Tibco makes an integration server software program for companies. An integration server permits a corporation to combine packaged packages, custom software packages, and legacy software programs to be used all through internal and outside networks.
90. What is TIBCO product name?
Ans:

91. Wire Formats Supported by Rendexvous?
Ans:
- Active Enterprise Message
- Rendezvous Message
- XML Message
92. What is a file adapter in Tibco BW?
Ans:
TIBCO File Adapter is used to enable flow of information between files and TIBCO Enterprise Service Bus. File Adapters provide publication and subscription services which are used to get the data from the file or to write the data to the file respectively.
93. What is TIBCO administrator?
Ans:
