Media Server 23.3

# Configure the Output Task

To configure an output task to insert information into a database, follow these steps.

To insert information into a database

1. Create a new configuration to send to Media Server with the `process` action, or open an existing configuration that you want to modify.

2. In the `[Session]` section, add a new task by setting the `EngineN` parameter. You can give the task any name, for example:

       [Session]
       Engine0=MyDatabase

3. Create a new configuration section to contain the task settings, and 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. OpenText recommends encrypting any connection string that includes a user name or password, before entering it into a session configuration file. Encrypt the entire parameter value (the entire connection string). For information about how to encrypt parameter values, see Encrypt Passwords.
   `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.

4. Configure how to combine records into SQL queries. For more information about how you can combine records, see Choose How to Output Data.

   - To output data in single record mode, set `Mode=SingleRecord`.
   - To output data in time mode, set `Mode=Time` and use the `OutputInterval` parameter to specify the amount of video content represented by each document.
   - To output data in event mode, set `Mode=Event` and use the `EventTrack` parameter to specify the event track. The event track must also be an input track, so include it in the list of tracks specified by the `Input` parameter.
   - To output data in bounded event mode, set `Mode=Bounded` and use the `EventTrack` parameter to specify the event track. The event track must also be an input track, so include it in the list of tracks specified by the `Input` parameter.
   - To output data in at-end mode, set `Mode=AtEnd`.
   - To output data in page mode, set `Mode=Page`.

5. Save and close the configuration file. OpenText recommends that you save your configuration files in the location specified by the `ConfigDirectory` parameter.

Example

The following is an example configuration to output data using the ODBC output engine.

    [MyDatabase]
    Type=odbc
    OdbcConnectionString=DSN=MyDSN;
    Mode=singlerecord
    XslTemplate=toODBC.xsl
    SavePreXML=true
    SavePostXML=true
    XMLOutputPath=./output/odbc/%segment.type%_%segment.sequence%.xml

Copyright 2023 Open Text
Version 23.3 | Last updated June 2023

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Media Server 23.3

Topic Title: Configure the Output Task