Configure an ODBC database log destination

Use
ODBC Database Destination Setup
 to send messages to an ODBC data source. To send messages from multiple computers, configure the destination on each computer where the
FactoryTalk Diagnostics
 service is installed. FactoryTalk Diagnostics cannot log to a remote database using Microsoft Access. You can only log to a local database using Microsoft Access.
The ODBC Database destination supports these ODBC-compliant databases:
  • Microsoft®
    SQL Server®
  • Access®
  • Oracle®
Some types of information cannot be logged to an ODBC database destination. These include:
  • Any additional database fields not included in the ODBC table format that a
    FactoryTalk
     product might use. Even if you create the additional fields manually, nothing will be logged to them. The additional information logged by a
    FactoryTalk
     product will, however, appear in the local log on the computer where the product is installed. See documentation for the products you are using to determine whether they make use of additional fields.
  • Any messages where the audience type is set to
    Secure
    , or the severity type set to
    Audit
    . Secure messages can only be logged by the FactoryTalk AssetCentre software product to the FactoryTalk Audit Log.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal