To configure an output task to insert information into a database, follow these steps.
To insert information into a database
Create a new configuration or open an existing configuration to send to Media Server with the process
action. Alternatively, you can modify the Media Server configuration file (mediaserver.cfg
).
In the [Output]
section, add a new output task by setting the OutputEngineN
parameter. You can give the task any name, for example:
[Output] OutputEngine0=MyDatabase
Below the [Output]
section, create a configuration section for the engine by typing the task name inside square brackets. For example:
[MyDatabase]
In the new section, set the following parameters:
Type
|
The output engine to use. Set this parameter to ODBC . |
Input
|
(Optional) A comma-separated list of the tracks that contain information you want to output. Specify one or more tracks. If you do not set this parameter, the engine outputs all tracks that are configured by default as 'output' tracks. For information about whether a track is considered an 'output' track, refer to documentation for your analysis, encoding, and ESP engines in the Media Server Reference. |
OdbcConnectionString
|
The ODBC connection string to use to connect to the database. |
OdbcDriverManager
|
(Linux only) The path of the ODBC driver manager shared library. This parameter is not required if you are running Media Server on Windows. |
XSLTemplate
|
The path to the XSL template to use to extract values from records and construct a list of queries to run against the database. |
Configure how to combine records into SQL queries. For more information about how you can combine records, see Choose How to Output Data.
Mode=SingleRecord
.Mode=Time
and use the OutputInterval
parameter to specify the amount of video content represented by each document.Mode=Event
and use the EventTrack
parameter to specify the event track.Mode=BoundedEvent
and use the EventTrack
parameter to specify the event track.Mode=AtEnd
.Mode=Page
.Save and close the configuration file. If you modified the Media Server configuration file, you must restart Media Server for your changes to take effect.
Example
The following is an example configuration to output data using the ODBC output engine.
[MyDatabase] Type=odbc OdbcConnectionString=DSN=MyDSN; Mode=singlerecord XslTemplate=./xsl/toODBC.xsl SavePreXML=true SavePostXML=true XMLOutputPath=./output/odbc/%segment.type%_%segment.sequence%.xml
|