Connecting ColdFusion to Google Bigquery -

we trying connect coldfusion engine google bigquery.

solaris / linux os
cfml engine: coldfusion or lucee

we have tried simba jdbc drivers provided google connection not work, using service account. oauth not viable in case.

was wondering if has tried java class files instantiate connection , query dataset in bigquery.

just looking starting point in terms of setting connection , basic query.

if got simba driver working , have example of connection game too.

https://cloud.google.com/bigquery/partners/simba-drivers/

i found page seems have steps laid out nicely using driver - query bigquery data in coldfusion

write standard coldfusion data access code connect bigquery data.

the cdata jdbc driver bigquery seamlessly integrates connectivity bigquery data rapid development tools in coldfusion. article shows how connect bigquery data in coldfusion , query bigquery tables.

create jdbc data source bigquery in coldfusion

the jdbc data source enables execute sql standard coldfusion tags cfquery , cfscript executequery.

1. copy driver jar , .lic file installation directory onto coldfusion classpath. example, copy files c:\mycoldfusiondirectory\cfusion\wwwroot\web-inf\lib. or, open java , jvm page in coldfusion administrator , enter path files in coldfusion class path box.

the jar , license driver located in lib subfolder of installation directory.

restart server after step.

2. add driver data source:

from coldfusion administrator interface, expand data & services node , click data sources. in add new data source section, enter name data source , select other in driver menu.

3. populate driver properties:

   • jdbc url: enter connection properties in jdbc url. jdbc url begins jdbc:googlebigquery: , followed connection properties in semicolon-separated list of name=value pairs. typical jdbc url below:

jdbc:googlebigquery:datasetid=mydatasetid;projectid=myprojectid;initiateoauth=getandrefresh

google uses oauth authentication standard. access google apis on behalf on individual users, can use embedded credentials or can register own oauth app.

oauth enables use service account connect on behalf of users in google apps domain. authenticate service account, need register application obtain oauth jwt values.

in addition oauth values, need specify datasetid , projectid. see "getting started" chapter of documentation guide using oauth.

• driver class: enter driver class. driver class cdata.jdbc.googlebigquery.googlebigquerydriver.
  driver name: enter user-defined name driver.
  username: enter username used authenticate.
  password: enter password used authenticate.
  

• driver name: enter user-defined name driver.

• username: enter username used authenticate.

• password: enter password used authenticate.

you can test connection enabling cdata bigquery data source in actions column. after reporting status of ok, bigquery data source ready use.