Historian Value to InTouch Tag

The challenge here is the statement that you programmatically is inserting data to Historian. I presume with the tag configured as Manually Acquisition.

If it was I/O Server Acquisition then the value would pass the 'Runtime Window'. Providing data in Live values retrieval.

To connect InTouch to Historian it is normally enough to create an access name connecting to the Historian Suitelink Provider using an access name. ( Application Name aahiosvrsvc, topic: tagname

And create a tag connecting to the tag in Historian using the tagname as Item.

The problem here is that the Manual tags are not available through this since it does not pass through the same path as acquired tags.

Perhaps someone has a better idea, but you might need to set up a SQL connection against Historian and query to get the latest value and pass these into InTouch.

How often/fast does your manual tags update?

 You are absolutely right, they are Manual tags. 
I tried the proposed way before creating the thread and yes, I was not able to retrieve the values. 

Should I configure my tags as IO acquired tags and set my code to programmatically insert LATEST data? (hacky)

As for the script needed to set up a connection and retrieve the value to a tag, I search everywhere in the documentation and I found nothing about this. Is it possible that you have a code example? 

The tags are process KPI tags, so they are updated once a minute

 You are absolutely right, they are Manual tags. 
I tried the proposed way before creating the thread and yes, I was not able to retrieve the values. 

Should I configure my tags as IO acquired tags and set my code to programmatically insert LATEST data? (hacky)

As for the script needed to set up a connection and retrieve the value to a tag, I search everywhere in the documentation and I found nothing about this. Is it possible that you have a code example? 

The tags are process KPI tags, so they are updated once a minute

Hi Dimitris Papalekas , this is done via SQL query and SQL stored procedure. if you have installed historian client, you can choose the Query option and find the value you need

You are right! 
I also tried with symbol scripting and it worked!

Thank you everyone

Hi, can you send the script code or whatever you have done here, it would save me some time for another customer

Dim objDB As System.Data.SqlClient.SqlConnection;
Dim objCmd As System.Data.SqlClient.SqlCommand;
Dim objDR As System.Data.SqlClient.SqlDataReader;
Dim objTbl As System.Data.DataTable; 
Dim sDBConnStr As String;
Dim sSQL As String;
Dim valuesArray as System.Data.DataTable;

Text2.Text =  $DateString +" "+ $TimeString;

sDBConnStr = "Server=labwork;Database=Runtime;User Id=sa;Password=sa;";

' Connect and open the database
objDB = New System.Data.SqlClient.SqlConnection(sDBConnStr);
objDB.Open();

sSQL = "SELECT [Value] FROM [Runtime].[dbo].[v_AnalogHistory] Where TagName in ('Mixer100_Temperature_PV_rate_hourly','Mixer200_Temperature_PV_rate_hourly','Mixer300_Temperature_PV_rate_hourly','Mixer400_Temperature_PV_rate_hourly') and DateTime =' "+ $DateString + " " + $TimeString + "' ";

' Invoke the SQL command 
objCmd = New System.Data.SqlClient.SqlCommand(sSQL, objDB);

' Retrieve the queried fields from the query into the reader
objDR = objCmd.ExecuteReader();

valuesArray= new System.Data.DataTable;
valuesArray.Load(objDR);

testmanualtag=valuesArray.Rows[0][0];
testtag3=valuesArray.Rows[1][0];
testtag_2=valuesArray.Rows[2][0];
testtag_30067=valuesArray.Rows[3][0];

objDR.Dispose();
objDR.Close();
objDB.Close();

Hi, Sorry for my late reply. This is our solution

Hi Dimitris, thanks for the code, this looks like it's done using Intouch scripting and SQL query, wouldn't it be better to use SQL stored procedure and then call the procedure ?