Forum Discussion
Query Warehouse from PHP app
Hi Everyone.
I'm trying to explore the potential of Fabric. Manage to get gen2 dataflow populating a data warehouse, with pipeline etc, and use the results in Power BI.
If this is providing a lot of possibility, there is still complexe things that I would prefere to treat in a PHP app. especially for visual redenring.
Is there any way to direct query the warehouse from a PHP app (using Doctrine as example) ? Can't find a proper ways in Microsoft guideline.
Thank you for your help.
HI.
I'm using indeed the Microsoft Entra MFA et I have a valid Entra ID.
It seems indeed Port 1433 is not open.... :
7 Replies
Hi yulione,
Haven't tried this myself, but I would suggest to look at the below pieces of documentation/information.
The options you have to connect to it:
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
And this stackoverflow thread about using SQL server connections in PHP programming language:
https://stackoverflow.com/questions/74812451/how-do-i-connect-to-sql-server-with-php
Hi Expiscornovus .
Thank for the reply.
PHP to SQL server is already done as one of my PHP app is working with it already.
Already got the connection string as described and try to connect as for an SQL server. howeer for some reason it doesn't work.
I don't even have credential error. it is just returning no answer at all....
By the way, I'm on a Fabric Trial mode, if this can change anything.
Hi yulione,
Are you using a Entra Id user for authentication or a Entra Id service principal?
Have tried accessing the same warehouse via SSMS, does that work?
Connection through SSMS is not working. Following the method described here : https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
and got an error 53 : Path to network not found (sorry translated from french ^^ )
But I do copy my SQL connection string has said in the method. As it doesn't seems to find the server, I was wondering if the trial mode was not in cause....
Thx
