Skip to main content
A
asurana1-Visitor
1-Visitor
September 20, 2017
Question

We are writing lot of information to external postgresSQL database from thingworx using thing created using Database thing template. Information is written to multiple data tables. We have some informaiton which we read from this external database as

  • September 20, 2017
  • 2 replies
  • 982 views

We are writing lot of information to external postgresSQL database from thingworx using thing created using Database thing template. Information is written to multiple data tables. We have some informaiton which we read from this external database as well. From performance perspective what is good way to use Database template to access external database?  Should we create one thing for all datatables or separate thing for each of the data table? Are there any other configurations that we need to take care of when we are using database thing template?

2 replies

S
smanley5-Regular Member
5-Regular Member
September 20, 2017

Hello Atish,

Configuring a database thing for PostgreSQL is very simple. You will need to update the JDBC Driver class name to "org.postgresql.Driver", update your connection string and enter the database username and password. The single database Thing is sufficient to make the connection directly to the database. For a little more context, roughly how often will tables be updated and now may will you be updating from ThingWorx?

V
vranganathan12-Amethyst
12-Amethyst
September 22, 2017

You may not want to configure JDBC connection information in multiple Things. For that reason, one Thing should be suffice. You can categorize the services if you want to easily navigate when you add the service (this could be handy if you have large number of services).

Thanks,

Varathan

Terms & ConditionsAccessibility statement