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