Skip to main content
J
jaganprasanth1-Visitor
1-Visitor
January 30, 2020
Question

Reg : JDBC configuration

  • January 30, 2020
  • 9 replies
  • 3810 views

I'm trying to set up a connection to a MySQL database that I have. I've installed the JDBC Connector extension from the marketplace and that gave me the JdbcCreator and the JDBCExtentionCreator.

 

Following a PTC document it says to create a new thing and select MySqlServer as the thing template. However, I am unable to see a MySqlServer template.

 

Any ideas? Have I missed something?

9 replies

raluca_edu
raluca_edu17-Peridot
17-Peridot
January 30, 2020

Hi,

 

Please confirm you followed the steps:

 

  • 1. Open the JdbcCreator mashup, click the “Choose File” button and select the JDBC driver file you want to use from your local file system  ----> you need JDBC for mySQL: https://www.mysql.com/products/connector/
  • 2. Click the “Upload” button and a link will be displayed below the buttons, “Download Extension File”
  • 3. Click this link and save the zip file. This is your extension. You can now import this into the Thingworx platform
  • The imported extension will create a Thing Template with the name of the file plus “JDBCTemplate”. For example a file named “myDbFile.jar” would create a Template named “myDbFileJDBCTemplate”
  • Use this template to create a new thing and connect to your data source using JDBC

Hope it helps,

Raluca Edu

J
jaganprasanth1-VisitorAuthor
1-Visitor
January 31, 2020

Thank you for your response.

S
slangleyCommunity Manager
Support
February 12, 2020

Hi @jaganprasanth.

 

If Raluca's suggestions allowed you to solve your issue, please mark the appropriate reply as the Accepted Solution for the benefit of others on the community. 

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement