Skip to main content
N
NH_shree14-Alexandrite
14-Alexandrite
January 31, 2023
Solved

How to send the data from a table created in Hostinger Cloud Database to ThingWorx (version 9.3) ?

  • January 31, 2023
  • 1 reply
  • 7438 views

Hi , can anyone help me how to send the data to the properties created in thingworx-thing from the database located in the Hostinger with steps as i am new to use thingworx platform. i tried to import csv file successfully to thingworx but i am unable to find the imported csv file stored in which location inside the thingworx composer, please help me out with this issue , i am expecting some quick reply from community to this message please .

Best answer by jensc

Hello,

 

As I said I'm not really familiar with Hostinger hosting.

But looks like you would need to first give access to your MySQL server; link

 

Then I found this PTC support article on how to connect thingworx to a MySQL DB.

I am not sure if the MySQL JDBC drivers are installed out of the box on thingworx. You might have to follow this support article to get it to work.

There are also some related topics at the very bottom that might be good to read up on.

 

Hope this helps.

 

Regards,

Jens

1 reply

J
jensc17-Peridot
17-Peridot
January 31, 2023

Hello,

 

I am not really sure what your problem is.

Are you trying to import CSV files or do you want to connect to a database that is hosted on Hostinger?

 

For importing CSV files, you can use the file upload widget:

jensc_0-1675150012285.png

To upload your file to a repository which you will find under "Manage":

jensc_1-1675150055583.png

You can also upload the file directly into the repository if you want.

Then you can use the CSVParser to read the file and import whatever data you need from it.

Here you can read more about the CSV parser.

Here you can see how you can use the CSV parser.

 

If you want to connect to an external database you need to create a thing that is using the database base thing template:

jensc_2-1675150368752.png

Then in the configuration of this thing you would add your configurations for the database.

I couldn't really find any good guides on how to do this. But it is pretty self explanatory. If you need more help though, don't hesitate to ask here again.

 

Regards,

Jens

    N
    NH_shree14-AlexandriteAuthor
    14-Alexandrite
    January 31, 2023

    Hi @jensc ,

    Exactly I want to connect on a database that is hosted on hostinger , but i am not sure how to connect my thingworx to hostinger database.

     

    Regards,

    Shree

     

    J
    jensc17-PeridotAnswer
    17-Peridot
    January 31, 2023

    Hello,

     

    As I said I'm not really familiar with Hostinger hosting.

    But looks like you would need to first give access to your MySQL server; link

     

    Then I found this PTC support article on how to connect thingworx to a MySQL DB.

    I am not sure if the MySQL JDBC drivers are installed out of the box on thingworx. You might have to follow this support article to get it to work.

    There are also some related topics at the very bottom that might be good to read up on.

     

    Hope this helps.

     

    Regards,

    Jens

      Terms & ConditionsCookie settingsAccessibility statement