Skip to main content
C
czemuja1-Visitor
1-Visitor
January 8, 2019
Solved

External database connection guide for ThingWorx v8

  • January 8, 2019
  • 1 reply
  • 2284 views

Hi, 

I am researching possibilities of Thingworx platform. 

One on the requirements I have, is to connect to external database and display it's data in the mashup (I have MSSQL and PostgreSQL database engines). Also I would like to modify records in that database (i.e. submitting value from mashup).

 

There are few guides for older versions of Thingworx platform, but those seems outdated and confusing when it comes to downloading jdbs drivers and creating Database things.

 

Can you include a simple guide here, or narrrow my searches and give us a clue how to accomplish that.

 

Thank you in advance,

Jarek

 

 

Best answer by slangley

Hi @czemuja.

 

You can refer to the help on JDBC Extensibility for creating your own extension.  You will need to supply the JDBC driver from the vendor and the connection string.  In a sub-topic, there are some examples for your reference.

 

Please let us know if you have further questions.

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity ManagerAnswer
Support
January 11, 2019

Hi @czemuja.

 

You can refer to the help on JDBC Extensibility for creating your own extension.  You will need to supply the JDBC driver from the vendor and the connection string.  In a sub-topic, there are some examples for your reference.

 

Please let us know if you have further questions.

 

Regards.

 

--Sharon

    S
    slangleyCommunity Manager
    Support
    January 25, 2019

    Hi @czemuja.

     

    If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

     

    Regards.

     

    --Sharon

    Terms & ConditionsAccessibility statement