Open topic with navigation
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 Media Server configuration file, by setting the
SpeechToTextServers parameter in the
The example includes the following files:
configurations/broadcast_schema.sqlis 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
ODBCConnectionStringto the connection string to use to connect to your database.
[SpeechToText]section and set the
SpeechToTextServersparameter to the host name and ACI port of your Speech Server.
xsl/toODBC.xslis an XSL template that takes the data produced by Media Server and creates transactions for inserting the data into the database.