Configure the connection information for Data Sources

Oracle

Oracle client connectivity software

Client components of Oracle on the node on which the Data Adapter Service is installed, if used as a data source.

Note: ODAC is required and it has to match with the Oracle Database Server CPU architecture.

Text (CSV)

Microsoft Office client connectivity software. (Microsoft.ACE.OLEDB component available from Microsoft downloads).

For CSV files, following component need to be installed. Select the 64-bit version of the components.

http://www.microsoft.com/en-us/download/details.aspx?id=13255

PI System

• PI System Client connectivity component version 3.3 is required on the data adapter service node.

• PI SQL Data Access Server (Real-Time Query Processing Engine) should be enabled on the PI System Asset Framework Server.

• PI SQL Client should be installed on the machine where the BI Gateway data adapter is installed.