Specifying a Data Source for a Cube

You specify a data source for a cube as follows:

  1. Create a data source in your PDM from the List of data sources or by right-clicking the model in the browser and selecting New > Data Source from the contextual menu.
  2. Select the OLE DB tab and specify the kind of data provider.

  3. Click the ellipsis tool to the right of the connection string field to open the provider-specific configuration dialog.

  4. Complete the parameters appropriately, click Apply to Connection String, and then Test Connection. Then click Ok to return to the data source property sheet.
  5. Click OK to return to your model.

When you have created the appropriate data sources, you can proceed with generating your cubes.

Parent topic: Generating Cubes