BigQuery Connection

[saguiarde]

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! 

[slangley · Accepted solution]

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

[slangley]

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