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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

How to create database in thingworx?

Surekha
12-Amethyst

How to create database in thingworx?

Hi,

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

 

Regards,

Surekha N.

1 ACCEPTED SOLUTION

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

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

View solution in original post

7 REPLIES 7

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

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
12-Amethyst
(To:slangley)

Hi @slangley ,
I want to create relational database with in thingworx. But above mentioned is not that.
Regards,
Surekha N.
slangley
23-Emerald II
(To:Surekha)

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
12-Amethyst
(To:slangley)

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

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

Top Tags