Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hvdtol
Yak Posting Veteran
50 Posts |
 Posted - 2003-06-01 : 06:14:00
|
| Searching through the forums i cannot find what i am looking for, so here is my question.Has anyone experience importing data from a Mq Series message queue into a SqlServer (7.0) database?I have worked with T-sql so far, but searching though Bol brings me into a direction of programming odbc connections and Ole db, which i do not fully understand.Can i use "linked server" to connect to a Mq Series queue or do i have to look in other directions.Any help or any example is appreciated.Harry van der Tol |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-02 : 10:43:16
|
| MQ Series is middleware...It's a messaging system, not a data source.If SQL Server is one end of the data source, what's the other end (I'm thing DB2 OS/390)...Brett8-) |
 |
|
|
hvdtol
Yak Posting Veteran
50 Posts |
Posted - 2003-06-02 : 13:30:35
|
| Yes you're right Mq is middelware.I want to send messages from Db2 (Mainframe) or Oracle (Nt/Unix) to an IBM Mq Series message queue, and then let SqlServer read the messages from this queue into a database.The point is that SqlServer has no standard ODBC connection to MQ Series, and i am looking for a way to overcome this problem. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-02 : 13:53:32
|
| Why not create a linked server to Oracle...that should be easy enough to do...DB2 on the mainfram however will require a gateway, as I have yet to see a direct connection to it.Also MQ requires Queues to be established at a soruce and destination points. We have it set up on the mainframe, where are you going to have a MQ Server set up? On NT?Also we use a CICS region to support MQ on the mainframe.Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-02 : 14:02:43
|
| Just spoke with our JAVA developers...they call an API supplied by IBM...don't know if there is one...imagine an extended strored proc would be needed for this...Ya got me curious know...Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-06-02 : 15:35:09
|
| Our ppl built a C++ Windows service, reading from queues and inserting into SQL Server tables... A bit roundabout but... :) |
|
|
|
hvdtol
Yak Posting Veteran
50 Posts |
Posted - 2003-06-03 : 13:11:47
|
| Thank for all the responses.We use Mq series (no say it correctly Harry), we are going to use Mq series on all our platforms. We already implemented it on Unix, mainframe and NT. However not yet in real live situations, the projects will start this summer.In genereal there are Mq server and clients implemented, which makes it possible to send messages from Unix (Oracle) to Windows(Oracle) to the Web or to Db2 (Mainframe).At this moment there is no direct need to involve SqlServer into this architecture, but i also do not want it to be "left alone".So, because there is not standard facility, there a two options: buy some product, or write something.I think i go for the last option and as Andraax suggested, write some C++ progam. Only one problem, i have no knowledge of c++ (Only t-sql). But i am still young enough to learn, an perhaps this is the moment.... |
|
|
|
|
|
|
|
|
Search for experience MqSeries and SqlServer