The following steps will guide you through setting up custom data source:
(Note: Assuming a typical install IPORTAL_ROOT is:
iServer Express - C:\Program Files\Actuate9\iServer\servletcontainer\iportal
iPortal Workgroup - C:\Program Files\Actuate9\iPortal\webapps\iportal)
1. Create a directory "MySQL" under IPORTAL_ROOT\iportal\bizRD\oda
2. Copy Query.jsp to IPORTAL_ROOT\iportal\bizRD\oda\MySQL
3. Copy CustomBrsQuery.jar to IPORTAL_ROOT\WEB-INF\lib. The source code for the custom query is located in the .jar file for your reference
4. Edit database.properties to include your JDBC Driver class, connection URL, database username, and password
5. Place database.properties in IPORTAL_ROOT\WEB-INF\
6. Copy the JDBC driver to be used into IPORTAL_ROOT\WEB-INF\lib
7. Edit the web.xml file located in IPORTAL_ROOT\WEB-INF\. After the definition of the OdaSampleServlet add:
< servlet >
< servlet-name >CustomQueryServlet< /servlet-name >
< servlet-class >com.actuate.erni.oda.ClassicModels.CustomQueryServlet< /servlet-class >
< /servlet >
8. Within the same file add the following after servlet mapping definition for OdaSampleServlet:
< servlet-mapping >
< servlet-name >CustomQueryServlet< /servlet-name >
< url-pattern >/CustomQuery< /url-pattern >
< /servlet-mapping >
9. Edit erni_config.xml located in IPORTAL_ROOT\WEB-INF\. Add the following after the odaconfig for OdaSample:
< odaconfig >
< name >CustomQueryBuilder< /name >
< displayName >Enter your own query...< /displayName >
< description >Connection to yodatabase< /description >
< datasetExtensionId >org.eclipse.datatools.connectivity.oda.flatfile.dataSet< /datasetExtensionId >
< datasourceExtensionId >org.eclipse.datatools.connectivity.oda.dataSource< /datasourceExtensionId >
< enabledInWorkgroupMode >true< /enabledInWorkgroupMode >
< enabledInEnterpriseMode >true< /enabledInEnterpriseMode >
< entryPoint >/CustomQuery< /entryPoint >
< /odaconfig >
10. Restart iServer Express/iPortal service for the changes to take effect.
Ashwini
DevShare
(0 reviews, 4998 views)
Download (19.93 KB)
iServer Express
