Load the imported excel data to a Database like SQL server

0
Hello Community, I am new to Mendix and still learning to develop something that aligns with our requirements.   One part of the requirement is to give a flexibility to the team to import an excel based on a format and then once the data is imported to the Mendix layer, I need to load the data to another database like SQL Server…   If anyone could help that would be great!.. Thanks in advance
asked
1 answers
0

Hello,

First you have to import the DatabaseConnector module to your project https://marketplace.mendix.com/link/component/2888

 

Now you need to build your own SQL query statement to execute via the ExecuteQuery or ExecuteStatement Java actions from DatabaseConnector module.

ExecuteStatement is used to INSERT, UPDATE, DELETE & DDL queries.  

 

For more details refer this https://docs.mendix.com/appstore/connectors/database-connector/

 

Hope it helps!

answered