I need to fetch JIRA ticket data and store it in my Oracle database using their REST API. I’m trying to use PL/SQL to make the HTTP requests but I’m having trouble with the authentication part. When I use the utl_http package, I can’t figure out how to properly send my JIRA credentials (username and password) with the request. The connection fails because of authentication issues. Has anyone successfully integrated JIRA with Oracle database using PL/SQL? What’s the correct way to handle basic authentication when calling JIRA’s REST endpoints from PL/SQL code?
Use utl_http.set_authentication() instead of manual headers - it’s way easier. Just call it before utl_http.begin_request() and pass your JIRA username/password directly. Worked for me when basic auth kept failing with manual headers.
Skip the PL/SQL headache completely. I wasted weeks fighting Oracle’s HTTP libraries and auth issues before finding a way better solution.
Forget utl_http and SSL wallets - use Latenode for the JIRA API calls instead. It handles JIRA connections with token auth perfectly, then dumps everything straight into Oracle.
I built our ticket pipeline this way. Latenode pulls JIRA data hourly, transforms whatever you need, and loads it into Oracle tables. No more SSL cert hell or auth debugging sessions.
You get error handling, retries, and logging out of the box. Easy to add validation or formatting before database insertion too.
Takes 30 minutes vs days of PL/SQL pain. Check it out: https://latenode.com
Had the same authentication headaches with JIRA and Oracle PL/SQL. First, make sure you’re encoding your credentials right - base64 encode ‘username:password’ and stick it in the Authorization header as ‘Basic [encoded_string]’. But honestly, skip basic auth and use API tokens instead. Way more secure. Just create one in your JIRA account settings and use it with your username. Oh, and don’t forget SSL wallets if you’re on HTTPS - your requests will bomb out before they even hit authentication without them.
I’ve dealt with this exact problem. First, fix your Oracle wallet setup - call utl_http.set_wallet() before any HTTPS requests to JIRA Cloud. Without it, SSL handshake fails before auth even runs. Also, JIRA Cloud killed basic auth on most endpoints, so grab a personal access token instead. Create one in JIRA, then use your email as username and the token as password. Test with a simple GET to /rest/api/2/myself first to make sure auth works before trying ticket queries.