Home
Extending Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
extensions and modulesThese topics describe how to use built-in database extensions and separately installed modules.
TimeSeries Data User's GuideThe HCL OneDB™ TimeSeries Data User's Guide contains information to assist you in using the TimeSeries extension with HCL OneDB™.
Create and manage a time series through SQLBefore you can load time series data into the database, you must configure database objects specific to your time series. You can manage data storage and remove data as necessary. You can run SQL statements to create and manage time series.
Load data into a time seriesYou can use several methods to load data into the time series. Some methods require you to create the time series instance before you load data.
HCL® OneDB® TimeSeries Plug-in for Data StudioYou can load time-based data into existing time series instances by creating load jobs in the HCL® OneDB® TimeSeries Plug-in for Data Studio.
Creating a load job to load data from a fileUse the HCL® OneDB® TimeSeries Plug-in for Data Studio to create a load job that loads time-based data from a file into existing time series instances.

Creating a load job to load data from a file

Use the HCL® OneDB® TimeSeries Plug-in for Data Studio to create a load job that loads time-based data from a file into existing time series instances.

Before you begin

Loading data from a file has the following additional requirements:

The data can be formatted as a single-delimited, double-delimited, fixed-width, or LSE formatted data stream, for example: one or more files or URLs.
The data must be ASCII characters.
The pipe symbol (|) is interpreted as a delimiter.
Field delimiters can be any ASCII character or regular expression representable in Java™.
The maximum size of the input file is set by your Java implementation.

Procedure

To load data from a file in Data Studio:

Open the appropriate cheat sheet by choosing Help > Cheat Sheets, expand the TimeSeries Data category, choose Loading from a File, and click OK.
Open the cheat sheet by choosing Help > Cheat Sheets, expand the TimeSeries Data category, choose Load time-series data, and click OK.
Follow the instructions in the cheat sheet to create the load job.