HCL OneDB TimeSeries Plug-in for Data Studio

You can load time-based data into existing time series instances by creating load jobs in the HCL® OneDB® TimeSeries Plug-in for Data Studio.

You must have the following prerequisites to create load jobs in the :

• or with the installed.
• An existing table with a TimeSeries column.
• Primary key values in your table and a time series instance that is stored in a container defined for each row. If your primary key has a data type of CHAR(n), and each value is not n bytes long, you must pad the values to be n bytes long or change the data type to VARCHAR(20).
• Connectivity information for the database server that contains the time series table. The connection is created through JDBC.
• A file of time-based data that you want to load into the database or a query to select data from a database.
• A file of time-based data that you want to load into the database.
• The data must be compatible with data types.

A load job consists of the following definitions:

• Record reader definition that describes the source of the data. The data can be in a file or in a database, including a database other than .
• Table definition that describes the schema of the table that has the TimeSeries column.
• Mapping definition that maps the source data to the time series table. If you change your table definition, you must also update the corresponding mapping definition.
• A connection profile for the database.
• A connection profile for the source database, if you are loading data from another database.
• Load properties that describe how the data is loaded.

  Load jobs have the following default properties:

  • Existing records can be updated.
  • The timestamp date format is yyyy-MM-dd HH:mm:ss.
  • Missing rows are created and populated with NULL values.
  • Data loading is distributed among five threads.
  • The data is saved to disk after every KB of data is loaded.
  • The data is attempted to be inserted 10 times before returning a failure.

  You can change these values and set other load job properties, such as logging load errors, by editing load properties in the plug-in.

You can reuse the definitions that you created in other load jobs.

After you create a load job, you can run it from the command line with the command-line loader application.

The maximum number of load jobs you can run simultaneously is limited by the capabilities of your computer.

The includes a cheat sheet that provides detailed instructions for creating load jobs and loading data.

The includes cheat sheets that provide detailed instructions for creating load jobs and loading data.