HPE Media Server includes an example SQL script, configuration file, and XSL template that demonstrate how to output data to a database through ODBC.
The example configuration runs OCR and speech-to-text on a video file or stream. It also encodes the video to disk in 30 second segments.
Speech-to-text requires an IDOL Speech Server. If you want to run a task from the example configuration, define the location of the Speech Server in your HPE Media Server configuration file, by setting the SpeechToTextServers
parameter in the [Resources]
section.
The example includes the following files:
configurations/broadcast_schema.sql
is an example SQL script that creates tables in your database to store information about the processed video, and information extracted by OCR and speech-to-text. If you want to run a task from the example configuration, use this script to create the required tables in your database.configurations/broadcastODBC.cfg
is an example configuration file that outputs data through ODBC. Before starting a process
action with this configuration, make the following changes:
[ODBC]
section, set the configuration parameter ODBCConnectionString
to the connection string to use to connect to your database.[SpeechToText]
section and set the SpeechToTextServers
parameter to the host name and ACI port of your Speech Server.xsl/toODBC.xsl
is an XSL template that takes the data produced by HPE Media Server and creates transactions for inserting the data into the database.
|