Show TOC

Background documentationODBC Destination System

 

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 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).)

End of the note.

Prerequisites

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:

Integration

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:

  1. Create a source system

  2. Create an ODBC destination system and configure data records for the desired table. (See ODBC Destination System: Configuration Tab.)

  3. Create an agent instance and subscribe to tags

  4. Create a notification and generate the output values automatically on the Output tab by choosing, for example, the Generate Expressions pushbutton.

  5. Select a destination system, and assign destination variables. (See Assignment of Destination Variables to Output Values (ODBC Destination).)

More Information

For more information about ODBC, see:

Wikipedia: http://en.wikipedia.org/wiki/ODBCInformation published on non-SAP site

Microsoft ODBC Overview (MSDN): http://msdn.microsoft.com/en-us/library/windows/desktop/ms710252(v=VS.85).aspxInformation published on non-SAP site