We are new users and want to connect to the Samanage database for mining, reporting and other ETL types of tasks.
Hi Tom, welcome to the Samanage Community!
There isn't a direct pipe to our databases at present, but there are some options to pull your data out depending on how robust you'd like to get. There are csv exports from most areas of the application, as well as a full zip of your account in Setup > Assets. Obviously this is going to be more manual.
If you wanted to automate, you would need to make an API call and return data in XML or json format. You can pass date parameters in a curl request, and you'd want to make some checks to be sure you had all the data you are looking for. In short, you'd need to start building your data using the REST API.
Happy to dive in some more if you'd like. You can DM me here, or give a quick shout to your Customer Success Manager. Thanks!
Retrieving data ...