Adding a Data Source

You can add a data source that allows you to map the dimensions and measures fields in the BI Gateway model.

To add a data source

1. Open the BI Gateway Model Builder.

2. Click the Add () icon in the Floating Action Buttons menu and then click the Data Source () icon. A new data source is added in the BI Gateway model with a default name and the Data Source editor appears in the right pane.

   

3. Click the General tab, and then do the following:

   1. In the Name box, type a new name for the data source. The data source name must be unique and can have a maximum length of 32 characters.

   2. In the Description box, type a description for the data source. The description must be less than 1024 characters.

4. In the Data Adapter Service area, do the following:

   1. In the Server name box, type the name of the server where the BI Gateway Data Adapter service is installed and configured.

   2. In the Port box, type the port number of the server where the BI Gateway Data Adapter service is configured. By default, the value is 8732. You can specify any port number value between 0 and 65536.

   3. In the DataAdapter Type box, select the required data adapter.

5. In the Data Source Configuration section, configure the settings for the required data source. For more information, see Configuring the Connection Information for Data Sources.

   NOTE: The data source configuration options may vary depending of the DataAdapter type selected.

6. Click Connect. If the connection succeeds, the Getting schema notification message appears. It can take few minutes to retrieve the schema from the data source.

7. Click Done and then click Save.