Select Data in Other Schemas

tell me more icon Tell me more

A data source node allows you to select any table or view in the current account (schema). In addition to tables in the current account, you can select tables in other accounts that you have permission to use. This cue card set uses data in the Sales History (SH) schema, one of Oracle Database Sample Schemas.

This cue card set requires that the SH schema is installed.

Follow these steps to use data in the SH:

  1. Create a new workflow: In the Data Miner Navigator: expand dmConnection; right-click HighValue; select New Workflow. Name the workflow StarSchemaMining.

    If the Component Palette is not open, open it using View > Component Palette. Make sure that Workflow Editor is selected.

  2. Add the SH schema as a data source, and then create a data source node for the table SH.CUSTOMERS:

    1. In the Component Palette, click the Data section, and left-click Data Source.
    2. Move the mouse to the place in the workflow StarSchemaMining where you want to place the node. Click. The Define Data Source wizard is launched.
    3. Click Add Schemas.
    4. In the Edit Schemas List, move SH from the list of Available Schemas to the list of Selected Schemas. Click OK.
    5. Back in the Define Data Source wizard, select Include Tables from Other Schemas.
    6. The Available Tables list now consists of tables in your schema and tables in SH.
      tell me more icon Tell me more about what I see in the GUI
    7. Select SH.CUSTOMERS; click Finish to include all of the columns.
    8. The new data source node is created. The default name of the node is CUSTOMERS, the name of the table.

  3. Create a second data source node:

    1. In the Component Palette, click the Data section, and left-click Data Source.
    2. Move the mouse to the place in the workflow where you want to place the node. Click. The Define Data Source wizard is launched.
    3. The Available Tables list now consists of tables in your schema and tables in SH.
    4. Select SH.SALES; click Finish.
    5. Another data source node is created. The default name of the node is SALES, the name of the table.

tell me more icon Tell me more about what I see in the GUI

The cue cards icon Next step is to prepare data using an aggregation node.