| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to access 2 database in a single compute node in v6.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| Deepika Bharti |
 Posted: Wed Jun 04, 2008 3:36 pm Post subject: How to access 2 database in a single compute node in v6.1 |
 |
|
Newbie
Joined: 05 Mar 2008
Posts: 4
|
Hiya,
I need to two databases to use in a single compute node . I have to extract data from Oracle database and then in the same compute node I want to insert the data to SQL Server database.
Can anyone guide me how to do so ??...as I can only give one DSN (for one database) in the properties of compute node.
Also can anyone tell me that is it feasible to use SQL server database with Oracle database within the same compute node ??
Thanks
Deepika |
|
| Back to top |
|
 |
| santy |
| Posted: Wed Jun 04, 2008 8:14 pm Post subject: |
|
|
Centurion
Joined: 03 Nov 2006
Posts: 141
|
Hi,
Make Use of Procedures. You can use procedures to call any application database. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Jun 04, 2008 9:22 pm Post subject: Re: How to access 2 database in a single compute node in v6. |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| Deepika Bharti wrote: |
I need to two databases to use in a single compute node . I have to extract data from Oracle database and then in the same compute node I want to insert the data to SQL Server database.
Can anyone guide me how to do so ??...as I can only give one DSN (for one database) in the properties of compute node.
|
in eSQL your database commands shall include the DSN name of the DB u want to access... something like..
database.<DSNname>.<Schemaname>.<Table Name>.............
in Compute node u can give DSN name of any of the server..
till v6 it was not possible to access 2 different DB types in one compute node.... i am not sure abt 6.1
_________________
Cheers |
|
| Back to top |
|
|
| dilse |
| Posted: Thu Jun 05, 2008 9:32 am Post subject: |
|
|
Master
Joined: 24 Jun 2004
Posts: 270
|
Hi Deepika,
Here is extract from the V6.0 information center, which you should easily able to find.
| Quote: |
"You can access user databases from Compute, Database, and Filter nodes; you can use the same ESQL statements and functions to access databases in all three types of node. A single node can access multiple databases but the following restrictions apply:
* Any node that accesses one or more databases must have its Data source property set with the ODBC data source name (DSN) of a database; the database must be accessible and operational, and the broker must be authorized to connect to it.
* All databases that are accessed from a single node must be compatible with each other. If you use the same database manager on the same platform at the same service level for all the databases, the data sources will be compatible. For example, two DB2 database instances at the same DB2 fix pack level are compatible but a DB2 database and an Oracle database are not compatible. If you use data sources that are not compatible, when you put a message through the message flow to test it, the message flow throws an error. If your data sources are not compatible, you cannot access them from a single node; if this is the case, use additional nodes in your message flow.
* All tables that are referred to in a single SELECT function’s FROM clause must be in the same database."
|
These restrictions apply to both V6.0 and V6.1. Hope this helps.
_________________
DilSe..
Take life as it comes.. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
