How to Configure NextGen Archiving in WinCC OA to use a Microsoft SQL Server

Back to Table of Contents

1. Create a new project with NGA configured.
   1. When creating a new project, proceed with the project setup as normal.
   2. Under the “General Settings” step, ensure that the Use NextGenArchiver option is selected.
   3. For this demo, I’m creating a project titled NGA_Demo located in the “C:/WinCC_OA_Proj” directory.

If converting an existing project from HDB/RDB to NGA, then follow these steps in the “Converting existing project to NextGen Archiver Project” section: NGA Notes and Restrictions. 

Back to Table of Contents

It’s time to fire up OA and open GEDI.

1. Create new back-end.
   1. Navigate to the “Database Engineering” window via “SysMgm/Database/Database Engineering”.
   2. Under the “Backend list”, click the + icon (Add new backend).
   3. Name the Backend a user-friendly name.
      1. I used the title MSSQLEXPRESS.
      2. NOTE: The Backend name does not need to match the server name, so use a name that makes most sense for your application.

2. Configure the MS SQL Backend “General Settings – Basic Co nfiguration”. 

1. Specify the following parameters:

1. NOTES:
   1. The Profile option cannot be changed later.
   2. If using a redundant server, use the MSSQL option for Profile.
   3. Don’t worry about specifying the Password, the field will clear upon initial configuration saving.
2. Click the Password field, enter the winccoaPassword from db.windows.config, and click OK.

3. Configure the MS SQL Backend “Extended Settings”.

1. Specify the following parameters:

4. Finish MS SQL Backend setup

1. Select the Active option.
2. Click Save.

Back to Table of Contents

Now that the database connection has been established, we can set up Archive Groups.

1. Create new archi ve group
   1. Navigate to the “Runtime Engineering” window via “SysMgm/Database/Runtime Engineering”.
   2. Under the “Archive Groups”, click the + icon (Add a new group).
   3. Name the Archive Group.
   4. I used the title DEMO.
   5. Ensure the Active option is selected.
   6. Configure the “Storage Settings” section as desired.
   7. Click Save.

2. Verify SQL Archive Group Creation

1. Open Microsoft SQL Server Management Studio.
2. Right click dbo.archive_groups and select the Select Top 1000 Rows option.
   1. The new archive group should be visible in the “Results” section.

Back to Table of Contents

Now that we’ve created an archive group, we can apply the archive group to a DPE so that its historical data can be logged and tracked.

1. Insert _archive config
   1. Within PARA, right click the target DP or DPE and select the Insert config option.
   2. Select Archive settings.
   3. Click OK.

2. Select archive group

1. Underneath the target DP/DPE, select the new _archive option.
2. Select the desired archive group in the “Archive Group” drop-down.
3. Ensure the Active option is selected.
4. Click OK.

3. Verify SQL Archive Group Application

1. Open Microsoft SQL Server Management Studio.
2. Right click dbo.elements and select the Select Top 1000 Rows option.
   1. The newly configured DPE(s) should be visible in the “Results” section. 

Back to Table of Contents

Now that DPEs have been configured with archiving capabilities, we can now retrieve DPEs’ historical data.

1. Verify SQL DPE Archiving.
   1. Open Micorosft SQL Server Management Studio.
   2. Right click dbo.event_<segment_id>_a and select Select Top 1000 Rows.
      1. The segment_id for each archive group can be found in the dbo.segments table.
   3. If values have been changed since archiving was configured, entries should be visible in the “Results” section.

2. Retrieve historical data.

1.  The WinCC OA functions dpGetPeriod() and dpQuery() can be used to retrieve historical data.
   1. The two examples below demonstrate a test panel running each of the two aforementioned functions and printing the results to the Log Viewer.
   2. The returned data should reflect that viewed in the Micorosft SQL Server Management Studio tables.
2. Be sure to understand your server’s backup and retention policy to determine what data and how much historical information can be accessed.

NOTE: For help writing SQL queries, use the SQL Panel found in SysMgm/Reports/SQL-Query