how can i integrate MantisBT with MS Azure Data Factory

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
glen
Posts: 4
Joined: 16 Mar 2021, 10:45

how can i integrate MantisBT with MS Azure Data Factory

Post by glen »

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
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: how can i integrate MantisBT with MS Azure Data Factory

Post by cas »

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 :mrgreen:
glen
Posts: 4
Joined: 16 Mar 2021, 10:45

Re: how can i integrate MantisBT with MS Azure Data Factory

Post by glen »

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
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: how can i integrate MantisBT with MS Azure Data Factory

Post by cas »

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 :mrgreen:
glen
Posts: 4
Joined: 16 Mar 2021, 10:45

Re: how can i integrate MantisBT with MS Azure Data Factory

Post by glen »

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
Post Reply