Add a data source

Pentaho Schema Workbench

Part Number
Your data source must be available, its database driver JAR must be present in the /pentaho/design-tools/schema-workbench/drivers/ directory, and you should know or be able to obtain the database connection information and user account credentials for it.

Follow the below process to connect to a data source in Schema Workbench.

  1. Establish a connection to your data source by going to the Options menu and selecting Connection.
    The Database Connection dialog box appears.
  2. Select your database type, then enter in the necessary database connection information, then click Test. When you've verified that the connection settings work, click OK.
    The database connection information includes the database name, port number, and user credentials. If you don't know what to type into any of these fields, consult your database administrator or database vendor's documentation.
    Note: The Require Schema check box, when selected in the Options menu, puts Schema Workbench into a mode where unpopulated elements appear in the schema.
    Note: If you are using an Oracle data source, selecting Require Schema will dramatically improve your analysis schema load time.
  3. If you required a database schema in the previous step, you must now define it by going to the Options section of the database dialog box, and creating a parameter called FILTER_SCHEMA_LIST with a value of the schema name you want to use.
Your data is now available to Schema Workbench, and you can proceed with creating a Mondrian schema.