Skip to main content
S
saguiarde1-Visitor
1-Visitor
June 2, 2020
Solved

BigQuery Connection

  • June 2, 2020
  • 2 replies
  • 1206 views

Hi all, Is there any suggested way to connect to BigQuery from Google Cloud without using ThingWorx Flow? Would you recommend to create an external service using one of the SDKs? I guess that will take some work. Or is there any other way that I might not be aware?

Thanks! 

Best answer by slangley

Hi @saguiarde.

 

We do support connections via jdbc to third party databases.  Basically, you'll need to follow these instructions:

 

  1. Download the jdbc driver from BigQuery
  2. Copy the driver to <tomcat_home>\lib
  3. Restart Tomcat
  4. In Composer, create a Database thing
  5. In the Configuration tab for the Database thing, enter the details for connecting to your database

We don't test connections to all databases, therefore, if you run into issues, you may want to take the SDK route or post your additional questions here for follow up from other community members that may have some experience with this.

 

Regards.

 

--Sharon

 

2 replies

S
slangleyCommunity ManagerAnswer
Support
June 2, 2020

Hi @saguiarde.

 

We do support connections via jdbc to third party databases.  Basically, you'll need to follow these instructions:

 

  1. Download the jdbc driver from BigQuery
  2. Copy the driver to <tomcat_home>\lib
  3. Restart Tomcat
  4. In Composer, create a Database thing
  5. In the Configuration tab for the Database thing, enter the details for connecting to your database

We don't test connections to all databases, therefore, if you run into issues, you may want to take the SDK route or post your additional questions here for follow up from other community members that may have some experience with this.

 

Regards.

 

--Sharon

 

S
slangleyCommunity Manager
Support
June 10, 2020

Hi @saguiarde.

 

If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others on the community.  if you still have questions, please let us know.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement