Load Data

Load data. Loading data is the process of inserting values into an Essbase cube, using a source of data and a rule file. The source of data can be a file, a SQL Source, or a defined Datasource in Essbase.

To run this job, you must have at least Database Manager permission.

Select a workflow:

• Load Data From File
• Load Data From SQL Source
• Load Data From Datasource

Load Data From File

This procedure describes how to load data using the File load type.

To load data from a file:

1. On the Applications page, click Jobs.

2. From the New Job menu, select Load Data.

3. Select the application and the database.

4. For the Load Type, select File.

   
   
   
   
   

5. Click Add New Row .

6. Click Add file next to Data file and browse to the data files you want to load, select them and click Select.

7. If you are using rule files, select the Add file option next to Rule file, browse to the rule file you want to use for that data file, select it, and click Select.

8. Select Abort on Error if you want to end the data load if it encounters an error.

9. Click OK.

10. To check the job status, click on the Actions menu to the right of the job and select Job Details. If you are loading more than one data file, there is information in Job Details about each individual data load.

Load Data From SQL Source

This procedure describes how to load data using the SQL load type. Use this type if the load rule itself queries an external source of data. To learn how to set up rules to access external sources of data, refer to Define Rules that Query External Sources.

1. On the Applications page, click Jobs.

2. From the New Job menu, select Load Data.

3. Select the application and the database.

4. For the Load Type, select SQL.

5. For Script, browse the catalog and select the rule file.

6. Do one of the following:

   • If your load rule's connectivity to the external database is based on configured ODBC drivers or a connection string, enter the User Name and Password of a user authorized to access the external database.

   • If your load rule's connectivity to the external database is based on a global or application-level saved in Essbase, click Use Connection Credentials and select the named connection.

     Application-level connections are prefixed with the application name; for example, SAMPLE.OracleDB.

     
     
     
     
     

     Refer to Create a Global Connection and Datasource or Create an Application-Level Connection and Datasource.

7. Select Abort on Error if you want to end the data load if it encounters an error.

8. Click OK.

9. To check the job status, click on the Actions menu to the right of the job and select Job Details. If you are loading more than one data file, there is information in Job Details about each individual data load.

Load Data From Datasource

This procedure describes how to load data using the Datasource load type. This procedure assumes that your load rule's SQL Properties are pointing to a Datasource defined in Essbase, as illustrated in Access External Data Using a Connection and Datasource.

1. On the Applications page, click Jobs.

2. From the New Job menu, select Load Data.

3. Select the application and the database.

4. For the Load Type, select Datasource.

5. For Script, browse the catalog and select the rule file.

   
   
   
   
   

6. Select Abort on Error if you want to end the data load if it encounters an error.

7. Click OK.

8. To check the job status, click on the Actions menu to the right of the job and select Job Details. If you are loading more than one data file, there is information in Job Details about each individual data load.