ESdat Forums
»
Forums
»
ESdat
»
Connecting to QGIS
 Rank: Newbie
Groups: Registered
Posts: 4  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!
|
|
|
|
 Rank: Member
Groups: Registered
Posts: 11  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
|
|
|
|
 Rank: Newbie
Groups: Registered
Posts: 4  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.
|
|
|
|
 Rank: Administration
Groups: Registered, Administrators Posts: 71  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
|
|
|
|
 Rank: Advanced Member
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.
|
 1 user thanked JKW for this useful post.
|
|
|
 Rank: Newbie
Groups: Registered
Posts: 4  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!
|
|
|
|
 Rank: Advanced Member
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
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Connecting to QGIS
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.