Appsheet Integration On-Premise SQL - Connection Problem

[EfeKentli]

When I try to add an on-premises database in AppSheet, it prompts me to use a DreamFactory connection, but I prefer not to use DreamFactory. I have already configured the firewall to allow access to the SQL Server via public IP, and I have also allowed access from AppSheet’s EU IP ranges.In the database connection form, I enter the public IP and port number in the “Server” field, and for the “User Email,” I provide the SQL Server login credentials (email and password) that I created on the SQL Server.However, when I click "Test Connection," I receive a connection error.Could you help me understand what I might be doing wrong and how to fix the issue?

[Steve]

Please contact AppSheet Support for help with this.

[EfeKentli]

I have spoken with AppSheet support, and they mentioned that using DreamFactory is a mandatory requirement for connecting on-premises data. However, I believe there must be alternative methods. For example, wouldn't it be possible to pull data from an on-premises SQL Server into Google Sheets using App Script or a similar solution? When I checked DreamFactory's pricing, I saw that it costs around $1,000–$1,500 per month, which seems unreasonable just for enabling an on-premises SQL data connection. Is there no more cost-effective or even free and secure alternative to establish this connection?