| Author |
Message
|
| iasmanju |
 Posted: Thu Aug 21, 2014 3:49 am Post subject: Accessing Synonyms in Mapping node. |
 |
|
Newbie
Joined: 11 Aug 2007
Posts: 8
Location: Bangalore
|
Hello All,
I am trying to access synonyms in Mapping node. I have created Data definition file. I am unable to see the tables and columns avaialble from the synonyms in Mapping node but tables I can access. Is this a restriction in Mapping node ?
Any other apporach to access synonyms in Mapping node?
_________________
WMQ Ceritified |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Aug 21, 2014 4:20 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
First you select the tables, then you select the columns. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| iasmanju |
| Posted: Thu Aug 21, 2014 4:53 am Post subject: |
|
|
Newbie
Joined: 11 Aug 2007
Posts: 8
Location: Bangalore
|
No columns displayed in the columns tab in mapping node
_________________
WMQ Ceritified |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Aug 21, 2014 4:55 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| iasmanju wrote: |
| No columns displayed in the columns tab in mapping node |
Have you ruled out it being a permissions problem on the DB?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| iasmanju |
| Posted: Thu Aug 21, 2014 4:59 am Post subject: |
|
|
Newbie
Joined: 11 Aug 2007
Posts: 8
Location: Bangalore
|
No issues with permission as I am able to access in esql.
_________________
WMQ Ceritified |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 21, 2014 5:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| iasmanju wrote: |
| No issues with permission as I am able to access in esql. |
Well, ok, but that has nothing to do with Mapping node or Toolkit command-assist.
Toolkit requires a database model, built using JDBC, to allow you to put things into Mapping node.
Did you try regenerating your database model in Toolkit? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Aug 21, 2014 5:04 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| iasmanju wrote: |
| No issues with permission as I am able to access in esql. |
AFAIK the mapping node uses JDBC. Did you set up the JDBC configurable service?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 21, 2014 5:08 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| fjb_saper wrote: |
| iasmanju wrote: |
| No issues with permission as I am able to access in esql. |
AFAIK the mapping node uses JDBC. Did you set up the JDBC configurable service? |
The JDBC configurable service only exists in runtime. How would that help with building the required map in Toolkit. |
|
| Back to top |
|
|
| iasmanju |
| Posted: Thu Aug 21, 2014 6:00 am Post subject: |
|
|
Newbie
Joined: 11 Aug 2007
Posts: 8
Location: Bangalore
|
We had only SELECT access to the table so I have asked DBA to provide us DESC permission too. Waiting for the same. will update if it works fine after the change.
_________________
WMQ Ceritified |
|
| Back to top |
|
|
| akil |
| Posted: Fri Aug 22, 2014 5:29 am Post subject: |
|
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
Hi
How did you create the synonyms in the data project ?
What I usually do is create a table definition in the data project ( the table name = the synonym that's created in the database ), then I use the mapping node to do the mapping.
At runtime, this works because as far as the mapping node is concerned, it fires a query ( which gets executed against the synonym )..
_________________
Regards |
|
| Back to top |
|
|
| vaishnav.piyush |
| Posted: Wed Sep 09, 2015 1:37 am Post subject: Synonyms not available in GDM |
|
|
Novice
Joined: 16 Mar 2009
Posts: 14
|
Hi
I am also facing same problem. The synonyms are added in my data definition project. However, I can't see any of the synonyms while trying to use it in the Graphical Data Mapper in mapping node.
Has anybody found the solution to this issue ? |
|
| Back to top |
|
|
|
|
