Skip to main content
D
DivyaMalika1-Visitor
1-Visitor
October 10, 2020
Solved

Inherit "JDBC Settings" via "Configuration Table" from Thing Template to its Things

  • October 10, 2020
  • 2 replies
  • 2189 views

Here is my requirement:

 

I have a "Thing Template" which establishes connection to an external database (JDBC - MSSQL). Now, I want to import all the entities from Development Environment to Testing & Production Environments. I want to update/set the "Configuration Table - ConnectionInfo" with new JDBC settings of new Environments. 

 

In the above scenario, once I change the settings on "Thing Template" can all the "Things" imported inherit the new settings? These "Things" have many services developed by different developers. I just want the JDBC settings to be updated from its Thing Template.

 

Instead of changing and tracking "Things", am trying to change it, at one place (Thing Template). Any ideas or suggestions?

Best answer by DivyaMalika

In my case, developers of different modules have different JDBC Settings (local environments) to test their scripts and services. In order to achieve this, I provided a thing template (database inherited) for individual module developers and wrote a service to set the configuration table, by using "Get Implementing Things" of the Thing Template I provided. This way, I need not to track the list of things from developers and also invoking the above service in the form of API at the end of deployment.

2 replies

C
Ciprian-Traian5-Regular Member
5-Regular Member
October 12, 2020

Hello @ @DivyaMalika ,

 

The Thing will inherit the settings from the ThingTemplate. If you change the settings for the JDBC connection from the ThingTemplate and then create Things that will reuse the ThingTempate, the Things will use the updated configurations from the ThingTemplate.

D
DivyaMalika1-VisitorAuthor
1-Visitor
October 12, 2020

Hi Ciprian-Traian,

 

Thanks for your reply. But in my requirement, "Things" are being imported from one environment to another environment. I cannot freshly create those things.

S
slangleyCommunity Manager
Support
October 23, 2020

Hi @DivyaMalika.

 

If you have resolved your issue, please mark the appropriate response as the Accepted Solution for the benefit of others with the same issue.  If you have found your own solution, it would be helpful for the community if you posted it and marked that response as the Accepted Solution.

 

Thank you for your participation in our community!

 

Regards.

 

--Sharon

C
Ciprian-Traian5-Regular Member
5-Regular Member
October 12, 2020


Hello @@DivyaMalika ,

 

After changing the settings in the ThingTemplate, the changes will be propagated in the Things. When importing all the entities (including the Things) with the new JDBC settings you want to import as well the ThingTemplate you have used to create the Things in the first place.

D
DivyaMalika1-VisitorAuthorAnswer
1-Visitor
October 27, 2020

In my case, developers of different modules have different JDBC Settings (local environments) to test their scripts and services. In order to achieve this, I provided a thing template (database inherited) for individual module developers and wrote a service to set the configuration table, by using "Get Implementing Things" of the Thing Template I provided. This way, I need not to track the list of things from developers and also invoking the above service in the form of API at the end of deployment.

Terms & ConditionsAccessibility statement