KB18704: Tables are not visible in the Warehouse Catalog when using HP Neoview 2.0 Database

SYMPTOM:
When using HP Neoview 2.0 as the warehouse database, the user is not able to see all the database tables via the Warehouse Catalog. The user can see them using ODBC Test Tool and Native Querying Tools, but they are missing in the catalog.
 
CAUSE:
The SQL used by default by the HP Neoview 2.0 driver does not bring all the existing tables in the database.
 
WORKAROUND:
The workaround consists in using ODBC commands to bring the tables to the Warehouse Catalog instead of using SQL statements. To accomplish this, users must make a temporary change in the configuration of the database instance to use a different SQL statement to read the tables from the database. Users must do the following:
 

• Go to the warehouse Database Instance in Strategy Developer and select 'Generic DBMS' in the 'Database connection type' field, as shown below:
  

• Open the Warehouse Catalog and go to 'Warehouse Catalog Options'. Change the 'Read Settings' by selecting 'Use standard ODBC calls to obtain the database catalog', and select OK, as shown below:
  

• Import the tables desired for use in Strategy by running the 'Read the warehouse catalog' to update the warehouse catalog, as shown below:
  

• Return to the previous configuration of the Database Instance, by changing the 'Database connection type' from 'Generic DBMS' back to 'HP Neoview 2.0'.