Getting PowerApps data into on-prem SQL server table without using the SQL Server connector

[Mr0bb0]

Hi all,

I work for a very large organisation and we are unsure as to whether we can cover the licensing fees involved with premium connectors.

I was wondering if there was anyway I can write the fields from a PowerApps form straight to an on-prem SQL server table.

Thanks in advance

[timl]

Hi @Mr0bb0 

There is no way to write fields into a on-prem SQL Server table without a premium license.

Many users here have floated ideas to workaround this licensing issue, none of which have particularly worked in practice.

Without a premium license, the best avenue to explore would be to save your data into SharePoint, or some other data source that uses standard connector, and to create some process outside of PowerApps to move that data into your SQL Server database.

[Mr0bb0]

Thanks for that timl.

I've just been looking into the patch function. This seems to write to SQL server from PowerApps, does this also need a SQL connector?

[timl]

Hi @Mr0bb0 

Yes, the patch function also accesses SQL Server through the SQL connector, and therefore also requires a premium license.

The other point to mention is that because you are using an on-prem instance of SQL Server, this requires the on premises gateway and using this will always require a premium license.

[Mr0bb0]

Thanks again timl,

Do you know if the premium connector would only be required for the developer or for all users?

[timl]

Hi @Mr0bb0 

The premium connector would be required for all users.

[Mr0bb0]

Thanks again,

Unfortunately I don't think that is going to be an option as we have several thousand staff.

Microsoft's pricing is confusing and doesn't seem best suited to catering for large companies .