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-Peridot
    17-Peridot
    January 31, 2023

    Hello,

     

    Okay. Do you mean you want to run your thingworx instance together with the database you are hosting there?

    Or do you just want to  get some data from it?

     

    I am not familiar with this particular hosting platform so I can't say for sure this will work.

    But normally if it is a MSSQL database you would use the "Database" base thing template when creating a thing.

    This will give you a configuration page on that thing that looks like this:

     

    jensc_0-1675155069665.png

     

    In this configuration page you would provide the connection string (similar to what you would use when connecting to your database using for example SSMS (SQL server management studio).

     

    You also need to provide an account to use.

     

    Once you save the configuration, you can go to the "properties and alerts" page of the thing and check if it has connected:

    jensc_1-1675155738049.png

     

    These are just the steps that we use to connect to our internal MSSQL databases. So you might need to try and find some other drivers if you are using a different database.

     

    Regards,

    Jens

     

    Terms & ConditionsCookie settingsAccessibility statement