Selecting structures for data connector discovery


1. Overview

When setting up a data connector for most data providers such as for a database, you have the option of selecting which native structures (e.g., tables or cubes) will be discovered and appear in the Explore window. For example, the database you want to connect to may have hundreds of tables but for your current project you only need a few of those tables.

'Tabular' data providers such as Excel do not provide this option.

2. Select structures

When creating a new data connector, or after opening an existing one from the main menu, scroll down and click Select structures.

Click Select Structures
Click Select Structures

In the Select Data Structures dialog, select which native structures you want to be discovered and included under the data connector in the Explore window.

Selected structures
Selected structures

Submit the data connector to begin discovery. After this completes, create a new dashboard and go to the Explore window to see your data connector which should list only the structures you selected.

Data connector showing only the selected structures
Data connector showing only the selected structures

Structures used by downstream elements such as data cubes will still be discovered even if not selected. You can check for these by right-clicking the structure in a file explorer to open its Properties then clicking References.

3. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri