Load data into OACS by the rule files present in on-premises.

Introduction

This Blog will walk through the steps to load data into Oracle Analytics Cloud Service (OACS) using the rule files from on premise.

Load data into OACS:

There are different ways for loading data into the (OACS) cloud

       1.You can create rules files in the cloud service (OACS) rules editor.

       2.Data can be loaded into the cloud using the rules files of on-premise Essbase version of (11.1.24).

Note: Here we used the rule files which is present in on-premise (11.1.24) version of Essbase for loading data. Using Option 2 from above.

For more detailed instructions on how to get rules files from on premise follow the below steps:

1. To create an Essbase Rules Files, you have the following options  
2. Expand the Application >>
3. Expand the Database >>
4. Right Click on ‘Rules Files’ >>
5. Select ‘Create Rules Files’ or you can use the existing rules files it just depends on your data and what you are trying to load.

Loading data into XmlDb:

• Select the XmlDb and click on Inspect option at the top left corner of home page. As shown in the Fig1.1

Fig:1.1

• Select the Files tab and click on the Upload-Files Button as you need to upload the data files and rules files. As Shown in the fig:2.2
• File Name pattern for uploading these files must have less than 30 characters

Fig:2.2

• The rules file should have ‘*.rul’ appended & once the file upload is complete Click -> Close.Fig3.3

Fig:3.3

• The data load file should be ‘*.txt’ appended & once the file upload is complete Click-> Close  Fig:4.4

Fig4.4

• Return to the Home Page & Click ->Jobs.
• Select the New job and choose Load Data as the job type. For reference Fig 5.5

Fig:5.5

• Select the required fields i.e. Application, Database, Script & Data File fields
• Click ->OK.. Job will start Execute & Status of the job is displayed in next screen shot Fig:6.6

Fig:6.6

• The status of the job is “In-Progress” and Refresh the page. Look into the Fig 7.7

Fig:7.7

• Once the jobs status turned into success state, it means the records loaded successfully. Fig:8.8 

Fig:8.8

• Return to the Home page, Choose Analyze Data option in the bottom left corner of home page to have a quick look into data which loaded from the above step. Fig9.9

Fig9.9

• You can see the Adhoc analysis it same as the SmartView data in the fields. Fig 10

Fig:10