The answer is: yes, theoretically.

The data access in DNN is realized as a provider, and the provider delivered is the SQL Server Provider. If you write another provider for the data access, you can use whatever database you want.

This is quite complicated. You have to convert all the SQL scripts from T-SQL to the SQL you intend to support (PL/SQL for Oracle, mySQL etc.). And not only the scripts for the core system but for all extensions you use. That means you have to do that for every new version of DNN, any module etc.

There have been projects for an Oracle provider (e.g. AcuitiDP - Oracle Data Provider for DotNetNuke (acuitisolutions.com)) and also mySQL afair, but none of them survived. The one I linked to ended with DNN 6.1.1 - and that is a long time ago.

My recommendation is: stay away from this idea.

Happy DNNing!
Michael

Thanks Michael, your explain clarify all my doubt

Hello Everyone: 

I want to first echo Michael's response.  I also want to be sure that I highlight one more point.  Michael is speaking about the underlying features/functionality that run DNN itself.  

If you have a use case where you want to communicate with another database (of any kind), you can do that from your custom modules.  People have connected to all kinds of databases over the years, including various No-SQL DBs, MySQL, etc.  You just need to be sure the server where the application is being hosted has the appropriate drivers (if necessary), and you have a valid connection string with any firewall openings you may need.  

The question was: is possible to run DNN with other DBMS?

Although Will is right concerning single extensions that need access to any other database, DNN itself needs SQL Server.

I also realized access to other databases using Linked Servers in SQL Server and/or (Web-)APIs that deliver (and/or manipulate if necessary) these data. If that was meant by the question please describe your usecase, I am sure that there are people here who can help.

Happy DNNing!
Michael

Hello Will, hello Michael

my question is about DNN itself, not an extension module

Thanks again

Posted By progmr on 10/23/2023 7:08 AM

Hello Will, hello Michael

my question is about DNN itself, not an extension module

Thanks again

Thanks for the confirmation.  Then, Michael's advice is spot on.  You can indeed do this and there is built-in infrastructure to support it, but it's generally not worth the effort for many.  I even looked at it as a fun side project once to do a MySQL version for a derivative database, but dropped it myself once I saw the amount of effort required for all of the SProcs.