Data Sources

The BI Gateway Server retrieves data from external data sources and provides this data to the reporting, analysis, and other visualization tools at the enterprise level.

Data sources are the external source systems to which you can map the dimensions and measures fields in the BI Gateway model. At run time, the data from the external source systems populates the dimensions and measures as per the mappings.

Data Sources can include the following:

• AVEVA™ Historian

• AVEVA™ Enterprise Data Management

• AVEVA™ Insight

  • AVEVA Insight Historian

  • AVEVA Insight MES

• Microsoft SQL Server Database and Microsoft Azure SQL Server Database

• PI System

  • PI System OLEDB Provider

  • PI System Asset Framework

• Oracle Database

• Text File

You must configure the Data Source objects to provide connection information to the external data source systems. Only deployed data sources are available at run time to the dependent dimensions and measures for data collection.

The connection information for a data source varies depending on the data source type. The connection information is stored in an encrypted format so your credentials are protected by the BI Gateway software.

Data adapters are plug-in components that provide connectivity and retrieval from the data sources.