Wonderware Historian Database Import Export Utility

Overview

The AVEVA Historian Database Import/Export Utility streamlines the process of importing and exporting the AVEVA Historian Server database. It is an essential tool for efficient archiving and effective troubleshooting.

Creating an IDAS

Users may need to manually create an IDAS (Industrial Data Access Server) to manage data points within the Historian. This utility simplifies the process of adding tags to an IDAS, even without an InTouch HMI or existing AVEVA InTouch application.

Import Tags Feature

Utilize the Import Tags feature of the AVEVA Historian to add tags to an IDAS, enhancing the utility's flexibility and ease of use for managing AVEVA Historian data.

Exporting and Importing Data

The utility enables users to export the Historian database to a text file, facilitating easy data transfer and backup. Importing the text file back into the database is equally streamlined, ensuring data integrity and accessibility.

Committing Changes

After importing data from the text file, it's crucial to Commit Pending Changes to finalize the process and maintain database accuracy.

Best Practices

For archiving or troubleshooting, utilize the database export/import utility. Always Commit pending changes post-import to ensure the Historian reflects the latest data.

Troubleshooting

Access the AVEVA Historian Database Import/Export Utility via Start -> AVEVA Historian -> Database configuration export and Import menu. Ensure you have the correct SQL Server or Windows authentication credentials and the directory for the database text file is properly set.

Frequently Asked Questions

How do I access the AVEVA Historian database import/export utility?

The import/export utility is accessed from the AVEVA Historian Start menu by navigating to Start -> AVEVA Historian -> Database configuration export and Import.

What are the main uses of the AVEVA Historian database import/export utility?

The utility is primarily used for archiving data and troubleshooting within the AVEVA Historian environment.

Can I view multiple data points without an InTouch HMI application using the import/export utility?

Yes, the utility allows developers to view many data points without an InTouch HMI application by creating an IDAS in AVEVA Historian.

What do I need in order to use the import/export utility?

You need valid SQL Server or Windows authentication credentials and to specify the directory where the text file for import or export is located.

What should I do after importing tags using the import/export utility?

After creating or importing tags, you should use the commit pending changes function to finalize the changes.

Common Use Cases

• 
  Use case 1: Automating the backup of historical industrial process data
• 
  Use case 2: Migrating data between different production environments
• 
  Use case 3: Integrating process data with third-party analytics tools for advanced analysis
• 
  Use case 4: Restoring historical data after a system failure or data corruption
• 
  Use case 5: Exporting data for compliance reporting and audits

Why Choose Sourcetable Over Wonderware Historian Database Tools

Discover a seamless data integration experience with Sourcetable, the superior alternative to Wonderware Historian's import and export utilities. By centralizing data from diverse sources, Sourcetable simplifies data management and enhances accessibility.

Sourcetable provides a spreadsheet-like interface that allows for real-time data queries, offering an intuitive and user-friendly approach to data manipulation. Unlike traditional database tools, Sourcetable requires no complex setup, streamlining your workflow.

Experience the agility of manipulating database information in real-time with Sourcetable. Its dynamic interface transcends the limitations of Wonderware Historian, enabling efficient data handling and decision-making in fast-paced environments.