Creating Data Extract from OneTick

The OneTick connector allows connection to OneMarketData OneTick tick history databases on a polled basis. In general, it is used to retrieve conflated time series data sets. The connector supports either:

q  Execution of a specified OTQ

q  Execution of a specified parameterized OTQ

q  Execution of a custom SQL Query

Steps:

1.     On the New Data Extract page, select OneTick in the Connector drop-down list.

2.     Enter the Context (for example, REMOTE).

3.     Check the Separate DB Name box to generate a separate field for the database name.

4.     Check the Show per symbol errors as warnings box to proceed with warnings in the log if symbol errors are returned.

The result is a fully generated OneTick SQL query. This can be edited as required.

5.     Click  to save and display the details of the data extract.

6.     Click  then  to display the data preview.