Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MQ Series & Data Warehouse
- Thread starter jsanchezi
- Start date
Joaquin,
I have used MQ Series as a message transport.
The environment consisted of:
Java
JMS (Java Messaging Services)
JDBC connectivity to Sybase Adaptive Server 11.9.
This was a very high performance transactional environment.
I can understand wanting to use MQ Series as a transport FROM source systems TO a DW, but what kind of application are you building that would us it as an extraction tool?
Chuck
I have used MQ Series as a message transport.
The environment consisted of:
Java
JMS (Java Messaging Services)
JDBC connectivity to Sybase Adaptive Server 11.9.
This was a very high performance transactional environment.
I can understand wanting to use MQ Series as a transport FROM source systems TO a DW, but what kind of application are you building that would us it as an extraction tool?
Chuck
Guest_imported
New member
- Jan 1, 1970
- 0
HI
Instead of writting the program in Java use Oracle Gateway and write the program in PL/SQL.This is pretty fast and U can download the messages from the queue very fastly.Write a porgram in PL/SQL which willdownload the messages in ASCII.From ascii to staging use some tools like informatica etc.
Instead of writting the program in Java use Oracle Gateway and write the program in PL/SQL.This is pretty fast and U can download the messages from the queue very fastly.Write a porgram in PL/SQL which willdownload the messages in ASCII.From ascii to staging use some tools like informatica etc.
- Status
Similar threads
- Locked
- Question
- Locked
- Question