Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved PB connect to Google Big Query – How?

  1. How-to
0
Votes
Undo
  1. Michael Kramer
    Michael Kramer
  2. PowerBuilder
  3. Sunday, 29 October 2023 13:30 PM UTC

Hey All,
Returning to PB community after 4 years absence. Sorry, y'all!

Anybody has any experience connect PB app to Google's Big Query using any kind of DB driver?
These days I sadly do more data then PowerScript. Maybe I can cross back, especially if my PB apps can access Big Query.

Managing Window Inheritance in Projects with and w...
Remote access slow
Accepted Answer
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Monday, 30 October 2023 12:44 PM UTC
  2. PowerBuilder
  3. # Permalink

THX all for your contributions. My summary:
1) JDBC is the better option over ODBC but comes with a support challenge.
2) Alternative, use a C# .NET component to do the Big Query access, use it as an adapter/façade style pattern.

Once I get it working I may post an article since others may also want to query BQ from PB.

Comment
mike S
  1. mike S
  2. Monday, 30 October 2023 13:38 PM UTC
you could also use the PB HTTP client to run the query and get the results, and then push the results into a datawindow/store.

I this for 'external' database queries via ADO.DB though the ole object where i can't use a transaction object in PB (powerserver for example).
  1. Helpful 2
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 30 October 2023 17:31 PM UTC
That would be great Michael!

TIA for sharing.
  1. Helpful
There are no comments made yet.
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 29 October 2023 14:55 PM UTC
  2. PowerBuilder
  3. # 1

Hi Michael, welcome back!

No experience with it, but I'd recommend to go for the JDBC driver, not the ODBC. Appeon now no longer officially supports JDBC, but if you jump through some hoops, it still works. https://www.appeon.com/developers/get-help/knowledgebase/4434

It'll work better than ODBC. Also, don't embedd any stored procedures / function. Use RPC and it should work fine.

I guess there's no need but here's a link: https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

regards.

 

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Sunday, 29 October 2023 22:18 PM UTC
Hi Chris,

A), B) true.

C), our apps run in-house C/S so the security issues are not so big, plus we've eliminated the recent LOG vulnerability.

D) haven't seen any, runs fine on all systems.

E) No deployment issues at all. We have a subfolder with a self-cointained JRE and don't even have to install a client.



I DO wish that Appeon would have an ODBC that works properly with our Tibero databases, but they don't. Loosing the possibility to work with Tibero would be fatal for our company.

regards.
  1. Helpful 1
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Sunday, 29 October 2023 23:59 PM UTC
That's great Miguel but many sites that I know, their production teams do not allow that old JRE to be deployed into production. Especially, after performing a TRA (Threat & Risk Assessment) where that JDK fails.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 30 October 2023 00:04 AM UTC
Hi Michael;

Yes, since PB no longer supports directly calling a Java Class - then a .Net Assembly that be directly called via the DotNetObject in PB would be a good alternate choice IMHO.

Regards ... Chris
  1. Helpful 1
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Sunday, 29 October 2023 17:06 PM UTC
  2. PowerBuilder
  3. # 2

Hi, Michael, welcome back! It's good to hear from you. Unfortunately, all of my data is relatively tiny, so I don't have any experience that will help you out. Please let us know if you find something that works for you?

Best regards, John

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.