Open topic with navigation

# ODBC Output Engine Configuration Parameters

The ODBC output engine inserts information produced by 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 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 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 `ODBC`.
XMLOutputPath | The path and file name for pre- and post- XML files.
XSLTemplate | The XSL template to apply to Media Server output to transform it into values that can be inserted into the database.

© 2016 Hewlett Packard Enterprise Development LP | Send documentation feedback to HPE Close We welcome your comments! 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. Product: Topic Title: Help Topic: Feedback:

_HP_HTML5_bannerTitle.htm