Users can use Salesforce data source for their reporting purpose in TIBCO JasperReports® Server 6.2.1. Previous release versions of JasperReports® Server product do not implement and were not certified with salesforce data source therefore it is not supportable. Users can try the following as a work around through JNDI connection in JasperReports Server 6.1 in order to use SalesForce DS. Jaspersoft Tech Support will not able to provide any assitnace for this approach should it not work for any reason, however.
Download the driver from saleforce driver 5_1_4.zip, or use the driver found in JasperReports Server 6.2.1 product buildomatic/tools directory.
Unzip and place the driver under jasperserver-pro 6.1 WEB-INFlib directory.
Add the following into your META-INF/context.xml, replace value in {} with yours as appropriate:
<Resource name="jdbc/salesforce" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="{username@salesforce.com}" password="{passowrd}" driverClassName="tibcosoftware.jdbc.sforce.SForceDriver" accessToUnderlyingConnectionAllowed = "true" testOnBorrow="true" url="jdbc:tibcosoftware:sforce://{domain.salesforce.com};User={username@salesforce.com};SecurityToken={token!@#$%};Password={password};TransactionMode=ignore" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory"/>Restart server.
Test this JNDI connection in JasperReports Server .
TTC-20160531
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now