Essbase data load through SQL

You need to create system “DSN” for loading data through SQL database.



System DSN is created successfully.


Now you need to create rule file for data load.




You have DSN for SQL server. Go to file and open “Open SQL”, and then you need to select Essbase server information server name, application name and database name.



You have build DNS “bisp”, so you need not to specify connection information again. You need to write SQL statement then click ok and retrieve. You need to enter username/password in SQL Connect and specify Essbase server information click ok.


Set data load properties for building rule file.


Validate the rule file


Save rule file.


There is import and export wizard utility in SQL server, through which you can import data from SQL database into text file. Browse text file and rule file and click ok for loading data in to Essbase.




2 thoughts on “Essbase data load through SQL

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s