Is it possible to execute queries or call macros in Teradata through TIBCO EMS? If so, what is the process? If not, what is the correct Tibco product to perform this action?
Execute queries or macros in Teradata using Tibco EMS
54 Views Asked by Soumen At
2
There are 2 best solutions below
0
On
You must connect EMS queues/topics to a listener service developed in C/Java/.NET/BusinessWorks to read incoming messages and for each messages received you can do actions to Teradata. I am not familiar with Teradata but API in Java could exist to permit you to call macros in the listener service.
TIBCO EMS is a messaging product that transports data from one point to another. To do something, you'll need to have a producer and a consumer of messages connected to it and the consumer of those messages would be able to execute queries in Teradata.
If you want to connect to Teradata and execute those queries to visualize them. In that case TIBCO Spotfire is the best suited TIBCO product for the job. You can find details on how to connect to Teradata using TIBCO Spotfire here.