New Topic

Community Topic Idea Integration

Mark McGuire

Yellowfin Support Team

Assigned

Category Integration

Product Version 9.0

PostgreSQL sources do not have the procedure option within Yellowfin

Pratap Singh shared this idea ago

Completed

PostgreSQL sources do not have the procedure option within Yellowfin. From what we can see this is was due to a change in PostgreSQL JDBC driver: https://github.com/pgjdbc/pgjdbc/issues/1340

In Postgres FUNCTIONs return resultsets, where in other databases, PROCEDUREs do that.

Until recently the getProcedures() call in the PostgreSQL JDBC driver would return functions from Postgres. This allowed functions that returned a resultset to be accessed by Yellowfin.

However, a recent change to the JDBC driver has stopped functions being returned by getProcedures(). This is generally returning nothing, and why the procedures option is not shown in Yellowfin.

We need to change Yellowfin to support Functions to be able to support the functionality that we used to have.

I like this idea 0

Replies (5)

Mark McGuire ●

Hi Pratap,

I hope all is well,

I have since raised this as an Enhancement with our Development team. I will update as and when I can.

Regards,

Mark

Reply URL

Mark McGuire ●

Hi Pratap,

I hope all is well,

I come with news that we have since implemented this Enhancement request. We can find this within our 9.10 release. Because of this I will now mark this ticket as Completed.

Going forward if you have any issues, please let me know. I would be more than happy to assist where I can.

Regards,

Mark

Reply URL

Pratap Singh ●

Hi Mark,
let me know if there is any particular way to define function/procedure in postgre , we tried with 9.12 but not able to go through.
Regards
Pratap

Reply URL

Mark McGuire ●

Hi Pratap,

Are you free for a remote session so we can go over this?

Let me know your availability I am UK based (as you know) and can make myself available from tomorrow between the hours of 09:00-14:30 UK Time.

Regards,

Mark

Reply URL

Mark McGuire ●

Hi Pratap,

I hope all is well,

I just want to inform you that we have a UK Bank Holiday here in the UK on Monday, 26th August so scheduling a remote session in would work for me as of Tuesday. Let me know the date/time so we can connect.

Regards,

Mark

Reply URL

Pratap Singh ●

Hi Mark,
We can connect at 9:00 AM UK Time (1:30 PM IST) on Tuesday.
Regards
Pratap

URL

Mark McGuire ●

Hi Pratap,

I have scheduled this in. I have sent this invite to your email address.

Please inform me of receiving this.

Regards,

Mark

URL

Mark McGuire ●

Hi Pratap,

I hope all is well,

Unfortunately I have to cancel today at 09:00, however we can re-schedule for the same time tomorrow if this works for you?

Please let me know.

Regards,

Mark

URL

Mark McGuire ●

Hi Pratap,

I hope all is well,

I just want to touch base to see if we can get this picked up one of the days this week, I only as as I have some annual leave as of next week so I would like to get this addressed.

If you can get back to me I would appreciate this a lot.

Regards,

Mark

URL

Mark McGuire ●

Hi Pratap,

I just want to touch base to see if you are available for a call tomorrow? As mentioned I am on annual leave as of next week so this might be a case of holding back until I am back or have this escalated. If you can let me know that would be great.

Regards,

Mark

URL

Pratap Singh ●

Hi Mark,
We will have this call once you are back from leave.
Thanks & Regards
Pratap

URL

Mark McGuire ●

Hi Pratap,

Thank you for your patience with this whilst I was away on Annual Leave. Going forward can I ask of your availability for a remote one of the days this week?

I can make myself available between the hours of 09:30-14:00 (UK), Wednesday-Friday.

Let me know.

Regards,

Mark

URL

Mark McGuire ●

Hi Pratap,

I hope all is well,

I just want to touch base to see if we can schedule a remote session. Unfortunately I can't connect tomorrow, however any of the days next week between the hours of 09:30-14:00 UK would work well with me.

I look forward to your response.

Regards,

Mark

URL

Mark McGuire ●

Hi Pratap,

I hope all is well,

I just want to touch base to see if we can schedule something in this week. Unfortunately I can't attend any meetings today (fully booked), however Wednesday onwards I am free. Please let me know what works best for you.

Regards,

Mark

URL

Mark McGuire ●

Hi Pratap,

I hope all is well,

I would like to propose a remote session for tomorrow (Friday) between the hours of 09:30-14:00 UK Time. If you can confirm exact time that suits you, that would be great.

I look forward to your response.

Regards,

Mark

URL

Mark McGuire ●

Hi Pratap,

I have gone ahead and marked this as Completed, if you want to re-open, please do not hesitate to do so, I would be more than happy to assist where I can.

Regards,

Mark

URL