Connecting to Firebird from Microsoft PowerApps (maybe via MS SQL server stored procedures?)?

[alexand...@gmail.com]

Hi!

I am trying to develop Microsoft PowerApp that reads the current Power BI context (from the standard 'PowerBIIntegration'.Data (available to the apps from the App Studio) (e.g. the selected article/good with it sales history), calculates the suggested price and that will write this price back into the Firebird database (we use Firebird for our ERP software).

My question is - can PowerApp execut SQL statement, e.g. against ODCB, ADO.NET or similar driver and write data into Firebird database?

AFAIK and as far as I have searched then PowerApps does not support nor ODBC neither ADO.NET (although Power BI supports ODBC in reading mode) and hence Firebird is not supported.

Is it true indeed?

But https://stackoverflow.com/a/45922660/1375882 suggested interesting approch - writing data into MSSQL (which has fine support) and then MSSQL triggers can listen to the MSSQL data changes and execute MSSQL stored procedure than can have referenece to the linked Firebird/ODBC database and in that whay MSSQL triggers are able to create SQL statements and send them via ODBC to Firebird and - as I understand - all this happend in the MSSQL procedure code.

Is it really true that one can call Firebird database (via ODBC) from the regular MSSQL procedure? Is MSSQL so strong?

Is yes, then I can go for PowerApps, MSSQL and Firebird.

Alex

[Mark Rotteveel]

That would probably be a more suitable question to ask on a Microsoft
SQL Server forum than on a Firebird forum, as you're really asking about
a SQL Server feature, not a Firebird feature. That said, yes, you can
call other database from SQL Server, see "linked servers":
https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver15

I'm not sure how well it works.

Mark