Question

How to export data from Mendix to SQL database table

0

I have added the database connector module, but I don't know how to export data to the SQL server.

asked 2019-10-21

Morodikay Hareruya

3 answers

Sander Suijkerbuijk · Answer 1 · 2019-10-21

Do you only want to export data to the database? Or do you want your mendix application database run on the SQL server?

Gerrit Kiefer · Answer 2 · 2019-10-21

Do you want to run SQL scripts on your Mendix application to the SQL server?

Robert Price · Answer 3 · 2019-10-21

To use the DatabaseConnector you need to build up your own SQL statement to execute via the ExecuteStatement or ExecuteQuery Java Action. ExecuteStatement is for INSERT, UPDATE, DELETE, and DDL queries. ExecuteQuery is for SELECT. or when you need data returned Mendix usually hides this away from you using the built in database functionality, but if you are looking to export to another external database this is something you need to do yourself.

Good luck!