| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [IB9] setting up datasource on Mapping Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| pvsp |
 Posted: Tue Mar 18, 2014 10:58 pm Post subject: [IB9] setting up datasource on Mapping Node |
 |
|
Apprentice
Joined: 17 Feb 2008
Posts: 36
Location: Warsaw, PL
|
Hi,
Is it possible to set up datasource name on Mapping Node (Integration Bus 9) ? I looked at publib doc and I see that it is possible for message broker 7, but Integration Bus 9 does not.
I would like to use mapping node to insert incoming message to db, but I need to have opportunity to set up datasource name dependent on environment. |
|
| Back to top |
|
 |
| martinb |
| Posted: Sun Mar 23, 2014 12:54 am Post subject: |
|
|
Master
Joined: 09 Nov 2006
Posts: 210
Location: UK
|
|
| Back to top |
|
|
| pvsp |
| Posted: Mon Mar 24, 2014 11:44 pm Post subject: |
|
|
Apprentice
Joined: 17 Feb 2008
Posts: 36
Location: Warsaw, PL
|
Ok, so if I understant,
In order to create dbm file using reverse engineering, I need to create JDBC connection in wizzard. I did it, I have Database Model.dbm file with DB2DEV connection configured via wizzard in Integration Developer. Now, I can create JDBC datasource DB2DEV on my aix broker that point to another database and this server configuration overrides my local configuration that I was created using Integration Developer ? |
|
| Back to top |
|
|
| martinb |
| Posted: Mon Mar 24, 2014 11:55 pm Post subject: |
|
|
Master
Joined: 09 Nov 2006
Posts: 210
Location: UK
|
Correct for designing and creation of the Graphical Data Mapping you connect your Integration Toolkit to a database instance to discover the DB schema, tables, columns and stored procedures. These are held in a database definition ".dbm".
When you come to deploy and run the map to a integration bus node you need to create a JDBC Configurable Service in that node with the same name as the data source used in the toolkit. This JDBC Configurable service can connect to the same, or a different database server that has the same database content.
Note that the JDBC Configurable Service also allows you to do things like override the database schema name that might well be different in your dev/test and production database servers. |
|
| Back to top |
|
|
| pvsp |
| Posted: Tue Mar 25, 2014 12:56 am Post subject: |
|
|
Apprentice
Joined: 17 Feb 2008
Posts: 36
Location: Warsaw, PL
|
I have created jdbc configuration and it works very well with my Mapping Node, thanks for hint  |
|
| 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
|
|
|
|
