The ODBC destination system
is a destination system type that you use to be able to connect an ODBC database to PCo and to send notification messages to this database. Using the ODBC destination system, in a selected table in the connected database, you can create data records for specific tags to generate, for example, simple time series' for one or more tags in a history table. With each notification message that is sent to the destination system, one or more new entries are created in the table. You can use the tag values stored in the table for evaluations later.
The following ODBC databases are supported:
MS SQL Server 2008
SAP HANA database
With an ODBC destination
, you can configure the following:
For the configuration, you can choose any table that you have defined already in the connected database, for example, in the SAP HANA database.
From the given table structure, you can choose the fields that you want to be filled with tag values or fixed values based on the notification messages.
If required, you can create a table from PCo. This table has a predefined structure based on the idea of generating simple time series (tag ID, time stamp, tag value) using PCo. This table is created automatically in the connected database after saving.
As soon as the agent instance is running, the tag values are stored as table entries according to the field assignment made, with each notification message in the selected table. The history tables generated in this way are then available for all types of evaluations.
Note
You can also use an ODBC destination system in enhanced notification processing if the destination system's response is to be processed. (See Integration with Third-Party Systems Using Enhanced Notification Processing (ENP).)
You can only create an ODBC destination system if you have previously configured the connection to the desired database in the ODBC Data Source Administrator:
To be able to send tag values and metadata with notification messages to the database and save them persistently in a table, the following configuration steps are necessary:
Create a source system
Create an ODBC destination system and configure data records for the desired table. (See ODBC Destination System: Configuration Tab.)
Create an agent instance and subscribe to tags
Create a notification and generate the output values automatically on the Output
tab by choosing, for example, the Generate Expressions
pushbutton.
Select a destination system, and assign destination variables. (See Assignment of Destination Variables to Output Values (ODBC Destination).)
For more information about ODBC, see:
Wikipedia: http://en.wikipedia.org/wiki/ODBC
Microsoft ODBC Overview (MSDN): http://msdn.microsoft.com/en-us/library/windows/desktop/ms710252(v=VS.85).aspx