Open topic with navigation
To insert records into a Vertica database, use the Vertica output engine.
The Vertica output engine uses an XSL template to transform the XML produced by Media Server into a format, such as a CSV file, that can be inserted into the database. It then connects to the database using ODBC and inserts the information using a
COPY <table> FROM LOCAL '<local_file>' DELIMITER '<delimiter>' ENCLOSED BY '<quote>' ESCAPE AS '<escape>'
<table> is the Vertica database table to copy data into. This is read from the
TrackMapping configuration parameter.
<escape> are replaced by values from the corresponding configuration parameters.
To insert records into a Vertica database
Create a new configuration to send to Media Server with the
process action, or open an existing configuration that you want to modify.
[Output] section, add a new output task by setting the
OutputEngineN parameter. You can give the task any name, for example:
[Output] section, create a configuration section for the engine by typing the task name inside square brackets. For example:
In the new section, set the following parameters:
||The output engine to use. Set this parameter to
||The tracks that you want to output, mapped to Vertica database tables.|
||The ODBC connection string to use to connect to the database. For information about how to connect to a Vertica database, refer to the Vertica documentation.|
||(Required only on UNIX platforms) The path of the ODBC driver manager to use.|
||The path to the directory to use for temporary files and saved output.|
The XSL template to use to transform records from analysis engines to a format that can be inserted into the database (such as a CSV file).
||(Optional) The interval between inserting batches of records into the database. The default interval is 60 seconds.|
[VerticaOutput] Type=vertica TrackMapping0=FaceRecog.Result : face_recognition TrackMapping1=Ocr.Result : ocr OdbcConnectionString=DSN=mydb OdbcDriverManager=libodbc.so XMLOutputPath=./tmp XSLTemplate=./xsl/toCSV.xsl
For more information about the parameters that you can set to configure a Vertica output task, refer to the Media Server Reference.
Save and close the configuration file. HPE recommends that you save your configuration files in the location specified by the