Open topic with navigation

# ODBCdeprecated Output Engine Configuration Parameters

DEPRECATED:

This output engine is deprecated in HPE Media Server version 11.1 and later.

The engine is still available for existing implementations, but it might be incompatible with new functionality. The engine might be deleted in future.

The ODBC output engine inserts information produced by HPE Media Server into an external database, through ODBC.

The ODBC output engine adds information to the database by running the query:

`INSERT INTO tablename(columns) VALUES values`

where

- `tablename` is the table name you set using TableName.
- `columns` (optional) are the columns specified by Columns.
- `values` are generated by the XSL template specified by XSLTemplate.

This section describes the parameters that you can set in the configuration section for an ODBC output task.

Configuration Parameter | Description
--- | ---
Columns | A comma-separated list of columns that you want to insert data into.
ColumnTypes | A comma-separated list of data types for the columns specified by the Columns parameter.
EventTrack | The track to use as the event track (for event output mode).
Input | A comma-separated list of the tracks that you want to output to the database.
Labels | A comma-separated list of labels (key/value pairs) to add to the output produced by HPE Media Server.
Mode | The output mode, which specifies how to combine records into INSERT queries.
OdbcConnectionString | The ODBC connection string to use to connect to the database.
OdbcDriverManager | The path of the ODBC driver manager shared library. Not required if you are running HPE Media Server on Windows.
OutputInterval | The amount of video content represented by each INSERT query (when you use time output mode).
SavePostXML | Specifies whether to save a copy of the data produced by the XSL transformation.
SavePreXML | Specifies whether to save records received by the output engine.
TableName | The name of the table to insert data into.
Type | The type of output engine to use. Set this parameter to `ODBCdeprecated`.
XMLOutputPath | The path and file name for pre- and post- XML files.
XSLTemplate | The XSL template to apply to HPE Media Server output to transform it into values that can be inserted into the database.

© 2017 Hewlett Packard Enterprise Development LP | Send documentation feedback to HPE Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to AutonomyTPFeedback@hpe.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_HP_HTML5_bannerTitle.htm