Install the Historian ETL Tools

Before you begin

  • If you want to use the Historian Extract, Transform, and Load (ETL) tools to transfer data from a PI Historian server, install the PI SDK package.
  • If you want to use the ETL tools to transfer data from an eDNA server, copy the following eDNA binaries to the <installation drive>\Program Files\GE Digital\Historian ETL eDNA Extract folder:
    • EzDnaApi.dll
    • EzDNAApiNet.dll
    By default, these files are available in the following folder on the machine on which the eDNA server is installed: C:\Program Files(x86)\eDNA

About this task

Installing ETL installs the following tools:
  • The Extract tool
  • The Transform tool
  • The Load tool
This topic describes how to install ETL to extract, transform, and load data from an onsite Historian machine to the destination Historian server. You must install Historian ETL on both the onsite Historian machine and the destination Historian server (that is, the source and destination machines for data transfer).

Procedure

  1. Run the InstallLauncher.exe file.
  2. Select Install Historian ETL Tools.
    The welcome page appears.
  3. Select Next.
    The license agreement appears.
  4. Select the Accept check box, and then select Next.
    The default installation drive appears.
  5. If required, modify the installation drive for Historian ETL, and then select Next.
    A message appears, stating that you are ready to install ETL.
  6. Select Install.

Results

The Historian ETL tools are installed on your machine.
  • The following folders are created in the <installation drive>/Program Files/GE Digital folder:
    • Historian ETL eDNA Extract
    • Historian ETL Extract
    • Historian ETL Load
    • Historian ETL ODBC Extract
    • Historian ETL PI Extract
    • Historian ETL Transform
  • The following services are installed:
    • Historian ETL eDNA Extract
    • Historian ETL Extract
    • Historian ETL ODBC Extract_x64
    • Historian ETL ODBC Extract_x86
    • Historian ETL Load
    • Historian ETL PI Extract
  • The following registry paths are created:
    • HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\GE Digital\Historian ETL eDNA Extract
    • HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\GE Digital\Historian ETL ODBC Extract
    • HKEY_LOCAL_MACHINE\SOFTWARE\GE Digital\Historian ETL Extract
    • HKEY_LOCAL_MACHINE\SOFTWARE\GE Digital\Historian ETL ODBC Extract
    • HKEY_LOCAL_MACHINE\SOFTWARE\GE Digital\Historian ETL PI Extract
    • HKEY_LOCAL_MACHINE\SOFTWARE\GE Digital\Historian ETL Load

What to do next

  1. If you want to extract data from an eDNA server, copy the Customdna.ini file in the eDNA server into the C:\Windows folder on the machine on which you have installed ETL.
  2. Extract data from an eDNA server, ODBC data source, Proficy Historian, or PI Historian.