Configuring a Data Exporter Storage

A data storage defines where the Data Exporter writes exported data: the connection type and the connection details for one destination. Several tasks can share one storage. For the storage types and the credentials each one uses, see Data Export and Integration in Data Historian.

To configure a data storage:

Open Workbench and in Project Explorer, expand your project > Historical Data > Data Historian > Data Exporters.
Right-click Storage and select Add Data Storage. The data storage configuration opens.
In Name, enter a name for the storage.

In Connection Type, select the type of storage, and then complete the fields for that type. Workbench builds the Connection String from these fields.

Connection Type	Fields
Amazon S3	Region, Bucket Name, Access Key, Secret Key
Azure Data Lake Gen2	Storage Name (the storage account name), File System, Shared Key
Hadoop File System	Root Folder, User Name, Password, Host, Port
Local CSV Files	Root Folder
SQL / Azure SQL	None. Use (Configure connection) to build the connection string, as described in the next step.

For SQL / Azure SQL only, select (Configure connection) and in the Select a logging database dialog, do the following:
1. In SQL Server, select or enter the SQL Server instance.
2. In Authentication, select Use Windows NT Integrated Security, Use SQL Security, or Use Entra ID Security. For SQL Security and Entra ID Security, enter the User name and Password. Learn more
3. In Database, select the database.
4. Select Next. The dialog closes, and the connection string appears in Connection String.

(Optional) In the Advanced section, change how the Data Exporter writes to the storage:

Setting	Description	Default
Batch Size	Number of values sent to the storage in a single batch	10,000
Retry Count	Maximum number of consecutive retries when a write fails	5
Retry Delay	Minimum time to wait between retries	1 minute
Copy Timeout	Time allowed for a data transfer	1 minute

Select Apply.