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