Hi - I’m defining a new connection to use the Oracle Transparent Gateway to get at a DB2 (version 4.1) data mart on our mainframe.
In Designer, no cols appear in the Structure Window, however I can successfully do a ‘view table values’ and see the data. Also, when I drag the tables over to the Universe Window, the cols don’t appear there either. Hence, not a very usable universe.
Has anyone had a successful experience in using the Transparent Gateway (version 3.1.0)
Check the privileges of the userid you use in Designer to connect to your datasource. What you describes rings a bell: a client of mine was connecting to his database without having the proper grants (SELECT, UPDATE…) and Designer was acting consequently ‘funky’.
If your privileges are ok, I suggest you check with the Oracle Transparent Gateway: make sure that the grants defined at the DB level are identical to the grants defined at the gateway level. Also check if the userid (defined on the DB - you use it in Designer) is defined also at the Gateway level.
-ACB.
snip!!! <
In Designer, no cols appear in the Structure Window, however I can successfully do a ‘view table values’ and see the data. Also, when I drag the
tables over to the Universe Window, the cols don’t appear there either. Hence,
not a very usable universe.