IBM Analytics Ideas

Welcome to the idea forum for IBM Analytics Clients! 

 

IBM Employees:

The correct URL for entering your ideas is https://hybridcloudunit-internal.ideas.aha.io

 

Clients:

Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

 

If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.  https://ibm.biz/AnalyticsIdeasPortalRegister

 

Setting to not offer public tables when importing data from a database

This issue is also described here:

https://developer.ibm.com/answers/questions/464796/list-of-tables-when-importing-from-oracle-database.html

This might only concern Oracle databases, but possibly others as well.

In SPSS one can import data from a database. One of the first steps is to select the table or view to read from.
This list of tables/views includes public tables/views, ie granted to PUBLIC (any current and future user).
If there are applications installed in the database the list of public tables/view can be large.

A side-note: the query used by SPSS to find all tables/views available to the user varies depending on the odbc-driver used.
When using an Oracle odbc driver it's possible to modify the database for the connecting user so that public tables are excluded. When using the IBM Wire Protocol driver the query is different and cant be "fixed".

As public tables are sometimes (typically?) not interesting for the user, it would be good if there was a setting in SPSS to ignore them when listing available tables.

  • Tomas Albinsson
  • Oct 4 2018
  • Future Consideration
Role Summary End users
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions