BOExcelAdapter Configuration in BODS on Linux
The purpose of this document is to configure the BOExcelAdapter in BODS on Linux.
Step by Step procedure to configure the BOExcelAdapter in BODS on Linux.
- Create the Access Server on Job Server (follow below steps)
4 : Configure Access Server
c : Create a new access server entry
Directory : <Mention the Directory>
Communication Port  : <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
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> : 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> : 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.
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:
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.
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.
Hello Joseph Muiruri
Absolutely correct, Configure the Access server only when it is required otherwise you may encounter the problems related to Access server.