• State Not Answered
  • Replies 2 replies
  • Subscribers 3 subscribers
  • Views 111 views
  • Users 0 members are here
Options
Related

Reference elements between AF Databases

ymenelet_bel

Let's say I have 2 AF databases on the same SQL Server and reachable from the same AF Server,

One which is a functionnal one, describing our process

The second one which is the one connectors use for their configuration and raw output


image.png
Usually, when we use connectors, we tend to clean up a bit the useful data by cherry-picking what we want to display in the functionnal one, so we mostly rely on the tags that are created

 

I'm using Wonderware's connector that replicate what's in WW Historian, it is automatically gathered and updated in the Connector AF Database

 

But as WW is an historian, it carries some functionnal hierarchy that I'd like to keep and not maintain manually so I'd like to reference the created element from the Connectors Database in the functionnal one

 


image_1.png
 

Is there a way to do that ?

Parents
  • 0

    Databases are isolated units, so there is not a native way to do what you're trying to. Also, that WW Connector is on its way out - the preferred method is to use AVEVA Historian replication (there's some issues with digital states, but that should hopefully be resolved soon).

     

    To do what you're looking at, a simple, no code, method would be to do a PI Builder export & import from your connector database to the desired database. You'll manually have to pull & upload on whatever your desired cadence is, but it wouldn't require writing any code to automatically do it.

Reply
  • 0

    Databases are isolated units, so there is not a native way to do what you're trying to. Also, that WW Connector is on its way out - the preferred method is to use AVEVA Historian replication (there's some issues with digital states, but that should hopefully be resolved soon).

     

    To do what you're looking at, a simple, no code, method would be to do a PI Builder export & import from your connector database to the desired database. You'll manually have to pull & upload on whatever your desired cadence is, but it wouldn't require writing any code to automatically do it.

Children
No Data