ODBC connection doesn't allow access to Oracle views, only tables

[William Peck]

I'm able to pull retrieve Oracle data, but only tables. The option to pull in Views (and Synonyms and System tables) are greyed out.

I could have sworn the option for Views was available was I first set it up, but I didn't try it out. But the option to Views is not available.

Using another Oracle tool, I can access views (and synonyms and system tables) (PL-SQL Developer), and using the same credentials for both.

Any ideas on SPSS settings or something that might be preventing this access to Oracle Views?

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[William Peck]

oops, sorry, I got it ...

When selecting the ODBC driver, the first page asks you to check Tables, Views, Synonyms, or System Tables. Then when you connect, the options you chose are selected and the others are grayed out ...

Bill

On Sat, Mar 23, 2019 2:59 PM, William Peck [hidden email] wrote:

I'm able to pull retrieve Oracle data, but only tables. The option to pull in Views (and Synonyms and System tables) are greyed out.

I could have sworn the option for Views was available was I first set it up, but I didn't try it out. But the option to Views is not available.

Using another Oracle tool, I can access views (and synonyms and system tables) (PL-SQL Developer), and using the same credentials for both.

Any ideas on SPSS settings or something that might be preventing this access to Oracle Views?

Bill Peck

Information Technology Services Division

Institutional Research / Business Intelligence

United States Naval Academy

410-293-1475 (w)

410-207-3350 (c)

**** Data is your friend ===> at home, at work, and on the battlefield ****

**** Data is the fuel of your organization ****

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD