CODEWITHSUNDEEP
windows-servicestibcotibco-emstibco-business-workssystem-integration
user6520593
user6520593

Reputation: 1

Integration between two systems using TIBCO

I have two different applications that need to share data between them. By data, I mean only some pieces of data and not the entire data across the systems.

The databases of the applications are owned by us but the applications are third party.

The two applications use database as an integration mechanism where they have a transaction table into which the data to be integrated is written to. A third party application then picks the data from there.

We are evaluating how to utilize TIBCO for performing the integration - (Trying to go away from the third party integration pieces). Such that, we expect Tibco to pick the data from the transaction table, apply any business logic and sync up the other systems as result of the integration.

I have in the past wrote a windows service that polls a similar transaction table and write (the data to be synced/integrated) to the TIBCO queue and have the windows service read from the queue, apply the business logic and do the integration or data sync in the other system's database.

I was using TIBCO EMS module to work with the message queues. But if there are other options within and outside of TIBCO, please provide some pointers.

We are particular on TIBCO because the org moves in a direction to make TIBCO a standard means of integration between systems.

TIA

Upvotes: 0

Views: 352

Answers (1)

Rao
Rao

Reputation: 21379

TIBCO BusinessWorks Product is the right option for you here in this where it allows you to connect to the database / ems, I believe. This allows to integrate systems and define your process and orchestrate the logic you might wanted to do.

It has the connection palette to connect to database, fetches the required data using query and allows to process that data for further processing.

May be you can find more details in documentation

Upvotes: 1

Related Questions