This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello. Looking to see if anyone as connected to an actual JIRA database (not through the URL connector)? If so, how have you done this? I tried as a SQL connection, but got error messages.
I tried the JIRA connector that is in the gallery, but is is to limiting (unless i am using it wrong) with the 1,000 row and 1 project limit. I have access to the database, but now can't connect. It just times out.
I don't have a definite answer for you but maybe some pointers for you to look next.
1) From your error message, it seems that the connection is failing to be established, I don't have much knowledge/experience with database management but could it be a firewall or some other mechanism in place preventing you from connecting to the database? Have you tried connecting to the DB using some other tool? (SQL server, etc..)
2) Before I learned about the Jira connector, one of my colleagues had developed a similar solution to what the macro uses, downloading the data from Jira using JQL and parsing it out. To get around the issue of downloading 1,000 records at a time, we implemented the solution as a batch macro that would change the starting and ending values of the query in steps of 1,000. So the first iteration would run from 0 to 999, second from 1,000 to 1,999 and so on.