We are trying to connect a ColdFusion Engine to Google Bigquery.
Solaris / Linux OS
CFML Engine: ColdFusion or Lucee
We have tried the Simba JDBC Drivers provided by Google but the connection does not work, using a service account. OAuth is not something that is viable in that case.
Was wondering if anyone has tried the Java Class files to instantiate a connection and query a dataset in BigQuery.
Just looking for a Starting point in terms of setting up the connection and a basic query.
If someone got the Simba Driver working and have an example of the connection I am game for that too.
I found this page which seems to have the steps laid out nicely for using their driver - Query BigQuery Data in ColdFusion