Skip to Content
Technical Articles
Author's profile photo Vishnu Reddy

BOExcelAdapter Configuration in BODS on Linux

Purpose :

The purpose of this document is to configure the BOExcelAdapter in BODS on Linux.

 

Procedure : 

Step by Step procedure to configure the BOExcelAdapter in BODS on Linux.

 

  1. Create the Access Server on Job Server (follow below steps)

cd /usr/sap/<SID>/BOBI/dataservices/bin

./svrcfg

4 : Configure Access Server

c : Create a new access server entry

Directory               : <Mention the Directory>

Communication Port [4000]  : <Mention the Port>

Parameters              : <NA>

Use SSL protocol ‘Y|N’ [Y]: Y

Enable Access Server [Y]: Y

 

Once access Server is configured then go to Data Services Link, you will Access Server.

 

Now Click on Access Server –> Add

Fill the details and then Apply

Once applied you will be able to see the entry like below

 

2. Enable the Adaptive Server in Job Server

cd /usr/sap/<SID>/BOBI/dataservices/bin

./svrcfg

2 : Configure Job Server

Enter Option: e

Enter serial number of Job Server to edit: 1

Enter TCP Port Number for Job Server <JobServer_1> [3500]: Mention the correct Port for Job Server

Do you want to manage adapters for the Job Server <JobServer_1> ‘Y|N’ [Y]: Y

Do you want to use SSL communication for the adapt management ‘Y|N’ [Y]: Y

Enter Adapter Management Port Number for Job Server <JobServer_1> [4001]: Mention the correct port

Continue to Add/Modify/Delete Job Servers ‘Y/N’ [Y]: N

Once above step is completed Adapter Instance will be enabled

Note : 4001 is the default port for Adapter Instance

Once Adapter Instance is enabled then in Data services you can see Adapter Instances Dropdown.

 

Click on Adapter Instances –> JobServer –> Adapter Configuration –> Add

Select MSExcelAdapter from the List

Enter the Access Server Host, Port and then apply.

Once BOExcelAdpater is created then start it.

Once above configuration is done then Go to Job Server and set the below PATH(obtained from BOExcelAdpter Confiration) in the env variables.

PATH=$PATH:<Path mentioned in Above Screen in ClassPatH>

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<Path mentioned in Above Screen in ClassPatH>

 

Once all the steps are completed then take a complete restart of Data Services and then you will see the BOExcelAdapter in the system.

Test :

Place the excel spreadsheet on the shared network folder that can be accessed by the job server. Refer to the file in Data Services as below:

 

Summary:

Once you Configure the BOExcelAdapter in the BODS, you will be able to retrieve the data from excel.

 

Please do share feedback or thoughts in a comment section and also follow my profile for similar content.

 

Thank you

Vishnu Reddy..

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Joseph Muiruri
      Joseph Muiruri

      Nice blog Vishnu Reddy ,

      One thing to keep in mind regarding the Access Server in the adapter configuration. If you are not planning to use the adapter with real time jobs, it's best to leave the Access Server host and access server port blank in the adapter configuration.

      Otherwise, if you set it and then the Access Server for some reason encounters a problem, the adapter will also fail. Therefore there is no point setting the Access Server if you are not planning to use the adapter with real time jobs.

      For instance in production you don't want your jobs to fail because the Access Server which you are not actually using fails for some reason.

      Best regards,

      Joseph

      Author's profile photo Vishnu Reddy
      Vishnu Reddy
      Blog Post Author

      Hello Joseph Muiruri

      Absolutely correct, Configure the Access server only when it is required otherwise you may encounter the problems related to Access server.

       

      Thank you

      Vishnu Reddy..