I work on a site that is comprised of a number of streets. I wish to develop a display that shows which of the streets are currently blocked to traffic. I have an SQL database containing the information and a schematic of the site.
If you are having smaller number of records then recommend to use AF table linked to SQL. Using element relative and template based approach you can map to processbook. You can also use AF analysis for further calculations if any. If data source is big then would recommend RDBMS interface.
Thanks so much for the help.
In addition Lal Babu Shaik suggestion, I like to add one more thing that you can create the ProcessBook ODBC Dataset to access the SQL database data similar to accessing PI Points from PI Server. Please refer the below links for more details,
How to manipulate ODBC Datasets dynamically using VBA - Example that updates a trend
Thanks for your help.
Retrieving data ...