Connect to a Historian Server

Before you begin

Install Client Tools, which will automatically install the OLE DB provider.
Initialize the COM library on the machine on which you have installed the OLE DB provider.

About this task

This topic provides basic steps to connect the OLE DB provider to a Historian server so that you can import the data. For instructions specific to a client, refer to:

Import Historian Data into Power BI Desktop
Import Historian Data into Crystal Reports
Import Historian data into Microsoft Excel

Procedure

To connect an OLE DB client to a local Historian server, run the following command:
```
Provider=iHOLEDB.iHistorian.1
```

To connect an OLE DB client to a remote Historian server, run the following command:

Provider=iHOLEDB.iHistorian.1;PersistSecurity Info=False;
USER ID=[<Historian server username>];
Password=[<Historian server password>];
Data Source=[<network name of your Historian server>]