Add a data source

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

Add a data source

1. Open the AVEVA 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 AVEVA 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 section, select one of the following in the Data Adapter Type list:

   • Select AVEVA Insight if you want to use AVEVA Insight as a data source. For more information about AVEVA Insight, refer to the AVEVA Insight Help.

   • Select Microsoft Azure SQL Database if you want to use Microsoft Azure SQL Database as a data source.

   • Select Generic Rest API if you want to use Generic Rest API as a data source.

5. In the Data Source Configuration section, enter the configuration details for AVEVA Insight, Microsoft Azure SQL Database, or Generic REST API.

   • For information on configuring an AVEVA Insight connection, see Configure the AVEVA Insight connection.

   • For information on configuring a Microsoft Azure SQL Database connection, see Configure the Microsoft Azure SQL database connection.

   • For information on configuring a Generic Rest API connection, see Configure the Generic REST API connection.

6. Click Connect. If the connection succeeds, the Getting schema notification message appears. It can take a few minutes to validate the datasource connection.

7. Click Done and then click Save.

Security guidelines for source databases

When configuring a data source in the AVEVA BI Gateway Model Builder, it is a security best practice to use an account that only has read permissions to the data source. If the use of Stored Procedures is required (for example, Custom Queries), you may need to grant that account Execute permissions to these particular stored procedures, on top of the read-only permission. Ensure proper testing during the AVEVA BI Gateway Model design.