Use connector apps for Jira Cloud Private IPs not allowed

[Ratom]

Hi,

I try to use  connector app to unload Jira data into SQL Server, and got this message during connection phase:

 Error: Private IP address is not allowed.

I understand that I can not control IP used on Jira cloud,  Looking at the link below I don't see that those are in private range. So I'm totally confused. I'm using Alpha Serve SQL connector in this case. How I can solve this issue.?

https://support.atlassian.com/organization-administration/docs/ip-addresses-and-domains-for-atlassian-cloud-products/

13.52.5.96/28    

13.236.8.224/28

18.136.214.96/28

.......

.......

2401:1d80:3000:100::/61

2401:1d80:3000:200::/61

2401:1d80:3000:300::/61

Thanks

Dima

[Daniel Belevtsov]

Greetings,

Here is a reply from Alpha Serve support.

Our application cannot access any SQL server deployed locally - in other words, any server with a private IP address (you mentioned the corresponding ranges previously). Consequently, it is expected that you get the "Error: Private IP address is not allowed" message during the connection validation:

As of now, utilizing a public IP address is the only viable option for the plugin. Alternative solutions simply do not exist within our current framework.

Should you require more clarification or assistance, please turn to our Support team at https://aserve.atlassian.net/servicedesk/customer/portal/41

Thanks,
Daniel

[marc -Collabello--Phase Locked-]

You can't connect SQL server to Jira cloud.  There's no user accessible SQL database.

[Ratom]

Thanks Marc,

Wow that a blow,  I was able to use their PowerBI connector. Probably MS doesn't like Atlassian.

Probably we can invent some NAT table to translate private  Jira cloud IP into public??

 The private IP address ranges defined in RFC 1918 are as follows:

– 10.0.0.0 to 10.255.255.255 (10.0.0.0/8)
– 172.16.0.0 to 172.31.255.255 (172.16.0.0/12)
– 192.168.0.0 to 192.168.255.255 (192.168.0.0/16)