Oracle Transparent Gateway

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)

We’re running BO 4.1.2 on Oracle 7.3.

Thank you.


Listserv Archives (BOB member since 2002-06-25)

Lisa,

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.


Listserv Archives (BOB member since 2002-06-25)