Jump to content

Recommended Posts

Posted (edited)

This is indeed a genuine Capita site and is part of the Capita approach to encourage integration with our Education Products. The site has been populated with integration information, worked examples and links to sample code. The content will continue to grow over times. The Technical Integrator Programme that underpins this is open to all levels of organisation from schools/colleges through to individual companies wishing to integrate through to larger integrators. Information on the technical Integrator programme can be found here https://www.capita-sims.co.uk/partner-with-us/becoming-a-sims-partner and Integration resources are available at site you first mentioned https://www.sims-partners.com. If you want to find out more free to look at the sites or make contact to ask more.

 

Darren - Head of SIMS ID & Technical Integrator Programme

Edited by DPepper
Posted
The role of the Technical Integrator Programme is to empower other integrators to extract data from Capita Products and write data back to these products simply. Some integrators have used this route to extract data for analytical purposes by feeding it into systems such as Power BI or similar. Capita is looking at ways that we can simplify this further for all integrators and future customer solutions. If you are keen to use Power BI you may want to see what is available through the Technical Integrator Programme or contact the Technical Partner team.
Posted (edited)

Darren, if Capita is serious about PowerBI integration, you need to create a connector. This will allow schools to go - PowerBI > Get Data > SIMS > Enter connection details \ auth > pick data.

 

No third party can do this. Microsoft only accepts connector submissions from the application owner - ie Capita. This is to stop confusion when you have multi connectors for the same thing. Happy to recommend someone who can do this for you, but I'm afraid they don't work for exposure.

 

Update: Just to confirm the "Capita must create it, not a third party":

Certification Requirements

 

Before starting

 

 

  • Developer must own the data source or have recorded permission from the owner of the data source to develop a connector for it.

 

from: https://docs.microsoft.com/en-us/power-query/connectorcertification?branch=master

Edited by matt40k
  • Thanks 1
  • 7 months later...
Posted
I've just spotted this thread and wondered if it ever progressed any further with integration, we're just looking at the command report utility and export for use with powerBi but if there's a better way .....?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...