how do I link my Jaspersoft studio to the server?

0

I have just downloaded and installe JaspeSoft Studio 7.1.0. How do I connect it to our SaaS JasperSoft Server. My understanding is that once I installed the studio I will then link it to the server but I never got to that step in my installation.

Am I missing a step or something in my installation file?

 

victor.jonathan's picture
Joined: Aug 13 2019 - 8:13am
Last seen: 8 months 4 weeks ago

2 Answers:

0

Hi victor.jonathan. 

When in the jasperstudio. Look for the 'Repository' tab.
If yo ucannot find it, in the studio top menu, select 'Window', look for 'Show View' amd then other. In the pop up, look for Repository Explorer. 
Ok so now you should have the 'Repository' tab. Select it and right click on Servers and select the 'create jasperreports server connection'

Now you should be familiar with the normal stuff. i.e. URL etc. 
Not on Organization textbox : for community edition leave it blank for pro I cannot remember excatly, but it might be 'organization' and if you have other organization it might be 'organization/other_org_name' 

Hope this all helps. 
Good luck.

joseng62's picture
751
Joined: Dec 5 2014 - 2:43am
Last seen: 12 hours 51 min ago
0

Thanks Joseng62. I have actually being able to setup the connection to the server except I am still waiting to resolve some issues with our SSL certificates for direct connectivity.

See error here:

Error from JASPERSOFT when testing the Data Adapter connection to CA PPM Development:

 net.sf.jasperreports.engine.JRException: java.sql.SQLException: Error Occured.Please check Data Adapter configuration values.

               at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:130)

               at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122)

               at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:155)

               at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51)

               at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLException: Error Occured.Please check Data Adapter configuration values.

               at com.jaspersoft.web.rest.JasperRestConnector.validateAdapterConfiguration(JasperRestConnector.java:616)

               at com.jaspersoft.jdbc.driver.JasperDriver.connect(JasperDriver.java:62)

               at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:168)

               at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)

               ... 4 more

Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

               at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)

               at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1959)

               at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302)

               at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:296)

               at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1514)

               at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)

               at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1026)

               at sun.security.ssl.Handshaker.process_record(Handshaker.java:961)

               at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1072)

               at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)

               at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)

               at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397)

               at sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:559)

               at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185)

               at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(HttpURLConnection.java:1334)

               at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1309)

               at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:259)

               at com.jaspersoft.web.rest.JasperRestConnector.validateAdapterConfiguration(JasperRestConnector

victor.jonathan's picture
Joined: Aug 13 2019 - 8:13am
Last seen: 8 months 4 weeks ago
Feedback