Tibco

 Q1) What are the differences between JDBC activities and sqldirect?

Sqldirect is capable of executing entire DML operations, such as table deletion and creation, whereas, jdbc activities are capable of executing specific DML operations like insert, modify, and update.

SQL Direct : Create and Drop Table

JDBC activities : Insert and Update

Q2) What are the differences between global variables, process variables, shared, and job shared variables?

Shared variables - accessible and changeable through different process definitions.

Job Shared - accessible within execution jobs. It maintains a copy for each job execution.

process variables - accessible for a specific process when defined.

global variables - accessible throughout the project. These variables are editable as well in Tibco at runtime.

Q3) In .ear, what are archive files?

.ear (Enterprise Archive) are deployable files in BW6.

After generating an EAR file, you can deploy it in TIBCO Administrator. If you make changes to the business processes or adapter services, you need to regenerate the EAR file. Saving the project does not affect the EAR file.

-combination of .aar, .sar, and .par files, where .aar denotes adapter archive, .sar stands for shared archive, and .par implies process archive.

Q4) Where to go for JDBC Activities and ADB adapter?

For ADB adapter, we should go where the flow of data is synchronous. Integration of data between various databases is needed. 

JDBC Activities, on the other hand, is used in cases of asynchronous operations without the need for data integration.

Tibco Database Adapter is used for enabling communication between TIBCO processes and database system. 

There are two types of services that can be used with a database adapter:

• Publication Service

• Subscription Service

Q5) What are the differences between file adapter and file poller?

A starter activity, the file poller polls a given file, simply reading the file, at the same time, processing the binary output or text. 

On the contrary, file adapter polls file sets for changes in an event, synchronizing them according to requirement.

Q6)  What in EMS is a nonresistant, persistent queue?

Persistent in Enterprise Messaging Service (EMS) is storing messages on database or disk so that data can be retrieved at any point in time from the database or disk when consumers are available.
When messages are not stored on database or disk, it is non-persistent in Enterprise Messaging Service. The messages remain in the EMS server until reaching their expiration limit.

Q7) What are known as Tibco transactions?

Messages related to the business are transactions in Tibco. There are transactions like JNDI, XA available on Tibco.

Q8) What are the differences between render XML , parsed XML and Transform XML?

Render XML is a synchronous activity that takes an instance of an XML schema element and renders/output it as a stream of bytes containing XML or an XML string.

i/p -> XML tree instance

o/p-> XML string/byte code

Parse XML is a synchronous activity that takes a binary XML file or an XML string and converts it into an XML schema tree based on the XSD specified.

i/p -> XML string/byte code

o/p-> XML tree instance

Transform XML is a synchronous activity that invokes the built-in XSLT processor to apply an XSLT stylesheet to an XML source document and produce a result document

> Using CSV as input - parse data pallet along with data format resource is used OR File adapter can be used.

File adapter is beneficial if the csv data that is coming is large .

if we use  parse data pallet along with data format resource it will consume more data.

> Web Services:

Exchanging data between applications is a crucial part in today’s world. Applications are written in different languages so data exchange has become a complex process. Web Services are the standardized medium to propagate communication between client-server applications on the world wide web.

SOAP: by default Stateless but can be made stateful. , Secured

SOAP (Simple Object Access Protocol) is an XML-based protocol for accessing web services over HTTP. It is developed as an intermediate language so that applications built in various programming languages can communicate with each other effectively. Web services use SOAP for exchange of XML data between applications. SOAP supports both stateful and stateless operations. Stateful means that the server keeps the information that it receives from the client across multiple requests. These requests are chained together so that the server is aware about the previous requests. Examples are bank transactions, flight bookings, etc. Stateless messaging has enough information about the state of the client so that the server does not have to bother.

REST: Stateless ,Simple ,Scalable and light weight service

SOAP service creation practically in BW6:

1. we create wsdl file in Service descriptor folder.     
2. then we will get our one default operation created here we will provide input and output response for the operation/ also we can add multiple operations here.
3. there after we'll right click to the wsdl and goto businessworks process -> generate process ->create soap binding
4. this will create soap process for is in Process folder.
5. provide SOAP binding and protocol in components -> properties.
6. after running lendpoints this will provide dynamic link for our SOAP service , 
7. Now goto SOAP UI -> SOAP ->copy the link with suffix as "/?wsdl" in Initial WSDL

LDAP?