Import Historian Data Into Excel by Creating a UDL File
About this task
This topic describes how to create a UDL file with connection information and then
import Historian data into Excel using the UDL file. You can also provide the connection
details manually or
using the sample UDL
file.
Procedure
Create a UDL file with connection details:
Create a text document.
We recommend that you use the My Data Sources
folder in the My Documents folder.
Rename the file extension .UDL.
Double-click the .UDL file.
The Data Link Properties window
appears.
Select Provider > Historian OLE DB Provider > Next.
The Connection section appears in the
Data Link Properties window.
Leave these fields empty to use the default server and the currently logged-in
user. Otherwise, do the following:
In the Data Source field, enter the Amazon Network Load Balancer (NLB) DNS..
Tip: To find the NLB DNS:
Access the EKS cluster on which you have deployed Proficy Historian for AWS.
Access the EC2 instance.
In the navigation pane, under Load Balancing, select Load Balancers.
Select the load balancer for which you want to find the DNS.
In the Description section, copy the DNS name.
Clear the Blank Password check box.
Enter a Windows username and password.
Select the Allow Saving Password check box if
applicable.
Select Test Connection to confirm that the data source,
username, and password provide a successful connection, and then select
OK.
The Select Database and Table page appears in the
wizard.
Select Data > Import External Data > Import Data.
The Select Data Source window appears.
Select the .UDL file that you have created, and then
select Open.
The Select Table window appears.
Select the table that you want to query, and then select
OK.
The Import Data window appears.
Note: If you want to
run a SQL command instead of the default table command setting, refer to
Edit SQL Queries in Excel.
Select OK to import the column data from the selected
table.
