Import Data (Aggregate Storage)

Click here for non-aggregate storage version

Import data from text or spreadsheet data files, with or without a rules file. Minimum permission required: Write.

Syntax

Notes

Examples

See Loading Data Using Buffers for an example.

Descriptions

Use import data in the following ways to load data into an aggregate storage database:

Key Phrase Explanation
import database <dbs-name> data from... Specify whether the data import is from a local or server file, and what type of file to import data from.
...using ... rules_file Import data into the database using a specified rules file.
...<data error spec> (on error...) Required. Tell Essbase what to do in case of errors during the data load: abort the operation, or write or append to a specified error log.
...<data record spec> from data_string Load a single data record into the selected database.
...<SQL connect spec> (connect as...) If you are importing data from an SQL source, provide your SQL user name and password. You must always use a rules file when you load SQL data sources.
...to load_buffer with buffer_id If you are importing data from multiple data files and you are using aggregate storage, you can import to a buffer first, in order to make the data import operation more efficient. For more information, see Loading Data Using Buffers.
...from load_buffer with buffer_id If you are importing data from multiple data files and you are using aggregate storage, you can import from a data load buffer in order to make the data import operation more efficient. For more information, see Loading Data Using Buffers.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com