Skip to end of banner
Go to start of banner

Is Excel alike dealing with sensorEDGE's aggregated IO-Link sensor data - as the real-time processing platform e.g. 'Streamsheets' is offering it - possible?

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Q

Is Excel alike dealing with sensorEDGE's aggregated IO-Link sensor data - as the real-time processing platform e.g. 'Streamsheets' is offering it - possible?

A

Yes this is possible since the sensorEDGE solution is providing the IO-Link-sensor data on MQTT over an Internet hosted MQTT broker.

STEP 1:

For a simple test sign up for a trial playground account under https://cedalo.com/pro-streamsheets/trial-signup/ and confirm your email address.

STEP 2:

You will be receiving another email including your personal cloud hosted Streamsheets Pro URL and username and password. Use the given credentials to login.

STEP 3:

Create a new Streamsheets App in your workspace by clicking the "+" in the top right corner. Give the app a name. Using a template is not necessary.

STEP 4:

Create a new connection of type MQTT by clicking the icon  and the "+" and then on "MQTT"

STEP 5:

Watch your "sensorEDGE data service credentials" page in your www.sensoredge.io account.

Copy and paste the information Username/Password/Endpoint URL from the page into the Streamsheets MQTT "Settings" form. Uncheck the "Validate CA Certificate" checkbox!

Click the Streamsheets MQTT "Subscriptions" tab.



Click the "+" and copy and paste the base topic into the Topic row of exactly that sensorEDGE device you want to subscribe to to receive data. Makr sure the topic name ends with a hash "#".




See also...

  • No labels