hello
i am brand new to Mantis, and have been asked if i ca export data out of it, into an Azure database using MS Data Factory.
at the moment, i am hooking into my data via a php script, in PowerBI using a cookie string, but it is too slow these days.
i am looking to connect to Mantis, and simply extract the data out of the mantis db somehow into a standard sql db
ta
how can i integrate MantisBT with MS Azure Data Factory
Moderators: Developer, Contributor
Re: how can i integrate MantisBT with MS Azure Data Factory
there are several ways to do that, on the one hand you have a rest api and of course you can access the db via odbc.
So whatever please you, that is the way forward
So whatever please you, that is the way forward
Re: how can i integrate MantisBT with MS Azure Data Factory
hi cas
does the underlying database store the data in a usable form, to access directly then ?
the version i am having to deal with only enables me to use SOAP, and I cannot find a suitable API to read Issues.
ta
does the underlying database store the data in a usable form, to access directly then ?
the version i am having to deal with only enables me to use SOAP, and I cannot find a suitable API to read Issues.
ta
Re: how can i integrate MantisBT with MS Azure Data Factory
It is a MySql database in general although other databases are supported, possibly you should look into that area.
Still using ODBC you gan get all data from/into the database
Still using ODBC you gan get all data from/into the database
Re: how can i integrate MantisBT with MS Azure Data Factory
hi cas, thanks, i'll give that a go
meanwhile, i did manage to extract via the SOAP API using HTTP and XML in Azure.
only problem there is the SOAP APIs are limited.
cheers
g
meanwhile, i did manage to extract via the SOAP API using HTTP and XML in Azure.
only problem there is the SOAP APIs are limited.
cheers
g