Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
DJH  
#1 Posted : Friday, June 20, 2025 8:39:11 AM(UTC)
DJH
Rank: Newbie

Reputation:

Groups: Registered
Posts: 4
Australia
Location: Melbourne

Hi there, has anyone managed to set up a link into QGIS to an ESdat AZURE db? We can do this in Arc and other spatial platforms (like Leapfrog) but QGis isnt working. 

Thanks!

Marc W  
#2 Posted : Sunday, June 22, 2025 8:33:54 PM(UTC)
Marc W
Rank: Member

Reputation:

Groups: Registered
Posts: 11
Australia
Location: Ocean Shores

Thanks: 1 times

Hi DJH,

I haven't, but would like to know how you went about adding ESdat into AZURE. I'd like to access in sharepoint (link with other tables), and Azure is one way i think we can do it.

Regards 

DJH  
#3 Posted : Monday, June 23, 2025 8:50:54 AM(UTC)
DJH
Rank: Newbie

Reputation:

Groups: Registered
Posts: 4
Australia
Location: Melbourne

Hi Marc,

Our ESdat server subscription is cross-regions and, as I understand it, the way to make it work was an Azure setup, I could have this wrong though. This was setup by EScis, not us. Our server connection works in the O365 environment, like PowerBI, but havent tried a sharepoint connection. 

Kimberley_Support  
#4 Posted : Monday, June 23, 2025 9:50:41 AM(UTC)
Kimberley_Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 71
Australia
Location: Sydney

Thanks: 2 times
Was thanked: 9 time(s) in 9 post(s)

Hi DJH,

I checked in with the Dev team and it appears that QGIS doesn't support direct ODBC or OData endpoint connectivity.

Is there another format that you could stage the data in and then run a refresh?

Regards

​​​​​​​Kim

JKW  
#5 Posted : Monday, June 23, 2025 10:11:16 AM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 86

Was thanked: 1 time(s) in 1 post(s)

I DJH, 

Yes we have it working perfectly.

We have our own server for ESdat, which may be a factor. First we have a VIEW saved that has a defined field:

geometry::STPointFromText('POINT(' + STR(l.x_coord, 10, 2) + ' ' + STR(l.y_coord, 10, 2) + ')'

Then the method is setting up a SQL Connection in QGIS then using the Data manager and MS SQL Connection.

THEN - this is the real trick -U use VIRTUAL LAYERS to create a Query with whatever SiteID (SID you want)

This is hugely useful. You just repoint the virtual layer at whatever site you want -have pre defined symbols and the instant map move.

thanks 1 user thanked JKW for this useful post.
Kimberley_Support on 6/23/2025(UTC)
DJH  
#6 Posted : Monday, June 23, 2025 11:45:16 AM(UTC)
DJH
Rank: Newbie

Reputation:

Groups: Registered
Posts: 4
Australia
Location: Melbourne

Thanks for the responses @Kimberley and @JKW

It seems to be an incompatibility in QGis with ODBC and our version of ESdat server. QGis can connect to ODBC but I think the server needs to be different. 

Thanks!

JKW  
#7 Posted : Tuesday, June 24, 2025 1:58:56 PM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 86

Was thanked: 1 time(s) in 1 post(s)

Which version you running Dan? 

We using SQL Server ver 15.xxx if that helps? 

Casn catch up irl to discuss

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.