Find Jobs
Hire Freelancers

OBIEE web service in Perl

$250-750 USD

Cancelled
Posted over 10 years ago

$250-750 USD

Paid on delivery
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.
Project ID: 5180449

About the project

2 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $413 USD for this job
User Avatar
I'm pretty sure I can help if the server is indeed giving the expected answers. So I'd be glad to - thank you!
$300 USD in 2 days
4.9 (13 reviews)
4.5
4.5
User Avatar
hello, Could you response the following questions: - could you provide me the web service url? - could you provide me the sample credentials for my testing purpose. - is it OK if we use the serialize-envelop method instead of passing soap based data request? as using this method would be always a valid request, no need to worry about the invalid data type. let me know your response as I am ready to complete this in quick once you agree with my offer above.
$526 USD in 10 days
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Payment method verified
Member since Jan 27, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.