Webinar (on-demand): OutSystems and Analytics Integration: A New Strategy to Reduce Costs

Discover everything you need to know about Hubway Connect

Try the product online without any installation or purchase commitment
Hubway Connect

Innovative ways to leverage your data for business outcomes

Find out how Hubway Connect can help you get more value from your OutSystems platform
Hubway Connect

Learn and expand your Hubway Connect knowledge

Deep dive in articles, videos and technical information to maximise its use
Hubway Connect

Start free and expand without surprises

Choose the Hubway Connect offer that best meets your needs and suits your budget
Hubway Connect

We are here to help. Let’s talk.

Connect with us via your preferred channel and we will be happy to answer your questions
Hubway Connect
  1. Home
  2. Knowledge Base
  3. Tutorials
  4. How to consume Hubway Connect service in Microsoft Excel?
  1. Home
  2. Knowledge Base
  3. FAQs
  4. Data Analysis
  5. How to consume Hubway Connect service in Microsoft Excel?

How to consume Hubway Connect service in Microsoft Excel?

Copy the Test or Production service links from the Builder Project.

 

consume Hubway service in Microsoft Excel
Consume Hubway Connect service in Microsoft Excel

 

Open Microsoft Excel and create a Blank Worksheet.

Go to Data → Get Data → From Other sources → From OData Feed

In the OData feed popup, select the basic radio button, and paste the service link you copied from builder Project. Type your OutSystems runtime username and password when prompted.

Excel will now connect to Hubway and seamlessly fetch all the Entities that are part of your project. Select all the Entities that are needed for your analysis and click Load.

You can establish relationships between Entities within excel by going to Data → Relationship icon under Data Tools section of the menu.

 

Hubway service in Microsoft Excel
Hubway service in Microsoft Excel

Here you can create a new relationship between entities by selecting the Related Tables and their Primary and Foreign Key columns.

 

Hubway service in Microsoft Excel
Hubway service in Microsoft Excel

 

You are now set to build insightful analytics leveraging the power of Hubway.

Taking the Order Manager service as an example, you can build a visual of the Total Order amount per Product Category by going to Insert → Pivot Charts → Pivot Charts and Pivot Table under the Charts section of the menu.

In the Pivot Charts Field, select the related fields to build the chart as below:

 

Hubway service in Microsoft Excel
Hubway service in Microsoft Excel

 

Hubway service in Microsoft Excel
Hubway Connect service in Microsoft Excel
Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support