Skip to main content
M
mdeshpande-21-Visitor
1-Visitor
February 20, 2017
Solved

Thingworx Analytics: Send Data From Dataconnect To Analytics Server

  • February 20, 2017
  • 1 reply
  • 14217 views

Hello,

I have just started with thingworx analytics 52.0 and DataConnect 52.0. I have some issues in sending data from dataconnect to analytics server.

I have followed these steps:

1] Set up Analytics Server

2] Import Analytics extension

3] Set up Dataconnect

4] Configure Platform Subsystem with dataconnect params

5] Configure MachineLearningAll thing with Analytics server params

6] Create a Data Analysis definition in TW and execute it

7] The zip file with property data and payload.json are being created in thingworx repository

8] Sending the zip(payload.json+csv) file to analytics server?


Step 8 is where I am facing problems. How to upload the created zip file to the analytics server? Do I have to use the service SubmitUploadDataset?

If so, then I am not able to test the service in Composer. When I Edit the UploadData field and try to add a row it tells me "Must have a datashape defined to add rows".

Am I approaching it the wrong way? Do I need to write a custom service to send the data?

I am having problems with understanding how exactly data from dataconnect is transfered to analytics server. I would appreciate any help on understanding this better and solving the issue.

Thanks & Regards,

Madhumita

    Best answer by cmorfin

    Hi Madhumita

    I think you missed one step during the installation of DataConnect - see the DataConnect User's guide, chapter "Integrate ThingWorx and DataConnect"

    you need to create a symbolic link between /repository and /ThingworxStorage/repository: ln -s /ThingworxStorage/repository /repository .

    Hope this helps

    Kind regards

    Christophe

    1 reply

    C
    cmorfin19-Tanzanite
    19-Tanzanite
    February 20, 2017

    Hi Madhumita

    When all is configured ok, the step 8 is done automatically.

    The flow is:

    1) DAD collect logged data from ThingWorx

    2) DAD send the data (as skinny csv file + payload.json) to DataConnect

    3) DataConnect transform the data and create one single resulting csv file

    4) DataConnect create a dataset inside ThingWorx Analytics Server with the resulting csv file loaded as data. The dataset created has got the same name as the DAD.

    If you do not have a dataset created in ThingWorx Analytics, then you probably have a problem in the configuration or in the way data is collected by the DAD.

    You should start by reviewing the DataConnect log files under /opt/dataconnect/logs.

    Note that I am in the process of writing a blog on this specific topic. I am hoping to have it published by next week.

    If you can wait, I think it would be a good reading to understand how things work.

    If you need further help I would probably recommend to open a case to Technical Support, because that is a topic that may need more data to progress.

    Kind regards

    Christophe

    M
    mdeshpande-21-VisitorAuthor
    1-Visitor
    February 22, 2017

    Hi Christophe,

    Thanks for the help.I will be opening a case for the same.Also looking forward to the blog.

    Thanks & Regards,

    Madhumita

    C
    cmorfin19-Tanzanite
    19-Tanzanite
    February 22, 2017

    Hi Madhumita

    Just to let you know, I have published the blog at :

    How to use DataConnect when sending property values from the ThingWorx platform to ThingWorx Analytics.

    I hope you'll find it of interest

    Kind regards

    Christophe

    Terms & ConditionsAccessibility statement