cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

BigQuery Connection

saguiarde
10-Marble

BigQuery Connection

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! 

ACCEPTED SOLUTION

Accepted Solutions
slangley
23-Emerald II
(To:saguiarde)

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

 

View solution in original post

2 REPLIES 2
slangley
23-Emerald II
(To:saguiarde)

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
23-Emerald II
(To: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

Announcements


Top Tags