Skip to main content
Solved

DB access in the Clod version of SysAid


Forum|alt.badge.img

Hello!

My company has just transitioned from SysAid on premises to SysAid in the Cloud.

I now need to migrate my code that accessed SysAid DB directly from local to Cloud.

Can anyone help mw, by explaining what my options are?

Can I still access the DB even in the cloud?

Or do I have to use REST API?

Or perhaps some other option.

 

Thank you in advance

Rudy

Best answer by AlexanderChr

Hi @rgireyev

 

SysAid provides an API that allows you to retrieve, create, and modify specific information based on your requirements. For more details on our API integration, please refer to the documentation here.

Additionally, you can find SysAid Rest API Details here.

Hope this helps! :) 

 

Have a good one!

 

View original
Did this topic help you find an answer to your question?

4 replies

AlexanderChr
SysAider
Forum|alt.badge.img+1

Hi @rgireyev,

 

Direct access to the Cloud database is not feasible, but there is an option to get daily database backups.

The Cloud database type is MySQL, and once the option is enabled for Database and/or Attachments backup delivery (need to contact SysAid Support to enable the option to download),  it can be downloaded from the SysAid Settings page from:

Settings >> Customize >> Event Logs

You can open a ticket with our Support Team and they will provide you the instructions on how to get the database backup.

 

Hope this helps.

 

Have a nice day!


Forum|alt.badge.img
  • Author
  • Community Enthusiast
  • 9 replies
  • November 28, 2023

Thank you @AlexanderChr.

 

I will run this option by my supervisors and see what they say.

Just in case they are not willing to go this route, is there another way to get those values? Maybe a REST API call or something like that.

Do you need to know which table I’m hitting? I’m hoping for a generic API that will allow me to hit any table. But if there is not. My first need is to get the values from the service_req table.

 

TIA

Rudy

 


AlexanderChr
SysAider
Forum|alt.badge.img+1
  • SysAider
  • 18 replies
  • Answer
  • November 29, 2023

Hi @rgireyev

 

SysAid provides an API that allows you to retrieve, create, and modify specific information based on your requirements. For more details on our API integration, please refer to the documentation here.

Additionally, you can find SysAid Rest API Details here.

Hope this helps! :) 

 

Have a good one!

 


Forum|alt.badge.img
  • Author
  • Community Enthusiast
  • 9 replies
  • November 30, 2023

Thank you @AlexanderChr 

I see that the Login endpoint wants a username and password.

How would I set that up?

Also, if I should use the account_id where would I find it?

 

TIA

Rudy


Want Some cookies?

No, literally. We have some. 😉 By continuing browsing on our site you agree to our cookie policy.

 
Cookie settings