| Author |
Message
|
| santy |
 Posted: Thu Mar 08, 2007 2:47 am Post subject: problems with DataInsert node |
 |
|
Centurion
Joined: 03 Nov 2006
Posts: 141
|
Hi
I am trying to use DataInsert node for the firdt time.
Flow is simple:
Mqinput -> DataInsert -> Trace
In DataInsert node properties,I gave Datasource name as EMPLOYEE ( ODBC system DSN )
But When I open a map I am not able to see anything on the target side whereas source side shows all message sets in workspace.
Please let me know What am I missing on the target side.
PS: WMB6.0 , Win XP
regards,
Santy |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Mar 08, 2007 6:11 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
A database definition for the database.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| pottas |
| Posted: Sun Dec 14, 2008 4:56 am Post subject: |
|
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
....OK Jeff... this is where I miss you...
I understand - a Database Definition is the actual database.
I have the same problem - I don't get any selectable items on the target side of the mapping trying to use a DataInsert node. I do have a database - I can connect to it using my broker user 'mquser' via ODBC Connections...
I have the node configured as :
Data source: DNPCDD01
Transaction: Automatic
I looked through all the posts on this forum that addresses the DataInsert Node but nothing that can get me in the right direction.
What am I doing wrong? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Dec 14, 2008 5:13 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Quote: |
....OK Jeff... this is where I miss you...
I understand - a Database Definition is the actual database. |
Not quite. I understand that in order to use the node the way you want you really need 2 things.
a) a DB declaration / setup so that the toolkit understands how to connect
b) a DB definition so that the toolkit understands what tables and fields are available?
Check in the resource view part of the toolkit. You should find further information there...
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| hopsala |
| Posted: Sun Dec 14, 2008 5:53 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
In order to use database mappings, you need database definition files in your workspace.
Go into the "Data" perspective in the toolkit, right click and select "New" and "Database". After you've defined the database define a schema and then the table and columns you wish to see in the map.
Keep in mind that this is a static representation of your tables - it does not get updated when you change your tables. You have to maintain it manually. |
|
| Back to top |
|
|
| pottas |
| Posted: Sun Dec 14, 2008 9:34 pm Post subject: |
|
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
fjb_saper / hopsala,
Thank you very much - I got to it - rather easy... now it makes sense!thanks again!
pottas |
|
| Back to top |
|
|
|
|
