Java code with a JDBC connection to Teradata via Message Broker
I'm a bit of a novice in this arena, so I hope this doesn't seem like an odd question
We currently are using Message Broker to interface HL7 transactions from our mainframe system. Currently, there is a message broker interface that interfaces these transactions to Sybase using ODBC. From the information I've read, you cannot do something similar to Teradata. What we need to do is read the HL7 transactions using Java and JDBC, and call a stored procedure in Teradata to load the transactions into a staging table.