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

[asurana]

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?

[smanley]

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?

[vranganathan]

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