Integrations

Software that integrates with popular platforms

In today's world companies often use multiple pieces of software. This makes sense as each can be good at the job it is doing.
Prospero is good at integrating these different data sources.

Prospero Apps

Prospero ERP

Integrate third party software with Prospero Enterprise Resource Planning ERP system

For instance, integrate Shopify products and orders into Prospero ERP.

Prospero Manufacturing

Prospero KPI Agent

Prospero Power BI application on Microsoft App Source for analysis of FreeAgent data.

Power BI

More


Bookkeeping, store, payment and EPOS apps

FreeAgent

Experience of integrating with FreeAgent

FreeAgent

MStore EPOS

MStore is an EPOS system. Electronic point of sale.
Sometimes used in tourist destinations for ticket sales.

Prospero has done some works:

  • MStore to SQL with a data warehouse style schema
  • SQL to Power BI

QuickBooks

Development sandbox
Programmatic integration
Postman collection

Sage 200

Experience of integrating with Sage 200

Sage 200

Shopify

Development sandbox
Programmatic integration
Postman collection
Products Retrieve and optionally integrate to other systems. For instance, to the Prospero ERP system.
Get orders
Workflow Help with automations which interact with Power Automate flows or other software

Shopify

Stripe

Development sandbox
Programmatic integration
Postman collection
Get products

Xero


Time sheet systems

Time Doctor

From Time Doctor to SQL to Google Sheets

This helps an organisation track their client's monthly time usage against a budget.


Microsoft

Azure DevOps

Automated and scheduled migration of work items.

Integrate work items with other parts of the application such as:

  • Time Sheets
  • Journal

Dynamics 365 and Dataverse

Programmatic integration with Dynamics 365 and the Microsoft dataverse

Examples:

  • Knowledge to website

Microsoft Graph

Microsoft Graph is a way of programmatically taking actions in Microsoft 365.

Power BI

Source

Target

FreeAgent

Power BI

FreeAgent Microsoft Excel Bespoke Database

Power BI

SharePoint

Programmatic integration with SharePoint

Programmatically update metadata


Google

Google Sheets

For instance:

  • Time Doctor to SQL Azure on a schedule
  • Sums in SQL
  • SQL to Google Sheets on a schedule


Other

Bespoke Integrations

Q. Does your manufacturing, bookkeeping, accounts or CRM system miss a feature you would really like to see?
A. Let Prospero import the data and then extend the database schema providing you with extra reporting or a bespoke UI interface.
App Data

Prospero Tailored App

FreeAgent Microsoft Excel Bespoke Database

Data Migration

Automated and scheduled migration.
Likely to require bespoke mapping in-between

Saves manual input time and improves accuracy