DEVELOPER CENTER
I am not a developer so apologise if i use the wrong terminology or if this question has already been answered.
We use various database systems within the company i work for. We would like to pull simPRO into the existing dashboards so we have a single view of our entire business. The dashboard software does not link to API but requires a link to a database. Is it possible to link to the simPRO database or, if not, is it possible to then copy our database data from simPRO, deliver it to a stand alone database on our network which our reporting software could then link to. obviously we would want this to be as accurate as possible so the next question is if going down this route is would we need to periodically force a data refresh and if this has been done before by anyone does it cause any kind of slowdown on simPRO.
Thanks in advance
Database connection for Reporting software
Forum rules
- Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
- No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
- Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
- Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
- Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
- Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
- Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
- Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
-
Lucy Mathie
- Posts: 1
- Joined: Tue Apr 19, 2022 7:53 am
Re: Database connection for Reporting software
Hi Lucy,
Sounds like you're using a pretty old BI dashboard if it can't connect to APIs. Are you sure you don't want to upgrade to something like Microsoft? There's a company called Tuggers that can setup the realtime data automation from Simpro to that along with recreating your dashboards. I don't believe it's possible to connect directly with the simpro database in the way you're suggesting as you would need to be continually pulling the entire database to keep your dashboards up to date. Using the Api and it's webhooks is much more efficient. This sounds more like a question for your Simpro account manager than the API team.
Hope that helps
Michelle
Sounds like you're using a pretty old BI dashboard if it can't connect to APIs. Are you sure you don't want to upgrade to something like Microsoft? There's a company called Tuggers that can setup the realtime data automation from Simpro to that along with recreating your dashboards. I don't believe it's possible to connect directly with the simpro database in the way you're suggesting as you would need to be continually pulling the entire database to keep your dashboards up to date. Using the Api and it's webhooks is much more efficient. This sounds more like a question for your Simpro account manager than the API team.
Hope that helps
Michelle
Dokkit
https://www.dokkit.co.uk
https://www.dokkit.co.uk
Re: Database connection for Reporting software
Hi,
You won't want the whole SimPRO database just to feed a few KPIs in your dashboard. Suggest you look at what you want to display and then gather that data via API. Depending on your Database you maybe able to use it's functionality to make API requests or you may want to create a small custom app to sit on your database server to feed the db the required data. It's not a big mission once you determine your actual requirements.
You won't want the whole SimPRO database just to feed a few KPIs in your dashboard. Suggest you look at what you want to display and then gather that data via API. Depending on your Database you maybe able to use it's functionality to make API requests or you may want to create a small custom app to sit on your database server to feed the db the required data. It's not a big mission once you determine your actual requirements.