ServiceNow Rest Message Interface to Google BigQuery

[art_anderson2]

Hey there my friendly folks,

We are instantiating a new interface from ServiceNow to Google BigQuery.  Currently this interface is to Oracle and we are transitioning to Google.

We are attempting to use the "Magnitude Simba Google BigQuery JDBC Data Connector".

I have:

• loaded the libraries into a target folder outside of the MID Server Agents i.e. F:\ServiceNow\Google_BigQuery
• added a Windows OS CLASSPATH environment variable to this location
• added wrapper.java.classpath.3=F:\ServiceNow\Google_BigQuery\*.jar to wrapper-override.conf

since we were not yet successful I also

• included all the .jar files individually in the "MID Server Jar files" and they auto loaded to <agent>\extlib
• have also restarted the agent several times and rebooted the server a couple times

Our Data Source we have set up two JDBC format records (to be able to switch back and fourth between attempts)

• "GCP - Class=DataSource"   with a value of:   com.simba.googlebigquery.jdbc.DataSource
• "GCP - Class-Driver"   with a value of:   com.simba.googlebigquery.jdbc.Driver

We have tried several URL formats

• jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=<Our_Projet_Name>;OAuthType=0;OAuthServiceAcctEmail=<Our_BigQuery_EMail_ID>;OAuthPvtKeyPath=F:\ServiceNow\Google_BigQuery\<Our_Secure_Key_File>.json;
• jdbc:bigquery://;https://www.googleapis.com/bigquery/v2:443;ProjectId=<Our_Projet_Name>;OAuthType=0;OAuthServiceAcctEmail=<Our_BigQuery_EMail_ID>;OAuthPvtKeyPath=F:\ServiceNow\Google_BigQuery\<Our_Secure_Key_File>.json;
• jdbc:bigquery://www.googleapis.com/bigquery/v2:443;ProjectId=<Our_Projet_Name>;OAuthType=0;OAuthServiceAcctEmail=<Our_BigQuery_EMail_ID>;OAuthPvtKeyPath=F:\ServiceNow\Google_BigQuery\<Our_Secure_Key_File>.json;
• I have also tried "OAuthType=1", with this, I get a Google Authentication error.
  • According to out BigQuery folks, our account has indeed been set up as a Service Account (OAuth "0")
• Also tried various OAuthPvtKeyPath formats
  • F:\ServiceNow\Google_BigQuery\<Our_Secure_Key_File>.json
  • F:\\ServiceNow\\Google_BigQuery\\<Our_Secure_Key_File>.json
  • F:/ServiceNow/Google_BigQuery/<Our_Secure_Key_File>.json
• And several other combinations of the overall URL connection string

The current failure message is:

• MID Server reported error: java.util.ServiceConfigurationError: io.grpc.NameResolverProvider: Provider io.grpc.googleapis.GoogleCloudToProdExperimentalNameResolverProvider could not be instantiated
  
  • ... bunch of "at" messages" ...
• Caused by: java.lang.NoSuchMethodError: 'void io.grpc.googleapis.GoogleCloudToProdNameResolverProvider.<init>(java.lang.String)'
  • ... additiional "at" messages ... etc.

We have worked on this for several days and I am simply at a loss.

Thanks much,

Art Anderson

art.anderson2@boeing.com