You are not logged in.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

reina

Intermediate

  • "reina" started this thread

Posts: 5

Date of registration: Feb 24th 2011

Location: Estonia

  • Send private message

1

Tuesday, December 13th 2011, 8:06am

Error on Palo ETL Soap Connection over https

I am trying to set up a Palo ETL connection using SOAP and https

I get an error like this (my emphasis):

Quoted

Error parsing wsdl file: WSDLException:
faultCode=OTHER_ERROR: Unable to resolve imported document at
'https://somewebservice.com/importData?wsdl'.: 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, please check the WSDL url in your browser.

Doing a generic google search this seems to be related to certificates in Java.
Before plunging into this, may be someone has checked it out already?

.

reina

Intermediate

  • "reina" started this thread

Posts: 5

Date of registration: Feb 24th 2011

Location: Estonia

  • Send private message

2

Tuesday, January 3rd 2012, 6:04pm

Have figured out that this is an issue with Java and what is needed is to import certificates to Java, but it has not resulted in a workable solution. (nor the manual method, nor InstallCerts).

Tested with Palo Commercial edition and I get a slightly different error (different machine)

Quoted


The component "SOAPtest" is tested with errors:

Error parsing wsdl file: WSDLException: faultCode=OTHER_ERROR: Unable to resolve imported document at 'https://somewebservice.com/importData?wsdl'.: java.net.SocketException: java.security.NoSuchAlgorithmException:
Error constructing implementation (algorithm: Default, provider: SunJSSE, class: com.sun.net.ssl.internal.ssl.DefaultSSLContextImpl), please check the WSDL url in your browser.

Has anyone ever succeeded to get SOAP over SSL working?

.

Posts: 173

Date of registration: Jan 4th 2008

Location: Freiburg / Germany

  • Send private message

3

Wednesday, January 11th 2012, 3:07pm

SSL is not yet supported in ETL SOAP-Connection but we've planned to work on it.

reina

Intermediate

  • "reina" started this thread

Posts: 5

Date of registration: Feb 24th 2011

Location: Estonia

  • Send private message

4

Wednesday, January 11th 2012, 3:18pm

.
Bad news but thank you for the reply anyway. Took little bit less than a month to figure that out.

I guess the availability of SSL for http based connections is quite crucial (more broadly - Web Services, SOAP or not), especially for companies that use ESB solutions or want to integrate Palo with SaaS applications.

I am not a Java expert but looks like the ETL https capability is more of a configuration / enabling issue than something that needs heavy programming. So, should be a relatively quick fix.

.

tomok

Intermediate

Posts: 11

Date of registration: Dec 8th 2011

  • Send private message

5

Wednesday, January 11th 2012, 8:00pm

I guess the availability of SSL for http based connections is quite crucial (more broadly - Web Services, SOAP or not), especially for companies that use ESB solutions or want to integrate Palo with SaaS applications.

If you need to secure the web-based access to ETL, you can always install something like OpenVPN on the box PALO is running on and then do your connection through a VPN.

reina

Intermediate

  • "reina" started this thread

Posts: 5

Date of registration: Feb 24th 2011

Location: Estonia

  • Send private message

6

Wednesday, January 11th 2012, 8:12pm

.

Quoted

If you need to secure the web-based access to ETL, you can always install something like OpenVPN on the box PALO is running on and then do your connection through a VPN.
... only if the scenario were that the web service endpoint is under my control (having a VPN server or access there), which it isn't.

I guess this is just a minor mishap that support for _outgoing_ https requests are not supported. This is a de facto standard in this SaaSy world of ours. Plus, https is hassle free technology - when it is there, it just works. I would leave all other hacks aside, like a https proxy or using yet another ETL tool just because of the absence of outgoing https...

I just hope that there is nothing 'political' about this feature a la intent to keep Palo isolated from other SaaS based application, but I don't see no logical, business nor technological reasons for that.
.

jdelvat

Professional

Posts: 17

Date of registration: Mar 25th 2009

  • Send private message

7

Friday, June 29th 2012, 3:55pm

Is there any news on this topic?

We are trying to build an ETL connection to SalesForce.com and this requires an https connection to the salesforce.com server.
Obviously, we can't use a VPN to their servers ...

I also tried to download the WSDL to a local file, but that doesn't seem to help.

What's the solution there?

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

8

Monday, July 2nd 2012, 9:21am

I would try getting an extract via Perl with the CPAN-modules e.g. Salesforce or DBD::Salesforce and then feed the resulting CSV-file(s) or database table(s) to ETL-server.

Similar threads

Rate this thread