Uploaded image for project: 'Pentaho Schema Workbench'
  1. Pentaho Schema Workbench
  2. PSW-135

Schema Workbench loads all Tables in all Schemas

    Details

    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Windows 7 (64-bit)

      Description

      Schema Workbench loads all tables when connected to Oracle.

      My Setup:
      Windows7 x64
      Java Version 1.6.0_24-b07
      Schema Workbench: 3.3.0.14703
      Oracle Server Version : 11.2.0.3.0 x64
      Oracle Client: 11.1.0.x x86
      Connection Type: Oracle
      Access: Native JDBC

      I can Test-Connect to Oracle without a problem, i know there is an option in Advanced "The preferred schema name..."
      I put my schema name there but it seems that it is ignored.

      Schema workbench issues the statement "SELECT username AS table_schem FROM all_users ORDER BY table_schem" after configuring the datasource and pressing OK.
      So all Schemas are read and therefore, all tables.

        Issue Links

          Activity

          Hide
          unficyp Gerald Weber added a comment -

          hi,

          any news ?
          thx

          Show
          unficyp Gerald Weber added a comment - hi, any news ? thx
          Hide
          bbruce Brandon Bruce (Inactive) added a comment -

          I connected to an oracle database on dev-ju1 with foodmart set as the preferred schema. I then created a schema, cube and table, the table dropdown shows all schemas in the database.

          Show
          bbruce Brandon Bruce (Inactive) added a comment - I connected to an oracle database on dev-ju1 with foodmart set as the preferred schema. I then created a schema, cube and table, the table dropdown shows all schemas in the database.
          Hide
          wgorman Will Gorman (Inactive) added a comment -

          Hi Brandon, please follow these instructions from the doc to see if the schemas are filtered correctly:

          "If you required a database schema in the previous step, you must now define it by going to the Options section of the database dialogue, and creating a parameter called FILTER_SCHEMA_LIST with a value of the schema name you want to use."

          Here is a link to the doc:

          http://kb.pentaho.com/kb/#kbroot/Documentation/Pentaho_BI_Suite_EE/4.1/analysis_guide/analysis_guide/task_psw_data_source.html

          Thanks,

          Will

          Show
          wgorman Will Gorman (Inactive) added a comment - Hi Brandon, please follow these instructions from the doc to see if the schemas are filtered correctly: "If you required a database schema in the previous step, you must now define it by going to the Options section of the database dialogue, and creating a parameter called FILTER_SCHEMA_LIST with a value of the schema name you want to use." Here is a link to the doc: http://kb.pentaho.com/kb/#kbroot/Documentation/Pentaho_BI_Suite_EE/4.1/analysis_guide/analysis_guide/task_psw_data_source.html Thanks, Will
          Hide
          rfellows Rob Fellows added a comment -

          By adding the FILTER_SCHEMA_LIST parameter (with value = to the desired schema) in the Options section of the Connection dialog filters the schemas retrieved from oracle as described in the KB article.

          Show
          rfellows Rob Fellows added a comment - By adding the FILTER_SCHEMA_LIST parameter (with value = to the desired schema) in the Options section of the Connection dialog filters the schemas retrieved from oracle as described in the KB article.

            People

            • Assignee:
              bbruce Brandon Bruce (Inactive)
              Reporter:
              unficyp Gerald Weber
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: