Selecting the data source table from a relational database

On the Import tab, select the Relational data source option in Data source type. Select the database that contains the structures from the Data source drop-down list, or select Browse in the list to connect to a relational database.

If you use a source frequently and save information about the origin of imported elements, create a registration in the Connections table and assign it to a data source ID in the table Data Source. The source is then available in the Data source drop-down list and can be used for import.

Select the table that you import from the drop-down list Table. The structure of the table is shown when you select the Schema tab in the import table on the Import tab. Save the table selection with the Save Profile button. For quick access to saved profiles, profiles are the first entries in the Table drop-down list.

When you double-click a cell in the Mappings column, you can map the columns of the relational data source table to the columns of the selected dimension.

To view the data that will be imported from the relational data source, click Data beneath the import table.