How to create database in thingworx?

[Surekha]

Hi,

   How can I Create and Maintain Database (Tables with Relations) in Thingworx?

Regards,

Surekha N.

[CarlesColl]

If it's a simple database without relations, you can use out of the box DataTables objects.

Otherwise you will have to use the JDBC connector (http://support.ptc.com/help/thingworx_hc/thingworx_7_hc/#page/ThingWorx_Help_Center%2FThingWorxHelpCenterDITAFiles%2FThingWorxExtensibility%2FJDBCExtension%2FJDBCExtension.html%23) in order to connect to an external database and work with it.

[slangley]

Hi @Surekha.

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

Regards.

--Sharon

[Surekha]

Hi @slangley ,
I want to create relational database with in thingworx. But above mentioned is not that.
Regards,
Surekha N.

[slangley]

Hi @Surekha.

Take a look at this link to see if it provides the information needed.  There is also an extension available in the PTC Marketplace to speed up the process of connecting to relational databases.

If this does not answer your question, please provide specifics around your use case to help us gain a better understanding of your needs.

Regards.

--Sharon

[Surekha]

Hi @slangley,

 I'm not asking about connecting to an external relational database. I would like to create and maintain a relational database within thingworx platform.

Regards,

Surekha N.

[slangley · Accepted solution]

Hi @Surekha.

Apologies for the misunderstanding.

It's not clear what your intent is but this link may be helpful.  Note there are several other links to resources that can help you determine the best architectural design for your environment.

Once you have reviewed this information, please let us know if you have further questions.  We will need to be provided with details of your requirements to provide appropriate answers.

Regards.

--Sharon

[slangley]

Hi @Surekha.

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

Regards.

--Sharon