JASP and MS Fabric Data Warehouse / Azure SQL Connection
I searched GitHub but did not see this so I thought I would ask. I saw back in JASP 0.16.4 there was an option added to connect directly to a SQL Database. However that looked to be something on the same network (on-premises SQL Server). With the growing use of things like Azure or really in my case Microsoft Fabric has there been any discussion about connecting directly to MS Fabric SQL Endpoint? I can see connecting to an online Data Warehouse, Lakehouse, or SQL Server via SQL Server Endpoint would be very helpful.
WE use MS Fabric Dataflows Gen2 to land survey stuff into an MS Fabric warehouse. The warehouse has a SQL endpoint. SQL View or other tools could transform the data as needed and JASP could connect for statistical needs in a nice GUI environment.
Tools like Asure Data Studio (ADS) and the MS SQL Extension for VS Code are all open source and might provide a cross platform framework for how to connect to the online SQL endpoints.
Is this something on the roadmap?
thanks
Alan
Comments
Does this not do what you want? It's in the hamburger menu under Open -> Database
Thanks for a repose, but that is for a "local" database not a cloud one.
It is more a connection like this
Hi Alan,
I think this might be more of a feature request for the development team's attention. This is because it now seems apparent that the software doesn't yet have this feature. For some guidance on how to make an issue (although I think I've seen you do that before?) See: How to Request a Feature or Report a Bug in JASP - JASP - Free and User-Friendly Statistical Software
Apologies I couldn't help with this directly, but, I'm just another user!
Best,
Tarandeep
thanks @TarandeepKang ,
I figured it would be a feature request, but wondered if anyone could share if it was being discussed on a road map or if the team was not even interested. I will submit a feature request.
thanks
Alan
It is a good feature request, we will discuss this in the team
thanks EJ, You all already support connecting to the Open Science Framework so I know connecting to Online Sources is not out of the question. Hopefully it is something you all could implement as more systems move online.
As a work around I was going to connect Excel to to Fabric SQL Endpoint for the warehouse via Power Query In Excel (done that many times). Thought that would be nice as I could do any extra transformations in Power Query. Then have JASP just open the Excel file. However I have since learned JASP only supports opening simple Excel files (don't understand all the details). I am hoping that better Excel support (is on the roadmap). Things like selecting a Specific sheet or even an Excel Table when opening n Excel file. With Table usage growing in Excel that would be helpful to many.
thanks
Agreed! But do let us know on our GitHub page!
EJ
For others interested and want to add support, ideas or development the Github Issue is #3353