Find Jobs
Hire Freelancers

OBIEE web service in Perl - repost

$30-250 USD

Annullato
Pubblicato più di 10 anni fa

$30-250 USD

Pagato al completamento
I am need of a script to get data from OBIEE Web services. I have done some preliminary work but need some help to complete. Basically I am trying to execute SQL and get results using OBIEE web service. Below is where I am at: #!/usr/bin/perl use warnings; use strict; use diagnostics; use XML::Simple; use Data::Dumper; use Log::Log4perl; use SOAP::Lite 0.65 +trace => 'debug'; #Initialize Logger Log::Log4perl->init("[login to view URL]"); my $logger = Log::Log4perl->get_logger(); my $outputFormat = "SAWRowsetData"; my $SQL = qq(sql); my $sessionID = "session id"; my $soap = SOAP::Lite ->readable(1) ->uri('urn://[login to view URL]') ->proxy( 'http://host:port/analytics/[login to view URL]' ); my $serializer = $soap->serializer(); $serializer->register_ns("urn://[login to view URL]","sawsoap"); my $som = $soap->call('executeSQLQuery', SOAP::Data->name('sawsoap:sql' => $SQL)->type('xsd:string'), SOAP::Data->name('sawsoap:outputFormat' => $outputFormat)->type('sawsoap:XMLQueryOutputFormat'), SOAP::Data->name('sawsoap:executionOptions')->type('sawsoap:XMLQueryExecutionOptions')->value( \SOAP::Data->value( SOAP::Data->name("sawsoap:async")->type("xsd:boolean")->value("?"), SOAP::Data->name("sawsoap:maxRowsPerPage")->type("xsd:int")->value("?"), SOAP::Data->name("sawsoap:refresh")->type("xsd:boolean")->value("?"), SOAP::Data->name("sawsoap:presentationInfo")->type("xsd:boolean")->value("?"), SOAP::Data->name("sawsoap:type")->type("xsd:string")->value("?"))), SOAP::Data->name('sawsoap:sessionID' => $sessionID)->type('xsd:string') ); $logger->info(Dumper $som); here is the soap envelope it produced that works perfectly fine using soapUI <soap:Envelope soap:encodingStyle="[login to view URL]" xmlns:sawsoap="urn://[login to view URL]" xmlns:soap="[login to view URL]" xmlns:soapenc="[login to view URL]" xmlns:xsd="[login to view URL]" xmlns:xsi="[login to view URL]"> <soap:Body> <logon xmlns="urn://[login to view URL]"> <sawsoap:name xsi:type="xsd:string">name</sawsoap:name> <sawsoap:password xsi:type="xsd:string">password</sawsoap:password> </logon> </soap:Body> </soap:Envelope> I checked the OBIEE server and do not see a request. It is generating the right stuff but the request is not getting across.
Rif. progetto: 5182060

Info sul progetto

5 proposte
Progetto a distanza
Attivo 10 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
5 freelance hanno fatto un'offerta media di $106 USD
Avatar dell'utente
i am interested on your Perl webservice project. let me know if you are interested to hire me, marchent
$65 USD in 5 giorni
4,9 (21 valutazioni)
4,6
4,6
Avatar dell'utente
Just repeating my previous bid, in case you're really interested. There's some detective work to be done, and that's not easy. As said, AFAIK there's a license key involved, that you're not mentioning and not using in the code shown. Do you have full access to the server? Does the request not reach your server or is it discarded for some reason? Thank you.
$300 USD in 3 giorni
4,9 (14 valutazioni)
4,5
4,5
Avatar dell'utente
Hello, Previously, I worked on SOAP. But as I remember, I was using LWP::UserAgent module to send queries. If it is possible to test script, I would like to debug and see the result. Regards
$35 USD in 3 giorni
4,5 (8 valutazioni)
4,2
4,2
Avatar dell'utente
I just solved the problem you described so I really hope you will employ me. As you can see this is my first bid on freelancer but I do have a lot of professional experience in Web services and Oracle apps.
$30 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
United States
0,0
0
Metodo di pagamento verificato
Membro dal gen 27, 2013

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.